Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SBS 2003 wsus / mssql$microsoft##ssee

Posted on 2011-03-16
29
Medium Priority
?
1,401 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 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 2000 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 2000 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

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.

Question has a verified solution.

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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

916 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