SharePoint 2010 Server Configuration Error -> "Cannot connect to database master"

Posted by Chrish Riis on Server Fault See other posts from Server Fault or by Chrish Riis
Published on 2012-02-21T08:13:27Z Indexed on 2012/11/16 5:02 UTC
Read the original article Hit count: 537

I recieve the following error when I try to configure SharePoint 2010 Server:

"Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current user does not have permission to connect to it."

I run the following setup:

  • Windows Server 2008 R2 Standard with SP1 and all the updates
  • SQL Server 2008 R2 with SP1
  • SharePoint Server 2010 with SP1
  • Everything is installed on the same server (it's a testserver)

I have tried the following:

  • Rebooting the server
  • Checking the install account's DB rights (dbcreator, securityadmin - I even let it have sysadmin)
  • Opened up the firewall on port 1433 and 1434
  • Uninstalled both SQL and SP, then reinstalled the both
  • Enabled all client protocols in SQL Server Configuration
  • Made sure I used the correct account for installing SharePoint (local admin)

Useful links: TCP/IP settings –> http:// blog.vanmeeuwen-online.nl/2010/10/cannot-connect-to-database-master-at.html

http:// ybbest.wordpress.com/2011/04/22/cannot-connect-to-database-master-at-sql-server-at-sql2008r2/

Wrong slash -> http:// yakimadev.com/2010/11/cannot-connect-to-database-master-at-sql-server-at-serverdbname-error-during-sharepoint-2010-products-configuration-wizard-and-installation/

Port error -> http:// www.knowsharepoint.com/2011/08/error-connecting-to-database-server.html

© Server Fault or respective owner

Related posts about sql-server

Related posts about sharepoint