SBS 2011, Sharepoint config wizard, cannot connect to database master SQL server

Posted on 2013-02-05
Medium Priority
Last Modified: 2013-03-25
Hello!  In the past few months, my SBS 2011 companyweb stopped working.  Investigation shows share point foundation services not running, so I checked all the usual suspects.  Password/service account, permissions, PSconfig not run after last service pack, etc.  Whatever borked my sharepoint wasn't going to be repaired easily, so uninstall and reinstall I tried.  Upon re-running the Sharepoint Configuration wizard and trying to specify config database settings, I receive "cannot connect to database master at SQL server at server\sharepoint.  The database might not exist, or the current user does not have permission to connect to it".

I am using the administrator account on the server console-- I also cannot connect to sharepoint database using management studio, etc.

Ultimately I want to know:  How do I simply delete the old database if I can't see it in my management tools, recreate the instance and recreate the db's from scratch?  There is NO DATA to be concerned about, if I can get the system to connect to the server instance and simply recreate the database I would be a very happy camper.

Question by:pbenningfield
  • 3
LVL 35

Expert Comment

by:Cris Hanna
ID: 38858013
Well rather than uninstalling and reinstalling you probably should have asked first ;-)
This Microsoft SBS Product Team blog explains the issue

I would go ahead and run it now and see what happens
You can also refer to the SBS 2011 Repair Guide
The specific section on SharePoint is located here

Author Comment

ID: 38859238
Thanks Cris.  There is no data in the share point, and there is no time or money to put into this. I am asking simply "How do I simply delete the old database if I can't see it in my management tools, recreate the instance and recreate the db's from scratch?"

BUT, to address your recommendations:

As I stated in the question, I ran the psconfig command to update first, I suspected that to be the problem immediately.  It errors out with Failed to initialize SharePoint Products upgrade.  I have the entire error, and have already chased the rabbit down that hole, ending up eventually at the second article you reference.  In fact, at step 15 I find the documentation not to match, as I have no selection in the wizard for passphrase or the authentication type.  Completing the "specify configuration database settings" results in "Cannot connect to database master at SQL server..." which is the title and purpose of my post.

Accepted Solution

pbenningfield earned 0 total points
ID: 38958842
Close this please.  No assistance, no answers.

Author Closing Comment

ID: 39017096
No assistance

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question