locked
SQL Server Service Dissapeared (Win7-Win8 Upgrade) RRS feed

  • Question

  • I recently downloaded my MSDN copy of Windows 8 and upgraded my machine. Everything went well, except my (SQL Server 2008R2 Developer) SQL Server Service/instance disappeared (Some of the other SQL services did come across). To clarify, the main SQL Server instance simply does not exist in services anymore. I assume it is some sort of file or user rights issue as everything else seems to be in place....

    I can get SQL to start if I go and manually launch the sqlsrvr.exe (but I have to "Run as Administrator" obviously).

    I am hoping someone else may have experience a similar issue with the upgrade process and can advise if they had the same issues or how to solve it.

    Thanks

    Thursday, August 30, 2012 2:37 PM

Answers

  • Well I seem to have solved it using another route.

    I went and looked at the MSSQLSERVER registry key under [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLSERVER] and compared that to another machine I had with SQL running. The node itself was there on my machine, however I noticed that there was actually no key/values under the node. I exported them from my other machine, imported them into my registry then adjusted the ImagePath key value, rebooted, and everything worked....

    I still do not understand what happened as I did a plain and simple Windows upgrade. I am worried now about my other developers upgrading and running into the same thing. At least I have a solution now though!

    Thanks for your advice/direction.

    • Marked as answer by Jason 78 Thursday, August 30, 2012 5:07 PM
    Thursday, August 30, 2012 5:07 PM

All replies

  • Hello,

    Please try to repair SQL Server 2008 R2.

    http://msdn.microsoft.com/en-us/library/cc646006(v=sql.105).aspx

    SP1 for SQL Server 2008 R2 is required on Windows 8, but if you can apply SP2 is better.

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Thursday, August 30, 2012 2:55 PM
  • Thanks for the quick response.

    I had already tried the repair. I get a failure warning around the mid point about the SQL Server Service not existing....

    I just re-applied SP2, rebooted, and the service is still not listed under services.

    Please advise, thanks.

    Thursday, August 30, 2012 3:07 PM
  • Hello,

    Please try to repair it again, and share with us the summary.txt log file.

    http://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspx

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, August 30, 2012 3:22 PM
  • I have started the repair process again and will post the log when I have it. These are the exact 2 pop up errors that occur during the repair process:

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    No mapping between account names and security IDs was done.

    Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

    FOLLOWED BY

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    The SQL Server service is missing. To continue, provide valid credentials for service at the command prompt.

    Thanks again,

    Thursday, August 30, 2012 3:33 PM
  • Ok here is the log information

    Summary Log - https://www.yousendit.com/download/TEhVK3BPdzhrYURIRHRVag

    Detail Log (1.4MB) - https://www.yousendit.com/download/TEhVK3BPdzhuSlNKUmNUQw

    Hope this helps

    Jason

    Thursday, August 30, 2012 3:42 PM
  • Hello,

    Allow me to bypass the corporate network and examine the logs.

    Meanwhile, do you encrypted the file system or compressed the drive after upgrading to Windows 8? Any change on the storage (disk drive)?

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, August 30, 2012 3:50 PM
  • Nope, there is nothing special. Everything resides on 2 standard SSD drives, no compression or encryption.

    I did a straight up upgrade, and immediately noticed the SQL service issue.

    Thanks,

    Thursday, August 30, 2012 3:57 PM
  • Hello,

    “Exception type: Microsoft. SqlServer.Configuration.Sco.ScoException.
    No mapping between account names and security IDs was done”


    It seems cannot find the service account that start SQL Server service. Try to change it using SQL Server Configuration Manager or using the Services applet on Control Panel.

    The following resource may be helpful:

    http://social.msdn.microsoft.com/Forums/eu/sqlsetupandupgrade/thread/cda774d4-6329-4809-9d42-9447750e4d60 

    Verify all SQL Server groups.

    Regards,
    Alberto Morillo
    SQLCoffee.com



    Thursday, August 30, 2012 4:16 PM
  • This goes back to my root problem, it simply is not listed under the services applet.

    Even in the SQL Server Configuration Manager, under the SQL Server Services node, the only service I see listed is the SQL Server Integration Services.

    Unless I am missing something I do not know away to even access the service properties.

    Thursday, August 30, 2012 4:18 PM
  • Hello,

    The SIDs of groups or user accounts involved with SQL Server are missing or do not match with the registry. This is happening with the following SID: S-1-5-80-3263513310-3392720605-1798839546-683002060-3227631582.

    Please try to use the instructions provided by Xiao-Min Tan on the following thread to fix this issue:

    http://social.msdn.microsoft.com/Forums/eu/sqlsetupandupgrade/thread/cda774d4-6329-4809-9d42-9447750e4d60

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Thursday, August 30, 2012 4:29 PM
  • Ok I followed those instruction and found that SID on the FDHost entry, and corrected it with the instructions. I then re-ran the repair and the error:

    "No mapping between account names and security IDs was done."

    Was totally solved. However the following error still occurred:

    "The SQL Server service is missing. To continue, provide valid credentials for service at the command prompt."

    I rebooted before and after the repair, and still no sign of the service.

    I can re-upload the logs if that helps?

    Thursday, August 30, 2012 4:50 PM
  • Hello,

    It seems the SID was just one the causes.

    We need to see what else is missing. Please provide the new set of logs.

    Thank you

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Thursday, August 30, 2012 4:56 PM
  • Well I seem to have solved it using another route.

    I went and looked at the MSSQLSERVER registry key under [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLSERVER] and compared that to another machine I had with SQL running. The node itself was there on my machine, however I noticed that there was actually no key/values under the node. I exported them from my other machine, imported them into my registry then adjusted the ImagePath key value, rebooted, and everything worked....

    I still do not understand what happened as I did a plain and simple Windows upgrade. I am worried now about my other developers upgrading and running into the same thing. At least I have a solution now though!

    Thanks for your advice/direction.

    • Marked as answer by Jason 78 Thursday, August 30, 2012 5:07 PM
    Thursday, August 30, 2012 5:07 PM