Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now