Solved

SBS 2003 wsus / mssql$microsoft##ssee

Posted on 2011-03-16
29
1,361 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:Donald Stewart
Donald Stewart 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:Donald Stewart
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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:Donald Stewart
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:Donald Stewart
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:Donald Stewart
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:Donald Stewart
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
 
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:
Donald Stewart 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:Donald Stewart
ID: 35182867
Yes, 2008 only refers to the version
0
 
LVL 47

Expert Comment

by:Donald Stewart
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:Donald Stewart
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:Donald Stewart
Donald Stewart 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:Donald Stewart
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:Donald Stewart
ID: 35191121
Glad to help, I take more pride in being able to help than accumalating the points.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

829 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