[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Cannot Connect to Database Master

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Cannot Connect to Database Master.


Applies to: SharePoint 2010, SQL Server 2008
 

Problem Description.
 

We were installing SharePoint 2010 using the setup user account (we named the account sp_admin). We chose the “Server Farm” installation type with a complete installation. We chose also to run the Configuration Wizard, where we checked the “Run the SharePoint Products Configuration Wizard now” checkbox, and on the “Specify Configuration Database Settings” page of Configuration Wizard we received the following error when we provided the information requested on the page and made a click on the “Next” button:


SharePoint Products Configuration Wizard
Cannot connect to database master at SQL Server at
Gxxxxx.xxxx.com. The database might not exist, or the
current user does not have permission to connect to it.







Cause.


The setup user account needs to be assigned to the dbcreator and securityadmin server roles.



Solution.


Add the setup user account as a login to the SQL Server instance and assign it to the dbcreator and securityadmin server roles, as shown below:



 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.