“Could not open a connection to SQL Server” error while installing CRM 2011 Server

Hi,

You may come across below exception while installing CRM 2011 Server.

“Named Pipes Provider, error: 40 – Could not open a connection to SQL Server “

Scenario :-

• You have a standalone machine “VM 1”, with SQL Server 2008  application
• You have another machine “VM 2”, where you are trying to install “CRM Server” by pointing to the SQL Server on “VM 1”
• Installation wizard throws the “Could not connect to….” exception in the midway

Reason :-

• Remote connection was not enabled on SQL Server machine

Fix :-

• Connect to the machine where SQL Server 2008  installed
• Open the “Sql Server Configuration Manager” (i.e.,  Start –> All Programs –> Microsoft SQL Server 2008 R2 –> Configuration Tools)
• Enable “Named Pipes” protocol (Refer below screen)

• Restart the “MSSQLSERVER” service (Go to “Run -> Services.msc”)

• Resume the installation.

Hope it helps 🙂