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

Faced the same issue while installing CRM 2013.

Rajeev Pentyala - Dynamics CRM Blog

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

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

Restart "MSSQLSERVER" service

  • Resume the installation.

Hope it helps 🙂

View original post

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Share your thoughts

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