SCVMM 2022 Install failure - MSSQL database connectivity issue

I think the issue was that I was using the VMServer.ini parameter wrong.

For the "remotedatabaseimpersonation" parameter which before I had set to 1, thinking that I wanted to create the connection to MSSQL as the CitrixRunAs account, I re-read the description for the VMServer.ini parameter and its 0 and 1 options.

"0: Don't impersonate the administrator account for SQL Server. The user that runs setup.exe must be an administrator for the server that is hosting the SQL Server."

That was probably my issue. The CitrixRunAs account definitely isn't an admin for the MSSQL server; it's intentionally a limited-permission account that is intended to do one thing; be the dbo for the VirtualManagerDB. Once I changed that setting to 0 instead of 1, things worked.

This behavior does seem frustratingly obtuse though. Why does any of the users involved - be it the user doing the install of VMM on the VMM server, or the dbo account, need to be an admin on the SQL server?? This shouldn't be typical. I should just have to grant dbo rights to a service account in the SQL management studio, and then VMM's install should use that. My admin account on the SQL server should not need to be involved; if the SQL admin gives permission to the VMM admin to run a database for VMM on their SQL server, pre-creating the DB and granting DBO permissions should be all that is needed!