Sunday, October 30, 2011

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)

While installing MS CRM 2011, i faced this issue.
"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)"

While installing MS CRM 2011, i faced this issue.

to resolve this just check the followings
goto All Programs -> Configuration Tools -> SQL Server Configuration Manager

1. make sure u r using the server name instead IP

2. make sure all the services are running as in the image



3. Also make sure the things are enabled as in the images as below....


Then try to install ms crm and connect to DB. It should connect now.

hope this will help.

3 comments: