Solved

WSUS showing Internal Database as Not Available when I'm using SQLserver

Posted on 2010-08-19
3
1,438 Views
Last Modified: 2012-05-10
Everything's working right on my W2K8 server but I have this annoying little message in Server Manager/Roles.

One of the roles this server is running is WSUS which in turn is using SQLserver 2008 installed on the same server for its database.

In Server Manager, if I click on Roles, then WSUS, the summary page shows extracts from the event log (all info only) but in the System Services pane underneath, it shows a Warning that the service with the name MSSQL$MICROSOFT##SSEE (and a null Display Name) is Not Available.  Well, of course it isn't because I'm using SQLserver and have no need for the Windows Internal Database.

Anyone know how I can impress upon server manager that this is not a fault and that it shouldn't show as a warning?
0
Comment
Question by:losip
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 250 total points
ID: 33479658
Check if this article helps you
 
 
Migrating from Windows Internal Database to SQL Server
http://technet.microsoft.com/en-us/library/dd939918(WS.10).aspx 
0
 
LVL 9

Author Comment

by:losip
ID: 33482464
Yes, thanks.  It was a good thought (especially the wYukonInstalled flag) but I find that all the registry entries, etc are as suggested.  I guess the difference is that I installed WSUS initially to use SQLserver and never migrated from WID.  The only significant areas for concern are that SQLserver is installed locally; not remotely and the article also warns that the instance of SQLserver should not be on a domain controller - it is.  The first may be relevant.

It's not a big problem; I just like everything to be tidy with no errors or warnings.

Thanks for your help
0
 
LVL 9

Author Closing Comment

by:losip
ID: 33902743
No one else has bothered so you might as well have some points even though the problem is unsolved after two months.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

777 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