?
Solved

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

Posted on 2011-02-19
13
Medium Priority
?
1,665 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
Office 365 Training for Admins - 7 Day Trial

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.

 
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:zwipy
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

752 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