Create an installation log file by running the msiexec command line:
- Open an elevated command prompt
- For RMAD type msiexec /i /<pathToRMADSetupFolder>/rmad_x64.msi /l*v Install.log
- For RMADFE type msiexec /i /<pathToRMADFESetupFolder>/rmadFE_x64.msi /l*v Install.log
Review the Install.log file to see if an error similar to the following is logged:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections"
Verify that the SQL server is installed properly and the SQL services are started.
At a minimum, the currently logged in user (running the isntaller) needs to have dbcreator and securityadmin rights on the SQL server.
Please try the following test:
- Anywhere on the RMAD server create a new file named test.udl (note: ensure the extension is udl - may have to rename through command line)
- Double click the file to invoke it
- Enter the name of the SQL server
- Ensure "Use Windows Integrated..." is selected
- Click the dropdown to see if a list of databases are returned. If so, select one and click Test Connection
If the UDL test above fails, there is an issue either connecting to the SQL server or the account does not have sufficient rights.