Solved

undo sc delete mssql$microsoft##ssee

Posted on 2015-02-02
7
72 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 77

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 77

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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 77

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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

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 …
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 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