SharePoint 2010 Configuration Wizard – Cannot connect to database master at SQL Server at server_name


This happened today and I’d like to share with you guys. The SharePoint 2010 Configuration Wizard sometimes gives you error messages that can mislead you about the root cause of the problem.  Take the following error message as an example:

“Cannot connect to database master at SQL Server at <server_name>. The
database might not exist, or the current user does not have permission
to connect to it.”

I got this error message trying to run the Configuration Wizard on a WFE server in a farm. I’ve seen several blog posts about this error message and the cause can vary a lot. After checking the possible cause I found out that the server name used by this WFE has already been used by an old server that used to be part of the same farm.

In order to solve it, I removed the old server from the farm using Central Administration, cancelled the configuration wizard and reran it. The wizard worked as a charm.

This kind of experience makes me think: is it so much harder to thrown meaningful error message instead of misleading ones?

Am I being excessively demanding?

See you,

Amadeu.

Advertisements

One Response to SharePoint 2010 Configuration Wizard – Cannot connect to database master at SQL Server at server_name

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: