Search This Blog

Monday, January 23, 2012

Cannot connect to database master at SQL during Installation of Sharepoint 2010

Whenever you try to Install Sharepoint 2010 on your server after running the Pre-requisits installer, you might face the issue where you receive the error message as below:

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

This issue usually comes when you try to add database instance name in the Sharepoint 2010 Installation WIzard (when the SQL server is deployed on the server other than the one in which you are installing Sharepoint).

You can follow below steps to resolve this issue.

1) Navigate to Microsoft SQL Server 2008 and open the "SQL Server Configuration Manager".

2) Under the "SQL Server Configuration Manager", select the section "Protocols for MSSQLSERVER" under SQL Server Network Configuration.

3) Ensure that the protocol named TCP/IP is enabled, if its not enable it.

4) Ensure that you restart SQL Server after doing this change from the "SQL Server Services".

No comments:

Post a Comment