Solved

undo sc delete mssql$microsoft##ssee

Posted on 2015-02-02
7
66 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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008. You will need the following: Exchange Best Practice Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyID=DBAB201F-…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

22 Experts available now in Live!

Get 1:1 Help Now