Lawrence Garvin [MVP]
2009-06-10 23:26:36 UTC
(Sorry for the long detail, but I assume you will need most of this
background to best help me.)
I have a Windows 2003 Server Std Ed. Workgroup server, no MS domain,
no active directory. I had WSUS installed and running fine for a couple
years, had updated to version 3. C: volume was running low on space, so
I recently tried moving the database, had already moved content, etc. to
D: drive which has plenty of space.
_______________________________________________
http://technet.microsoft.com/en-us/library/cc708558.aspx
A number of questions come to mind in this scenario, the most significantbackground to best help me.)
I have a Windows 2003 Server Std Ed. Workgroup server, no MS domain,
no active directory. I had WSUS installed and running fine for a couple
years, had updated to version 3. C: volume was running low on space, so
I recently tried moving the database, had already moved content, etc. to
D: drive which has plenty of space.
_______________________________________________
http://technet.microsoft.com/en-us/library/cc708558.aspx
being Why you felt the need to convert your Standard Edition workgroup-based
WSUS Server from the Windows Internal Database to a full installation of SQL
Server 2005 (on the same machine)?
sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
use master
alter database SUSDB set single_user with rollback immediate
go
sp_detach_db SUSDB
go
_____________________
Then I could not get the SUSDB to attach in SQL, and I could not
revert.
Well, that may or may not have to do with the setup and configuration of theuse master
alter database SUSDB set single_user with rollback immediate
go
sp_detach_db SUSDB
go
_____________________
Then I could not get the SUSDB to attach in SQL, and I could not
revert.
SQL Server installation.
Reverting should have simply required one to REattach the database back to
the WID instance.
So I tried to uninstall WSUS 3.0 to start over. It would not
uninstall. When I started a new WSUS install, it wanted to uninstall,
but it could not uninstall.
Something else happened here other than just detaching the database...uninstall. When I started a new WSUS install, it wanted to uninstall,
but it could not uninstall.
surely!?
_____________________
So then I found a support article that was very helpful. I followed
http://blogs.technet.com/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx
Hmmm.... while the article shows how to stop and delete the WID service, andSo then I found a support article that was very helpful. I followed
http://blogs.technet.com/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx
how to remove the registry keys related to the service, I don't see anything
in that article where it actually UNINSTALLS the WID.
And then I was able to start a new installation of WSUS 3.0 SP1, that
appeared to be going just fine. At what I believe would have been very
close to the end of the installation I received a message that it could
not find the ##SSEE instance on SQL.
So... if it didn't find the ##SSEE instance... that means it didn't installappeared to be going just fine. At what I believe would have been very
close to the end of the installation I received a message that it could
not find the ##SSEE instance on SQL.
it, maybe thought it was still installed, but can't actually find a running
service to log onto.
However, I thought I would be
reverting back to the Windows Internal DB, and I would not be connecting
it to SQL.
Well, yes... the ##SSEE is the Windows Internal Database.reverting back to the Windows Internal DB, and I would not be connecting
it to SQL.
(Did I need to reboot the server before reinstalling? I did not.)
Well, it *never* hurts to reboot a server after uninstalling software... butwhether it was required or not, hard to say.
2009-06-10 16:15:58 Success MWUSSetup wYukon Installed
Successfully
2009-06-10 16:15:58 Error MWUSSetup Failed to open
service MSSQL$MICROSOFT##SSEE (Error 0x80070424: The specified service
does not exist as an installed service.)
Ha!.. Okay so it "installed" the WID... but then can't find the *service*...Successfully
2009-06-10 16:15:58 Error MWUSSetup Failed to open
service MSSQL$MICROSOFT##SSEE (Error 0x80070424: The specified service
does not exist as an installed service.)
something did not complete successfully from the previous uninstallation.
The wYukon installer should have created the appropriate service entry.
There were two SQL instances that I left alone in the registry -
MSSQLSERVER, and BKUPEXEC.
That's fine. MSSQLSERVER is the default instance of SQL Server 2005 that youMSSQLSERVER, and BKUPEXEC.
installed, and intended to migrate WSUS into.
Help Please! I thought I was at the finish line until it said it could
not find ##SSEE in SQL. Again, I believe it was at the tail end of the
WSUS install, and I thought I understood that I was getting it back to
the Windows Internal Database.
I've always wondered why PSS provides these convoluted procedures fornot find ##SSEE in SQL. Again, I believe it was at the tail end of the
WSUS install, and I thought I understood that I was getting it back to
the Windows Internal Database.
uninstalling WID, when the WSUS Operations Guide plainly documents a much
simpler (and probably more thorough) procedure for uninstalling WID
From Appendix A of the WSUS Operations Guide:
==============================
To uninstall Windows Internal Database
1. Open a command shell.
2. Call msiexec with the correct key for the operating system platform.
• On 32-bit platforms: msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB}
callerid=ocsetup.exe
• On 64-bit platforms: msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01}
callerid=ocsetup.exe
Important
The removal of the application may not remove the default .mdb and .ldb
files, which will cause a subsequent WSUS 3.0 installation to fail. These
files can be deleted from the %windir%\SYSMSI\SSEE directory.
==============================
I would suggest running the appropriate msiexec command line to ensure all
of the WID is fully uninstalled -- then reboot the server.
Your original databases should still be in the
\%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data.old folder that you renamed from
the original Data folder -- and after WSUS is successfully reinstalled, I
can help you 'restore' your original database if you wish.
Then try the installation of WSUS3SP1 again.
--
Lawrence Garvin, M.S., MCITP:EA, MCDBA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2009)
MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
Lawrence Garvin, M.S., MCITP:EA, MCDBA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2009)
MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin