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 https://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