[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Error when opening  SharePoint 3.0 Centeral Administration, Cannot Connect to the Configuration Database

Posted on 2011-02-19
13
Medium Priority
?
1,671 Views
Last Modified: 2012-05-11
This is a SBS 2008 with SharePoint v3.0 installed.
While trying to do some additional configuration on our Sharepoint site I noticed the task on Administrator Tasks that said
Central Administration application pool account should be unique...

I googled this phrase and then followed the instructions on these two sites:
http://costas.cpstechgroup.com/2008/07/03/wss-30-on-sbs2k8-central-admin-application-pool-account/
and:
http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/1c359912-ac3a-42ad-81b7-f68f7bd9db1c

Which means basically that I
1. Created a new user account. Removed any group memberships it had
2. Ran these three commands
stsadm -o updatefarmcredentials -userlogin spch\wssuser -password <ubercoolpassword>
stsadm -o updateaccountpassword -userlogin spch\wssuser -password <ubercoolpassword> -noadmin
stsadm -o spsearch -farmserviceaccount spch\wssuser -farmservicepassword <ubercoolpassword>
All three finished with no errors
3. Restarted IIS and the sharepoint services

The sharepoint site appears to be working fine, but when I try to open the SharePoint 3.0 Centeral Administration site I get this message:
 Cannot Connect to the Configuration Database Cannot Connect to the Configuration Database

I have spent hours googling this and can't come up with much. What do I need to do to fix this or at the very least revert the user back to the Network Service so that everything is back to how it was.

Security updates were installed a month ago, but when I run a new check for updates I notice that the following are NOT installed and need to be, but at this point I don't want to until this is fixed, unless someone knows that this will actually fix this issue.
- Windows Internal Database Service Pack 3
- Windows SharePoint Services 3.0 Service Pack 2
- Update Rollup 5 for Small Business Server (I can't tell which Rollups are installed, though the BPA says Rollup 4 is not installed either)
0
Comment
Question by:AmbientIT
[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
13 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34936104
This doc explains the error in detail.
http://support.microsoft.com/kb/823287

In your case,i think when you created the user for the app pool ,you did not give that user permissions in sql server.
You'll need to give that a/c permission dbo to these db's
Sharepoint_Config
WSS_Content

and any other Sharepoint database
0
 
LVL 2

Author Comment

by:AmbientIT
ID: 34937979
The only sql database I could find was the one called sbsmonitoring. I assumed it was using the windows internal database. Am I incorrect and if so how do I find and manage the databases?
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34938002
using sql server connect to the sharepoint instance .
Run sp_helpserver in sql server management studio to find out the instances in a server.

Them conenct to the sharepoint instance -should be sqlespress/sharepoint
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 2

Author Comment

by:AmbientIT
ID: 34939886
I was finally able to find and connect to the database. It is indeed the Windows Internal Database, but you can connect to it using SQL Server Management Studio Express if you tell it to connect to database:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Of the five databases that seem to be related to Sharepoint:
- SharePoint_AdminContent_random_looking_set_of_letters_and_numbers
- SharePoint_Config_random_looking_set_of_letters_and_numbers
- ShareWebDB
- WSS_Content
- WSS_Search_WIN-EUGSO7LO7PY

WSS_Content was the only one that didn't have the new user set up with rights. I set it to DBO, but that hasn't fixed it.

By granting DBO rights I mean I went to Databases -> <Specific Database> -> Security -> Users -> spch\wssuser. Then under Role Members I made sure there was a check next to db_owner

Any other ides?
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34944113
make sure the user is dbo in:
SharePoint_AdminContent
SharePoint_Config

0
 
LVL 2

Author Comment

by:AmbientIT
ID: 34944668
The user already had DBO rights on those two
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34945206
Make sure SQL Intance is running by checking your services -also enable sql browser service,check credentials are also ok and IIS isn't in the 5.0 isolation mode. The problem may occur if sharepoint simply can't find the database. Reasons for this may be many: the database has moved, dns has changed, ... In my case was the later. By changing the DNS server in the network we've had to add one more record manually to point to the correct one and the sites started to work

This problem is comprehensively tacled here- have a look at all possible causes.
http://support.microsoft.com/kb/823287

Have a look athis blog too.(lots of brainstorming here)
http://webborg.blogspot.com/2007/05/connect-to-configuration-database-and.html
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34945215
in partiicar try this suggested in the blog

1. Open Server Manager.
2. Click on Roles.
3. Choose Web Server (IIS)
4. Choole IIS.
5. Open server in the Connections panel.
6. Choose Application Pools.
7. For every item in Application Pools, click on it once, and then choose Advanced Settings.
8. Under Process Model, Identity,
change it, choose "Custom Account".
9. Enter an account and password for an account with a lot of permissions. I used the Sysadmin.
10. Restart the Web Server. Then it worked. 

Open in new window

0
 
LVL 2

Author Comment

by:AmbientIT
ID: 34945944
The database is the Windows Internal Database and it is running.

Right now the Identity is set to Network Service for all of them other than the SharePoint Administration one, it is set to the new user I created SPCH\wssuser

I will switch the accounts around that they use later this evening when people aren't using the server.
0
 
LVL 2

Accepted Solution

by:
AmbientIT earned 0 total points
ID: 34948908
I ran the SharePoint Product and Technologies Configuration Wizard found in Administrative Tools. It ran through 10 steps and whatever it did fixed the issue.
0
 
LVL 2

Author Closing Comment

by:AmbientIT
ID: 35015559
This is what fixed my issue
0
 

Expert Comment

by:Raquel Adams
ID: 37650326
I too ran the update and it took down my site. I ran the Wizard, and it was halted by this error
"An exception of type System.Data.SqlClient.SqlException was thrown.  Additional exception information:  Cannot open database "..." requested by the login.  The login failed.  Login failed for '.../Administrator.

What now?
0
 
LVL 1

Expert Comment

by:kinetikk2011
ID: 37779306
Probably is your ShareWebDb marked as "Suspect"?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

650 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