EricHarlan

SharePoint 2010 RTM Cannot connect to database master at SQL server

Short post but hopefully it provides some value

Ran into a strange issue today. Was working on a SharePoint environment in VM’s.  We ran through our install once and for some reason had to revert back. Once we reverted back for some reason we kept running into the error:

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.

The Database surely existed and I know I had permission. So what changed? Apparently pre-roll back the ports for the database were not opened.

Go to the Database Server > Start > Control Panel > Windows Firewall

On the left side, choose “Advanced Settings”

On the left of the New Advanced Settings window select “Inbound Rules”

One the right side pane,  select “New Rule”

 

Select the “Port” radio button and hit “Next”

Leave “TCP” selected and under “Specific local ports” add “1433-1434” and hit “Next”

Choose how you want to secure the connection and hit “Next”

 

Choose when you want the rules to apply and hit “Next”

Give it a name and a description and hit “Finish”

There you go the error should go away now. Happy installing.

Tagged on:

Leave a Reply

Your email address will not be published.

No seriously, are you human? *