locked
Cannot connect to the configuration database.

    Question

  • 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.

     

    Monday, October 15, 2007 6:27 PM

Answers

  • 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 Run, type 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. 

    _____________________________________________________________________________________________
    Thursday, October 18, 2007 5:56 PM

All replies

  •  

    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.

    Tuesday, October 16, 2007 12:43 PM
  • Thanks for the reply.  I will have to call MS today if I can't find a fix.

     

    Tuesday, October 16, 2007 1:10 PM
  • 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 Run, type 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. 

    _____________________________________________________________________________________________
    Thursday, October 18, 2007 5:56 PM
  •  

    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

    • Unmarked as answer by Mike Walsh FIN Wednesday, January 07, 2009 5:22 AM
    Thursday, October 18, 2007 7:42 PM
  •  

    Hi all,

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

     

    Good luck and sorry for my english.
    Wednesday, May 21, 2008 11:49 AM

  • 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


    Friday, July 18, 2008 6:41 PM
  • > Jon Beets said:

    >I hope this helps....



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

    • Edited by Mike Walsh FIN Sunday, December 05, 2010 6:04 PM don't use full quote
    Wednesday, August 06, 2008 12:07 PM
  •  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.

     

    Wednesday, August 06, 2008 6:43 PM
  • 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.
    • Proposed as answer by Mahesh Srini Wednesday, September 17, 2008 4:18 PM
    • Unproposed as answer by Mike Walsh FIN Wednesday, January 07, 2009 5:22 AM
    Wednesday, September 17, 2008 4:18 PM
  • Great!!! Thanks a lot, worked fine :-)
    Tuesday, December 16, 2008 5:32 PM
  • 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?
    AddinGanteng
    Wednesday, January 07, 2009 2:49 AM
  • 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. 
    Tuesday, May 05, 2009 1:18 PM
  • 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.

    • Proposed as answer by Sushant78 Monday, May 11, 2009 8:49 PM
    • Edited by Sushant78 Tuesday, May 12, 2009 3:30 PM
    • Unproposed as answer by Mike Walsh FIN Sunday, December 05, 2010 6:01 PM
    Monday, May 11, 2009 8:48 PM
  • 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!

    Monday, May 11, 2009 9:47 PM
  • 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.
    Tuesday, May 12, 2009 3:15 PM
  • 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!

    Tuesday, May 12, 2009 3:18 PM
  • 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

     

     

     

    Wednesday, May 13, 2009 3:07 PM
  • 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,
    Tuesday, August 11, 2009 3:39 PM
  • 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.

    Sunday, January 31, 2010 5:25 AM
  • just try using the psconfig -cmd upgrade -inplace b2b -force - wait switch

    also send the pscdiags  and upgrade logs to analyse which has error
    Monday, February 01, 2010 5:41 PM
  • I was getting the same error message and I tried every possible solution given on internet.



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

    • Edited by Mike Walsh FIN Sunday, December 05, 2010 6:01 PM don't use full quote
    Tuesday, February 23, 2010 10:09 PM
  • I just wanted to say THANK YOU! for this post. It saved me alot of time! Worked great
    Monday, April 12, 2010 4:05 PM
  • 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.

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

    Thursday, April 29, 2010 1:54 AM
  • I also encountered the same error , and i try to run that command as you descriped as above.


    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


    CEO - Syscom Digital Technologies, LLC
    • Edited by Mike Walsh FIN Sunday, December 05, 2010 6:00 PM don't use full quote
    Wednesday, June 16, 2010 5:14 AM
  • Hi,

    Please check out this link for some suggestions:

    http://prasanjitmandal.blogspot.com/2010/05/how-to-fix-central-administration.html


    BR, PM
    Wednesday, June 16, 2010 6:30 AM
  • 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.

    Friday, June 18, 2010 2:34 PM
  • 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.

     

     

    Saturday, June 19, 2010 3:29 PM
  • 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.


    Thursday, July 15, 2010 7:07 PM
  • 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!

     


    • Proposed as answer by Brian Appleton Sunday, July 25, 2010 2:57 AM
    • Unproposed as answer by Mike Walsh FIN Sunday, December 05, 2010 5:59 PM
    Saturday, July 17, 2010 12:29 AM
  • 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

     

    Tuesday, July 20, 2010 3:58 AM
  • Well I have a same problem. 

    I go to Sql server configuration manager and saw that sq server service is suddenly stopped. I start it and error resolved.


    Syed Danish Aftab http://www.danishaftab.net
    Sunday, December 05, 2010 4:14 PM
  • Moderator Note:

    The original question was answered more than three years (and many messages) ago.

    I'm locking this thread which has become unwieldy with all the posts since then. If you think you have a new question, please post it in a new thread. This one is no longer available.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Sunday, December 05, 2010 6:07 PM