?
Solved

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

Posted on 2010-08-19
3
Medium Priority
?
1,561 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 500 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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Viewers will learn how the fundamental information of how to create a table.

864 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