Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

undo sc delete mssql$microsoft##ssee

Posted on 2015-02-02
7
Medium Priority
?
114 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 79

Accepted Solution

by:
arnold earned 2000 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 79

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 79

Assisted Solution

by:arnold
arnold earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
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…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

670 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