Solved

SBS 2003 wsus / mssql$microsoft##ssee

Posted on 2011-03-16
29
1,343 Views
Last Modified: 2013-05-10
Hi Experts-

Have a good one going here...

While attempting to resolve a WSUS 3.0 SP1 issue, a admin started the MS technet blog post about removing manually all of WSUS dated 5 Nov 2008, without knowing what the internal windows database does with SBS. I will run down what he did to this point:

Ran the Windows Installer Cleanup Utility pulling out WSUS and MICROSOFT##SSEE
Ran "net stop mssql$microsoft##ssee
Ran "sc delete mssql$microsoft##ssee
removed some registery keys

Noticed the sharepoint files in the \%windir%\SYSMSI\SSEE\MSSQL\DATA dir and stopped

Good news is this:
1. Server has not been restarted
2. He backed up the registery before making any changes
3. Did not delete any files (so he says)

Can any or all of this be undone?

if so, how can I remount the internal database?

Currently in management studio the sbs\microsoft##ssee database is a white ball not running as well as wsus. The other sql databases are running.

The wsus did not uninstall correctly either as the attempt to install WSUS 3.0 SP2 reported an error that another database existed.

Thanks
0
Comment
Question by:durango099
  • 16
  • 13
29 Comments
 
LVL 47

Assisted Solution

by:dstewartjr
dstewartjr earned 500 total points
ID: 35161525
You may be better off completely removing Windows Internal Database and letting WSUS reinstall it

run this command to remove

# 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


Be sure that during reinstall to use custom website(Port 8530) during WSUS setup.
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35161536
This may help you with sharepoint


http://support.microsoft.com/kb/829114
0
 
LVL 1

Author Comment

by:durango099
ID: 35161569
By reinstall, you are talking about wsus 3.0 SP2?
0
 
LVL 1

Author Comment

by:durango099
ID: 35161656
the current config, they do not use the companyweb site. A different instance of sharepoint is being used and is working. So can I ignore the sharepoint suggestion?
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35161798
"By reinstall, you are talking about wsus 3.0 SP2?"

yes


"the current config, they do not use the companyweb site. A different instance of sharepoint is being used and is working. So can I ignore the sharepoint suggestion?"

yes, we'll tackle if need be
0
 
LVL 1

Author Comment

by:durango099
ID: 35161852
Thanks, I will do this after everyone leaves tonight and report the findings.
0
 
LVL 1

Author Comment

by:durango099
ID: 35168844
Error running the 32bit command:

Windows Installer: This action is only valid for products that are currently installed

So it appears that the Windows Installer Cleanup did part of the work, but not all. I tried again to install WSUS and it fails saying that it is installed already.
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35168905
Are there any errors in your eventvwr under Application(WSUS related) ?

Have you tried opening the WSUS console ?
0
 
LVL 1

Author Comment

by:durango099
ID: 35168926
when opening wsus, it said it could not connect to the server

in sql, the server is not running and will not start
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35168956
Eventvwr errors?

Could you post your WSUSSetup.log ?

http://technet.microsoft.com/en-us/library/cc708547(WS.10).aspx
0
 
LVL 1

Author Comment

by:durango099
ID: 35173091
Here is the app log file...it's UGLY
0
 
LVL 1

Author Comment

by:durango099
ID: 35173100
I could not upload the evt file, so I added .txt and here it is.
app-3-18-11.evt.txt
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35173929
Wasnt asking for you to upload application log, I meant for you upload wsussetup.log

Is you server 32 or 64 bit?

At this point I would reinstall both WSUS and Sharepoint.

How to manually remove all of WSUS
http://blogs.technet.com/b/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx

I would also uninstall IIS/ASP.NET and reinstall these as well

This would be alot easier than trying to troubleshoot a botched uninstall/reinstall.

If you have a Server backup prior to this, you try that first.
0
 
LVL 1

Author Comment

by:durango099
ID: 35174268
Here is the wsussetup log
WSUSSetup.log
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:durango099
ID: 35174273
That is the same technet blog post that started this...Thankfully, the admin stopped when he noticed the sql data directory also had the current used sharepoint database. That is the point that he stopped and called :)
0
 
LVL 47

Accepted Solution

by:
dstewartjr earned 500 total points
ID: 35174296
Ok from your log:


2011-03-16 19:41:06  Success   MWUSSetup          Incompatible version of ReportViewer installed. Required ReportViewer version: 9

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF

Error 0x80070643: Fatal error during installation.

Error message when you use Windows Server Update Services Setup: "Error 0x80070643: Fatal error during installation"
http://support.microsoft.com/kb/920660
0
 
LVL 1

Author Comment

by:durango099
ID: 35182836
Should I install the 2008 report viewer even though this is SBS2003?

After setting the auth on sql, what is the next step?

Thanks
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35182867
Yes, 2008 only refers to the version
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35182895
"After setting the auth on sql, what is the next step?"

Try to install WSUS again
0
 
LVL 1

Author Comment

by:durango099
ID: 35183114
The auth setting is already there for the base <servername> database, though I can not check on the WSUS and MICROSOFT##SSEE databases as they will not start.

The report viewer installed okay, so try the WSUS install again anyway?
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35183139
yes, then go over the WSUSsetup.log to review for any errors
0
 
LVL 1

Author Comment

by:durango099
ID: 35183341
It stopped at what seems like a simple error now, saying that the WSUS database exists already and that I should move or delete the old database from \Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA

Do you know which files I should rename or delete from the data directory?
0
 
LVL 47

Assisted Solution

by:dstewartjr
dstewartjr earned 500 total points
ID: 35183383
Rename the DATA folder to Data.old

Browse to the \Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL folder and rename Data to Data.old


Then try again

0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35183417
I've had to do this in the past
data.bmp
0
 
LVL 1

Author Comment

by:durango099
ID: 35183574
I just need to make sure it will not kill the sharepoint database on :8081
0
 
LVL 1

Author Comment

by:durango099
ID: 35184076
The WSUS failed again with the 0x80070643 error showing in the wsussetup log.

It did however install the internal database and it is not running.

I double checked the sysadmin settings in server roles and it is checked.
0
 
LVL 1

Author Comment

by:durango099
ID: 35185285
I am currently installing updates and will attempt the WSUS install after they complete. Was a pretty long list of updates to be completed.

Thanks
0
 
LVL 1

Author Comment

by:durango099
ID: 35191007
After installing the Windows Updates, the WSUS install proceeded correctly.

Thanks for all your extra effort on this question...too bad there is not a bonus points system in place to award you for the time this took.

Thanks
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 35191121
Glad to help, I take more pride in being able to help than accumalating the points.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

14 Experts available now in Live!

Get 1:1 Help Now