Solved

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

Posted on 2013-02-05
6
1,370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 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