Solved

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

Posted on 2008-10-06
4
1,060 Views
Last Modified: 2012-05-05
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
Comment
Question by:idheath
4 Comments
 
LVL 29

Expert Comment

by:Michael Worsham
ID: 22670037
0
 
LVL 1

Author Comment

by:idheath
ID: 22673419
Hmmmm....
The information in the link has some simularities with my problem (but my issue is with WSUS and not SharePoint).
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23645047
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question