Solved

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

Posted on 2013-02-05
6
1,336 Views
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.

TIA!
0
Comment
Question by:pbenningfield
  • 3
6 Comments
 
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
http://blogs.technet.com/b/sbs/archive/2011/05/24/you-must-manually-run-psconfig-after-installing-sharepoint-2010-patches.aspx

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
http://technet.microsoft.com/en-US/library/gg680310.aspx
0
 
LVL 2

Author Comment

by:pbenningfield
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.
0
 
LVL 2

Accepted Solution

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

Author Closing Comment

by:pbenningfield
ID: 39017096
No assistance
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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