WSUS is unable to connect to the database. See SoftwareDistribution.log for more information.

Details
Product: .NET Framework
Event ID: 11002
Source: Windows Server Update Services
Version: 2.0.50727
Symbolic Name: HealthDatabaseRed
Message: WSUS is unable to connect to the database. See SoftwareDistribution.log for more information.
   
Explanation
The WSUS database needs to be configured correctly to provide information storage and retrieval for updates, approvals, subscriptions, and events.
   
User Action
WSUS Database Failure

The WSUS database is not working properly.

  • First, troubleshoot any SQL Server issues before continuing.
  • Verify that the WSUS database is in the SQL instance being used
  • .

  1. Open a command window.
  2. Type reg query “HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup” /v SqlServerName
  3. The output contains the SQL server name to be used in the next step.
  4. Type osql -S “SqlServerName” -E -d SUSDB -Q
  5. Review any error message and correct the problems.

Verify

Look for the corresponding error event.

  1. Open a command window.
  2. Type cd <WSUSInstallDir>\Tools
  3. Type wsusutil checkhealth
  4. Type eventvwr
  5. Review the Application log for the most recent events from
    source Windows Server Update Services and event id 11000.

Related:

Leave a Reply