Solved

undo sc delete mssql$microsoft##ssee

Posted on 2015-02-02
7
83 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 78

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 78

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 78

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 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