Solved

WSS 3.0 updates are causing "Cannot connect to the configuration database", but can't remove updates

Posted on 2011-09-16
5
874 Views
Last Modified: 2012-05-12
We are running an SBS 2008 server with WSS 3.0 for our SharePoint site. Some updates were applied last night, and this morning I am getting a "Cannot connect to the configuration database." when trying to access the site.

The updates were a bunch of .NET Framework 4 Client Profile and Extended updates, and one Security Update for WSS 3.0 (KB 2493987)

I was trying to back the updates out to at least get SharePoint functioning again, but the WSS update does not allow me to uninstall it from the "Installed Updates" screen. I can removed the .NET updates though.

So, 2 questions: 1) does anyone know why I would suddenly be unable to connect to the configuration database from these updates, and 2) why does the uninstall option not come up on the WSS update item?
0
Comment
Question by:AidaPakIT
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:Randy Downs
ID: 36550165
Maybe this will help
http://webborg.blogspot.com/2007/05/connect-to-configuration-database-and.html

Today I've received another of the cases when SharePoint (v2) couldn't connect to the configuration database. This can be a common problem but it's not so horrible to solve it.

The reason for this is that SharePoint lost the connection to the database.

Reasons may be the following:

SQL or WMSDE database may not be running
IIS may be running in IIS 5.0 isolation mode
The account for connecting to SQL or WMSDE might be gone or with changed password
update - SQL Server Embedded Edition might not be running (check services) - Thanks, deanoc (see the comments)
The solution to these is on the following link:

http://support.microsoft.com/kb/823287/en-us

But I've found another reason that could be. Simple: The SQL is running, 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.
0
 

Author Comment

by:AidaPakIT
ID: 36550303
While this link is relevant, it does not seem to help my current situation. It is specified for WSS 2.0, and I have 3.0 on this server. Also, I have verified the SQL database is running, I am using IIS 7.0, and no changes were made to the login accounts. I also verified that all SQL services are running, even restarting them as well.

No changes to DB location or DNS server either, so I'm still stumped as to what is causing this.
0
 
LVL 29

Accepted Solution

by:
Randy Downs earned 500 total points
ID: 36550446
try this
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/985edf00-e74d-453b-80f8-ec773ef8eed4/

On your database server, try to activate both TCP/IP and Named pipes through your surface area configuration tool.

Don't forget to restart your sql server service, once done.

 

On the server hosting wss 3.0, open notepad and save this Blank file as connection.udl, on the desktop.

Once done you have a tool that permit to test your connection to the database.

So open this file (run it with the credential used by wss to connect to your database).

On the provider tab choose "Microsoft OLE DB provider for sql server" then click next.

On the connection tab, enter the server name hosting your databases, and then choose you connection method (windows authentication, sql server authentication)

 

So Try to choose a database listed in the "select a database on the server" drop down list box and try to the connection by clicking on the "test the connection" button.
0
 
LVL 29

Expert Comment

by:Randy Downs
ID: 36550478
More possibilities?

You have to open TCP/UDP ports 137, 138, 139 and 445.

---------------------------

This kind of issue mostly related Network Card or Routing Issue.

1. Check the routing

use the command tracert <DBServer>

check the number of hopes it taking and check with your network guys about the routing.

2. Netwwork Card Issue

Network card could be a potential culprit in most of the case check the follwoing article

http://technet.microsoft.com/en-us/library/cc263061(office.12).aspx

 

Some issue are related Windows 2008

Go to the Network Adapter Properties

 Configure button for the Network Card

Advanced Tab and Disable

1. IPv4 Checksum Offload

2. IPv4 Large Send Offload

3. TCP Connection Offload
0
 

Author Comment

by:AidaPakIT
ID: 36573038
So, I ended up contacting Microsoft on this, and it turns out my SharePoint Search Service was trying to call the database using an invalid account. I am not sure why this suddenly stopped working, but they were able to get me squared away again.

Thanks for you help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

839 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