Home » Microsoft TechnologiesRSS

Cannot connect to the configuration database.

Running Sharepoint 3.0 on Win2k3 box for some time now.  Today is decides to quit on me.  When you try to go to the site you get this error: "Cannot connect to the configuration database."  Same thing with the Admin site.

I look in the App Log and find this:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5586
Date:  10/15/2007
Time:  1:06:56 PM
User:  N/A
Computer: ServerName
Description:
Unknown SQL Exception 33002 occured. Additional error information from SQL Server is included below.

Access to module dbo.proc_getObjectsByClass is blocked because the signature is not valid.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

and this

Event Type: Error
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (2)
Event ID: 33002
Date:  10/15/2007
Time:  1:23:56 PM
User:  NT AUTHORITY\NETWORK SERVICE
Computer: ServerName

Description:
The description for Event ID ( 33002 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: module, dbo.proc_getObjectsByClass.
Data:
0000: ea 80 00 00 10 00 00 00   ê€......
0008: 19 00 00 00 52 00 49 00   ....S.E.
0010: 47 00 48 00 54 00 46 00   R.V.E.R.
0018: 41 00 58 00 5c 00 4d 00   N.A.\.M.
0020: 49 00 43 00 52 00 4f 00   I.C.R.O.
0028: 53 00 4f 00 46 00 54 00   S.O.F.T.
0030: 23 00 23 00 53 00 53 00   #.#.S.S.
0038: 45 00 45 00 00 00 0b 00   E.E.....
0040: 00 00 53 00 54 00 53 00   ..S.T.S.
0048: 5f 00 43 00 6f 00 6e 00   _.C.o.n.
0050: 66 00 69 00 67 00 00 00   f.i.g...

Thanks for the help.

 

30 Answers Found

 

Answer 1

FYI... I've read on a few other posts that KB934525 causes the problem. After reading the posts I checked with our network operations team and found out that the mentioned patch had been installed over the weekend as part of scheduled patching.

I've yet to find  the fix.

 

Answer 2

Thanks for the reply.  I will have to call MS today  if I can't find  a fix.

 

Answer 3

I had the same problem after installing KB934525.  After doing some searching I found an important note that was not on the main page of the patch but in the description details an another page.  You have to do one more step after you run the patch to complete the installation.  I cut out the portion below. 

I hope this helps....

___________________________________________________________________________________________________

Post-installation information

After you apply this hotfix package, you must run the SharePoint Products and Technologies configuration  Wizard.

To do this, click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

Important Because of a problem with the hotfix installation, you must not run the SharePoint Products and Technologies Configuration Wizard to complete the installation if you are running  a Windows SharePoint Services stand-alone installation that uses the Windows Internal Database Engine. Instead, you must use the Psconfig.exe command-line utility. To do this, follow these steps:

1.Click Start, click Runtype  cmd in the Open box, and then click OK.
2.Change to the following directory:
system drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin
3.Run the following command:
psconfig -cmd upgrade -inplace b2b
If you ran the SharePoint Products and Technologies Configuration Wizard, you may experience a long delay, and the wizard may not be completed successfully.

Alternatively, the configuration process may be unsuccessful, and you may receive the following error  messages:

Configuration Failed
An exception  of type System.Data.SQLClient.SQLException was thrown. Additional exception information access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

Additionally, the following event  may be logged in the Application log:

Event ID: 5586
Source: Windows SharePoint Services 3
Unknown SQL Exception 33002 occured.
Additional error information from SQL Server is included below.
Access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

If you experience these issues, use the Psconfig.exe command to manually complete the installation of the hotfix. 

_____________________________________________________________________________________________
 

Answer 4

Superb, worked great. Found that the search service was disabled so it failed, but I had to run the command line again with -force on the end after setting the service to automatic.

Thanks very much for your help.

- Kurt

 

Answer 5

Hi all,

i had same problem. Thanks for solutions, but I had to add "-wait" key.

Good luck and sorry for my english.
 

Answer 6


Hi Guys,

I was getting the same error  message and I tried every possible solution given on internet.

I checked the error log  and it was giving me an error because the credentials which my application pool was using were getting denied at the configuration  database.

Solution - I explicitly make my service id to be used which already have the access to the database.

Hope this helps.


-Vaibhav


 

Answer 7

Jon Beets said:

I hope this helps....

___________________________________________________________________________________________________

Post-installation information

After you apply this hotfix package, you must run the SharePoint Products and Technologies configuration  Wizard.

To do this, click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

Important Because of a problem with the hotfix installation, you must not run the SharePoint Products and Technologies Configuration Wizard to complete the installation if you are running  a Windows SharePoint Services stand-alone installation that uses the Windows Internal Database Engine. Instead, you must use the Psconfig.exe command-line utility. To do this, follow these steps:

1.Click Start, click Runtype  cmd in the Open box, and then click OK.
2.Change to the following directory:
system drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin
3.Run the following command:
psconfig -cmd upgrade -inplace b2b
If you ran the SharePoint Products and Technologies Configuration Wizard, you may experience a long delay, and the wizard may not be completed successfully.

Alternatively, the configuration process may be unsuccessful, and you may receive the following error  messages:

Configuration Failed
An exception  of type System.Data.SQLClient.SQLException was thrown. Additional exception information access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

Additionally, the following event  may be logged in the Application log:

Event ID: 5586
Source: Windows SharePoint Services 3
Unknown SQL Exception 33002 occured.
Additional error information from SQL Server is included below.
Access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

If you experience these issues, use the Psconfig.exe command to manually complete the installation of the hotfix. 

_____________________________________________________________________________________________



Thanks very much. That also sorted out the same issue following installation of KB949399.

 

Answer 8

 I have installed WSS 3.0 with SP1.  Is KB949399 part of SP1?
 I am also getting these errors once in a while. error  Ids are 3355 and 5586.

 

Answer 9

In our case the problem was that we had two network cards and both had a default gateway, we removed the default gateway from one of the network cards which was being used for back ups and then we didnt see any DB connectivity issues.
 

Answer 10

Great!!! Thanks a lot, worked fine :-)
 

Answer 11

Hi all,

i've run the above command, i got this error:

An exception  of type  System.InvalidOperationException was thrown.  Additional ex
ception information: Cannot start service SPTimerV3 on computer '.'.

Total number of configuration  settings run: 3
Total number of successful configuration settings: 2
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed.  Configuration mus
t be performed before you use SharePoint Products and Technologies.  For further
 details, see the diagnostic log  located at C:\Program Files\Common Files\Micros
oft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_1_7_2009_9_40_58_104_182
0900716.log and the application event  log.

any ideas?
 

Answer 12

I upgraded my single box  wss 3.0 using the internal dB to sp2 and ran in to problems connecting to the config database.  None of the sites or the central admin site  worked.   Your tip ( to run psconfig -cmd upgrade -inplace b2b ) solved this problem for me.   Thanks.
David.
 

Answer 13

Hi guys ,

           you are lucky if the psconfig -cmd upgrade -inplace b2b -wait -force command has worked for you . this may work if the psconfig fails while upgrading . at times your config database  may have got upgraded and the content hasnt . there is a pre upgrade tool that we need to run before the installation of sp2 .

List of all Windows sharepoint  Services and SharePoint Server Pre-Upgrade Checker knowledge base articles

http://support.microsoft.com/default.aspx/kb/960577/

This issue comes up only when the environment is

Wss 3.0 standalone server with windows  internal database

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5586
User:  N/A
Computer: ServerName
Description:
Unknown sql  Exception 33002 occured. Additional error  information from SQL Server is included below.

Access to module dbo.proc_getObjectsByClass is blocked because the signature is not valid.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

BEHAVIOR/SYMPTOMS:


PSConfigUI failing after installing WSS 3.0 SP2


Error message:

Access to table dbo.spt_values is blocked because the signature is not valid.

Access to table dbo.spt_values is blocked because the signature is not valid.

Access to table dbo.spt_values is blocked because the signature is not valid.

Access to table dbo.spt_values is blocked because the signature is not valid

When we run the psconfig



Symptoms

It will start creating n number of sharepoint_config databases without any tables

We will not be able to access the dbo.versions when we try checking the version of the database

We might be able to check for the version of the config database .


Resolution :

Download management studio express
Set SQL express to allow tcp/ip and named pipes


Open the connection with the following address

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Backup all the databases from the sql server management studio .

Check with the customization as it will be lost

Tak e a screen shot of

a.Solution management

b.AAM

c.Topology

d.Databases in the Sql server management studio

Uninstall windows internal database from the add remove programs

Uninstall SharePoint and reboot the server

Install back SharePoint with windows internal database (Advanced =>  standalone installation )

Restore all the databases /YOU MAY ALSO TRY RESTORING THE FARM BACKUP

Attach the database back to the farm

The server should be up and running.

 

Answer 14

I also am getting the same error  Message.

This has happened after he did some updates on the server which i believe the SP2 for WSS 3.0 which has crashed.

I have navigated and checked for all the named pipes inside the registry which are clean.

Also made sure that SQL configuration  manager was started with TCP pipes.

Also gave the config database  the appropriate permissions.

restarted all the sharepoint  services.

since its a DC gave permission to network service as well as teh system account the full permissions.

i cannot reinstall the product as there is customisation.

i have seen this hapening after SP2 with ##SSEE

Tried the following command

psconfig -cmd upgrade -inplace b2b seems that the database version is 12.0.6413 but failed to complete.

When browsing any of the tables in sql  will return the error
Error Message: Access to table dbo.sites is blocked because the signature is not valid.

Series of Event Id's 5586, 33002 thrown in Event Manager related to Network Service.



Help Apreciated!

 

Answer 15

Guys i got it working Phew! after a long days of work.

i was able to resolve with his KB http://support.microsoft.com/kb/926960


[SPContentDatabaseSequence] [ERROR] [10/5/2006 12:17:52 PM]: Action 3.0.12.3000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
[SPContentDatabaseSequence] [ERROR] [10/5/2006 12:17:52 PM]: Cannot open database  "STS_WSSSBSTEST_1" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

BUT BUT....i ran the command the following way to overcome it psconfig -cmd upgrade -inplace b2b -wait

this did teh trick for me in SSEE database.
 

Answer 16

no need for a full installation.

We did not want to go for an Installation as he had some customer software developed.

psconfig -cmd upgrade -inplace b2b -wait   


Did it for me...one ought to try this and respond.

thank you!

 

Answer 17

yes jonzie ,

                you are partially right , we have run that command . yesterday i faced a issue wherein we ran the command and it failed .

we removed all the content databases and then ran the command which succeeded then ran the stsadm adcontentdb command to attach the content databases now everything was working fine .

reinstallation has to be done only in cases where we have disconnected the config from the farm and it starts creating a new config database  without tables everytime you run the psconfig wizard .

please add to it

 

Answer 18

I have this issue but I to not have the psconfig file. Yet the complete path exists and there are other files in the \bin folder.

Can anyone offer some help on this?

Thanks,
 

Answer 19

You will get this EXE in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN> location...

Please help me for below error  

I tried with PSConfig still I am facing error -

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>Psco
nfig -cmd upgrade -force
SharePoint Products and Technologies configuration  Wizard version 12.0.6413.1000
Copyright (C) Microsoft Corporation 2005. All rights reserved.

Performing configuration task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Successfully initialized SharePoint Products and Technologies upgrade.

Performing configuration task 2 of 4
Initiating the upgrade sequence...

Successfully initiated the upgrade sequence.

Performing configuration task 3 of 4
Upgrading SharePoint Products and Technologies...

Failed to upgrade SharePoint Products and Technologies.

An exception  of type  Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfig
urationTaskException was thrown.  Additional exception information: The upgrade
command is invalid or a failure has been encountered.
Failed to upgrade SharePoint Products and Technologies.

Total number of configuration settings run: 3
Total number of successful configuration settings: 2
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed.  Configuration mus
t be performed before you use SharePoint Products and Technologies.  For further
 details, see the diagnostic log  located at F:\Miscellaneous\log\PSCDiagnostics_
1_31_2010_10_10_23_93_1424284480.log and the application event  log.

 

Answer 20

just try using the psconfig -cmd upgrade -inplace b2b -force - wait switch

also send the pscdiags  and upgrade logs to analyse which has error
 

Answer 21


Hi Guys,

I was getting the same error  message and I tried every possible solution given on internet.

I checked the error log  and it was giving me an error because the credentials which my application pool was using were getting denied at the configuration  database.

Solution - I explicitly make my service id to be used which already have the access to the database.

Hope this helps.


-Vaibhav



How do you explicitly make service id to be used which already have access to the database?

 

Answer 22

I just wanted to say THANK YOU! for this post. It saved me alot of time! Worked great
 

Answer 23

Hi, Joh

I also encountered the same error  , and i try to run that command as you descriped as above.

but get the errors as below, could you provide a assistant, thanks

---------error from cmd---------------------------------------------

Performing configuration  task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Failed to initialize SharePoint Products and Technologies upgrade.

An exception  of type  Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfig
urationTaskException was thrown.  Additional exception information: The initiali
ze command is invalid or a failure has been encountered.
Failed to detect if this server is joined to a server farm.  Possible reasons fo
r this failure could be that you no longer have the appropriate permissions to t
he server farm, the database  server hosting the server farm is unresponsive, the
 configuration database is inaccessible or this server has been removed from the
 server farm.  To diagnose this problem further, review the extended error infor
mation located at C:\Program Files\Common Files\Microsoft Shared\Web Server Exte
nsions\12\LOGS\PSCDiagnostics_4_29_2010_9_49_32_921_798307296.log.  If this prob
lem persists, run this wizard again to disconnect from the server farm.  After d
isconnecting, run the wizard again to create or connect  to an existing server fa
rm.

Total number of configuration settings run: 1
Total number of successful configuration settings: 0
Total number of unsuccessful configuration settings: 3
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed.  Configuration mus
t be performed before you use SharePoint Products and Technologies.  For further
 details, see the diagnostic log  located at C:\Program Files\Common Files\Micros
oft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_4_29_2010_9_49_32_921_79
8307296.log and the application event  log.

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

 

Answer 24

Hi, Joh

I also encountered the same error  , and i try to run that command as you descriped as above.

but get the errors as below, could you provide a assistant, thanks

---------error from cmd---------------------------------------------

Performing configuration  task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Failed to initialize SharePoint Products and Technologies upgrade.

An exception  of type  Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfig
urationTaskException was thrown.  Additional exception information: The initiali
ze command is invalid or a failure has been encountered.
Failed to detect if this server is joined to a server farm.  Possible reasons fo
r this failure could be that you no longer have the appropriate permissions to t
he server farm, the database  server hosting the server farm is unresponsive, the
 configuration database is inaccessible or this server has been removed from the
 server farm.  To diagnose this problem further, review the extended error infor
mation located at C:\Program Files\Common Files\Microsoft Shared\Web Server Exte
nsions\12\LOGS\PSCDiagnostics_4_29_2010_9_49_32_921_798307296.log.  If this prob
lem persists, run this wizard again to disconnect from the server farm.  After d
isconnecting, run the wizard again to create or connect  to an existing server fa
rm.

Total number of configuration settings run: 1
Total number of successful configuration settings: 0
Total number of unsuccessful configuration settings: 3
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed.  Configuration mus
t be performed before you use SharePoint Products and Technologies.  For further
 details, see the diagnostic log  located at C:\Program Files\Common Files\Micros
oft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_4_29_2010_9_49_32_921_79
8307296.log and the application event  log.

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


I am also getting this error when I run the psconfig.exe command.  I also get this error when running  the GUI version.  The site  was operational for several years and then this error occured.

Any help is appreciated.

Thanks,

-Scott

 
 

Answer 26

I had had the same problem as syscomDT above just began a few days ago after tuesdays patches. Seems it is the IIs That is the issue.  if I restart the service then run the iisreset /noforce it comes back up.  (so far) 

 I will monitor and see what happens throughout the day. I have tried all the other posts above and they have not worked for me.

 

Answer 27

I have the same problem since Monday - we use sharepoint  for everything and we are lost without it - I have not been backing up the server as I have been too busy looking after all of our customers servers 

 

I ended up:

Uninstalling the windows  internal database  (after I copied all of the mdf and ldf files to another locatioN)

Uninstalling sharepoint services  3.0

Reboot Server

Install share point and run sharepoint technologies wizard 

updated sharepoint stsadm -o addcontentdb -url http://servername -databasename WSS_Content (which completed successfully)

Now when I try to access my sharepoint I get: 

________________________________________________________________

Go back to site
Error: Access Denied

 

 Current User
You are currently signed in as:  CREATIVEIT\Administrator

 _________________________________________________

The following error  is loged in the event  log:

 

 

Log Name:      Application

Source:        Windows SharePoint Services 3

Date:          19/06/2010 15:52:57

Event ID:      8214

Task Category: Topology

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      CITSERV.creativeit.local

Description:

The description for Event ID 8214 from source  Windows SharePoint Services 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

 

If the event originated on another computer, the display information had to be saved with the event.

 

The following information was included with the event: 

 

A request was made for a URL, http://localhost, which has not been configured in Alternate Access Mappings.  Some links may point to the Alternate Access URL for the default zone, http://citserv.  Review the Alternate Access mappings for this Web application at http://citserv:3067/_admin/AlternateUrlCollections.aspx and consider adding http://localhost as a Public Alternate Access URL if it will be used frequently.  Help on this error: http://go.microsoft.com/fwlink/?LinkId=114854

 

the message resource is present but the message is not found in the string/message table]

 

______________________________________________________________________________

 

Our entire organisation is lost without sharepoint - any help would be greatly appreciated.

 

 

 

Answer 28

I am facing the more like same issue after re-installation of Windows Sharepoint Service 3.0 on X64 in central administration website:

Error while opening the Sharepoint 3.0 Central Administration is below:

URL: http://servername:41521/default.aspx

===========

Cannot complete this action.

Please try again.

===========

 

What else needed to be done. Please help me.


 

Answer 29

I have read and followed every single thread in this forum dating from the initial post on 10-15-2007 to this most recent post above on 07-15-2010; and NONE of these fixes are working for me!  

I've run the proposed psconfig -cmd upgrade -inplace b2b -wait -force several times, but all fail. 

I've run the SharePoint Products & Technologies Configuration Wizard and it rips though 8 of the 10 configurations just fine, then chokes and dies at 9 of 10 (argh!)

Also, when I try to connect  to Server]Microsoft##SSEE MS SQL Server Management Studio Express, I get an error  messsage stating:  "Cannot Connect to Server\Microsoft##SSEE - A network-related or instance-related specific error occurred while establishing a connection to the SQL Server.  The server was not found or was not accessbile.  Verify that the instance name is correct and that SQL Server is configured to allow remote connections (provider: SQL Network Interfaces, error: 26 - Error Locating Server / Instance Specified)(Microsoft SQL Server)


 

 I'm at a complete loss as to what to do next.  CompanyWeb will not load.  However, ISS is running.  RWW works.  OWA works.  CompanyWeb does not.  Can anyone review my error logs and try to decipher what is doing on here?  (btw, how do you attach / upload the log  file here?  - Don't see a means of doing that)

 

Thanks!

 


 

Answer 30

Brian, I am having the same problem. Also ISS running, RWW Works, OWA works and Companyweb doesn't. I also have the log  files.

As well as you, I would like some expert help us to find  out what is the exact error  analizing our log files (After looking at several blogs, I can see that the upgrade process fails in diferent steps, so the fixes do not apply for all cases).

Also, how can we get Microsoft involved?

Regards

Arturo

 

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter