?
Solved

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

Posted on 2013-02-05
6
Medium Priority
?
1,385 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

764 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