Troubleshooting WSS Event 1000 DB Connectivity Problems

Troubleshooting WSS Event 1000 DB Connectivity Problems

 I recently needed to trigger some data collection on a SQL Server when my Share Point Web Front End started experiencing the dreaded error as follows:

Type: Error
Source: Windows SharePoint Services 2.0
Category: None
Event ID: 1000
Description:
#50070: Unable to connect to the database ConfigurationDatabase. Check the database connection information and make sure that the database server is running.

For more information, see http://support.microsoft.com/default.aspx?scid=kb;en-us;833183

I used the following steps to help out.

1. Create Remote.vbs as follows:

========== remote.vbs [ Exec remote process via WMI]================

strComputer = WScript.Arguments.Item(0)

strCommand = WScript.Arguments.Item(1)

Set objWMIService = GetObject("winmgmts:" _

   & "{impersonationLevel=impersonate}!\\" & strComputer & _

   "\root\cimv2:Win32_Process")

errReturn = objWMIService.Create(strCommand,null,null,intProcessID)

If errReturn = 0 Then

    WScript.Echo strCommand & " was started with a process ID of " _

    & intProcessID & "."

Else

    WScript.Echo strCommand & " could not be started due to error " & _

    errReturn & "."

End If

========== remote.vbs [ Exec remote process via WMI]================

2. Create WFE_InvokeSomethingOnSQL.CMD on WFE which should be something like this

cscript remote.vbs MYDBSERVER C:\DoSomethingOnSQL.cmd

3. Create DoSomethingOnSQL.CMD on SQL on the drive and path specified in WFE_InvokeSomethingOnSQL.CMD:

REM ========[ BEGIN DoSomethingOnSQL.CMD ]==============================

REM ==================================================================

REM

REM

SET MYLOG=MyLog.Log

ECHO ================================================== >> %MYLOG%

ECHO Something Run at %DATE%%TIME% >> %MYLOG%

ECHO ================================================== >> %MYLOG%

Something.exe /someargument /TEMP.LOG

TYPE TEMP.LOG >> %MYLOG%

REM

REM

REM ========[ END DoSomethingOnSQL.CMD ]==============================

REM ================================================================

4. Add the trigger event on the Web Front End.

eventtriggers /create /s WFE-SERVER /tr Event1000Trigger /l APPLICATION /eid 1000 /t ERROR /so "Windows SharePoint Services 2.0" /d "Trigger to call DoSomthing.CMD to be run on SQL Server when Event ID 1000 is encountered" /tk “C:\WFE_InvokeSomethingOnSQL.CMD”

Hope this helps you as well!

- Keith