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