Home > Installation, SharePoint 2010 > Cannot connect to database master at SQL server at SQL2008R2

Cannot connect to database master at SQL server at SQL2008R2

When I try to install SharePoint and run the configuration wizard, I got the following SQL error:

Most of the solutions I got from the internet are either dealing with the permissions for the service account or windows firewall that block the TCP/IP port. However, I have doubled checked these and they are all well set. The actual problem was the SQL Server connection settings.SQL Server TCP/IP connection is disabled by default (see screenshot below).

You need to enable the TCP/IP connection settings by going to SQL Server Configuration Manager and you need to restart the SQL Server services to make the changes happen. After the changes, it works like a charm.

Advertisements
  1. March 31, 2012 at 7:42 am

    Time saving post! I was struggling with firewall rules not realizing that my protocols were simply disabled.

  2. March 31, 2012 at 7:43 am

    great post. true time saver!

  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: