• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1079
  • Last Modified:

SQL error (Database 'master' has invalid schema) with WSUS

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;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; 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;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100



0
idheath
Asked:
idheath
1 Solution
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
0
 
idheathAuthor Commented:
Hmmmm....
The information in the link has some simularities with my problem (but my issue is with WSUS and not SharePoint).
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now