Solved

undo sc delete mssql$microsoft##ssee

Posted on 2015-02-02
7
61 Views
Last Modified: 2016-06-24
To start - I do not have a good backup, please do not suggest using restore.
Does anyone know how to use sc create to rebuild mssql$microsoft##ssee so that it will show up in SQL Server Configuration Manager and Management Studio Express.
My data files are intact. I mostly need this working to get my companyweb back online.
The WSUS was broken and I was trying to remove it without realizing that WSUS and sharepoint share a DB on SBS.
Thanks for any help.
0
Comment
Question by:tbennett1985
  • 3
  • 3
7 Comments
 
LVL 76

Accepted Solution

by:
arnold earned 500 total points
ID: 40584434
Sc deletes the service portion
If it is not present in sql configuration, that suggests that it was uninstalled.
Presumably if try to readd the wsus part, you are getting errors; if you have not tried it add the wsus role back.

The ssee is a special instance of an express version without throttling.
0
 

Author Comment

by:tbennett1985
ID: 40592084
The WSUS shows still installed and will not re-install or uninstall.
Any other ideas? The DB still exists, I just need to make SQL re-create the instance.
0
 
LVL 76

Expert Comment

by:arnold
ID: 40592168
Ran into a similar issue with an SBS, installed WSUS on a separate server.
You can try adding the service startup directive.  What was removed and how was it removed?

The DB files are not deleted, the role, the remedy

Was there a manual removal of components?
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!

 

Author Comment

by:tbennett1985
ID: 40592379
I started the manual removal process, did not download the tool to uninstall since it has been removed from the web -

4.   From a command prompt, type: sc delete wsusservice

5.   From a command prompt, type: iisreset
 6.   For Microsoft SQL Server 2005 Embedded Edition

 1) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
 Edit the "InstalledInstances" value and remove "MICROSOFT##SSEE"

 2) Remove the "MICROSOFT##SSEE" subkey under
 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer


 3) Remove the "MSSQL.2005" subkey under
 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer


 4) Rename the following folder:
 \%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data to \%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data.old

Could not rename the folder, so it is intact.
I have restored the registry entries by using a shadow copy version.
What I havn't been able to figure out is how to undo the SC Delete issue.

thanks for your help.
0
 
LVL 76

Assisted Solution

by:arnold
arnold earned 500 total points
ID: 40592411
Well you need to restore those entries.
after which you can try the sc create mssql$microsoft##ssee
then you would need to replicate the data that needs to be there.

Often, after sc delete, you actually have to reboot the system for the entries to be removed.  one option you could try is navigate to hKLM\system\currentcontrolset\services\mssql reference and export this higherarchy.
Then after sc create, import this back hoping it will restore your funcitonality...




Your issue is that you are after the SharePoint functionality.
0
 

Author Comment

by:tbennett1985
ID: 40592565
I will try to restore that key and give it a reboot tonight.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

17 Experts available now in Live!

Get 1:1 Help Now