Solved

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

Posted on 2008-10-06
4
1,059 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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