I have a problem with the SQL installation for WSUS (within Windows SBS 2003 Server).
I'm getting a "Database 'master' has invalid schema" in the ERRORLOG file (in G:\WSUS\MSSQL$WSUS\LOG).
There are no also these errors in the Event Log:
Event Type: Error
Event Source: Windows Server Update Services
Event Category: Database
Event ID: 421
Date: 03/10/2008
Time: 08:36:57
User: N/A
Computer: HOME-SERVER
Description:
Connection to database failed. Reason=SQL Server does not exist or access denied.. Connection string: Data Source=HOME-SERVER\WSUS;In
itial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connect
ion=Yes;Po
oling='tru
e'; Max Pool Size = 100
Event Type: Error
Event Source: Windows Server Update Services
Event Category: Update Services Service
Event ID: 421
Date: 03/10/2008
Time: 08:36:59
User: N/A
Computer: HOME-SERVER
Description:
Connection to database failed. Reason=An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). Connection string: Data Source=HOME-SERVER\WSUS;In
itial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connect
ion=Yes;Po
oling='tru
e'; Max Pool Size = 100
Start Free Trial