Solved

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

Posted on 2010-08-19
3
1,469 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
[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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
OfficeMate Freezes on login or does not load after login credentials are input.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

732 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