BigFix Web Reports server installiation

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?

You mention you always get the same result, but I’m not sure I see what that result is? What message are you getting?

Have you confirmed you can access the SQL database remotely from this computer? By default, the firewall rules on the server hosting SQL don’t get setup to allow remote connections.