I successfully migrated Root, Compliance, and Inventory. However, I am having issues getting the Web Reports Server installed. The Web Reports Server is being deployed on a separate server from the Root.
I logged into the Web Reports server using a service account with SysAdmin permissions to the SQL server that the reports server will connect to. I chose Single Master Database and Use Remote Databases. Also, the database is configured to use port 1433, so in the hostname field, I tried entering the information several different ways, all with the same result.
Any ideas on how I can get things working correctly?