Solved

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

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
OfficeMate Freezes on login or does not load after login credentials are input.
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…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now