Active Directory Rights Management Services
sina2011
Member Posts: 239 ■□□□□□□□□□
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.
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.
Comments
-
unnamedplayer
Member Posts: 74 ■■□□□□□□□□
Is the SQL Server Browser service started on the machine that is hosting SQL Server? -
unnamedplayer
Member Posts: 74 ■■□□□□□□□□
Is there a firewall running on the SQL Server. I had a similar problem where I was trying to connect to a database for some web development work. Enabled remote connections and the SQL Browser service, rebooted and still couldn't connect. Finally realized that Windows firewall was blocking the connections and after disabling it I was able to connect.
-
sina2011
Member Posts: 239 ■□□□□□□□□□
thanks for your reply
yeah Ive also allowed exceptions and it still didnt work and i turned off firewall both ends (ADRMS and on ADRMS Database) -
sina2011
Member Posts: 239 ■□□□□□□□□□
hey everyone Just an update I restarted the whole process by creating fresh virtual machines and it worked must of been some configuration that I did in the lab before.
Thanks.