Hey everyone
Im trying to setup a ADRMS in my lab environment and I'am doing this by following the instructions on the technet page I just have abit of a problem "under To add the AD RMS Server Role" step 13 where it says validate the database instance.
Step 2: Installing and Configuring AD RMS on ADRMS-SRV
I get an error:
"Setup Cannot connect to the specified database Server A network
Setup cannot connect to the specified database server
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
after looking into some sites and trying to find a solution I found out that on the SQL database Engine Remote connections arent allowed so I allowed them by enabling the local and remote connections and enabling using both TCP/IP and named pipes after I did that I restarted the Database Engine on the ADRMS database and also allowed exceptions for remote management in windows firewall after that I tried to do a reconnect to database instance and I got this error:
"Setup cannot connect to the specified database server
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
When I fixed the first issue which was remote connections I knew where to look and figure it out but now with the second error im clueless.
Thanks.
