Solved

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

Posted on 2008-10-06
4
1,063 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

734 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