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

“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)
Enable "Named Pipes" protocol

Enabling "Named Pipes" protocol

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

Restart "MSSQLSERVER" service

  • Resume the installation.

Hope it helps 🙂

Advertisements
  1. Kevin
    November 11, 2013 at 8:32 PM

    Perfect. Thank you.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: