locked
SQL Express 2008 R2 will not start on Windows 7 Home RRS feed

  • Question

  • Ok, This used to work, and then over night my system rebooted and now I cannot start SQL Express 2008 R2 after I have unistalled, and re-installed.   Cleared out the folders and the certificates, changed the Named Pipes configuration and all to no avail.   Here is my log file.

    -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

    2014-06-14 08:45:18.18 Server      Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
        Jun 17 2011 00:54:03
        Copyright (c) Microsoft Corporation
        Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    2014-06-14 08:45:18.18 Server      (c) Microsoft Corporation.
    2014-06-14 08:45:18.18 Server      All rights reserved.
    2014-06-14 08:45:18.18 Server      Server process ID is 8924.
    2014-06-14 08:45:18.18 Server      System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: '700Z3A/700Z4A/700Z5A/700Z5B'.
    2014-06-14 08:45:18.18 Server      Authentication mode is MIXED.
    2014-06-14 08:45:18.18 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG'.
    2014-06-14 08:45:18.18 Server      This instance of SQL Server last reported using a process ID of 2820 at 6/14/2014 8:32:55 AM (local) 6/14/2014 1:32:55 PM (UTC). This is an informational message only; no user action is required.
    2014-06-14 08:45:18.18 Server      Registry startup parameters:
         -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\master.mdf
         -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG
         -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\mastlog.ldf
    2014-06-14 08:45:18.18 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2014-06-14 08:45:18.18 Server      Detected 8 CPUs. This is an informational message; no user action is required.
    2014-06-14 08:45:18.21 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2014-06-14 08:45:18.23 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2014-06-14 08:45:18.25 spid7s      Starting up database 'master'.
    2014-06-14 08:45:18.28 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'ACT7'.
    2014-06-14 08:45:18.29 spid7s      SQL Trace ID 1 was started by login "sa".
    2014-06-14 08:45:18.29 spid7s      Starting up database 'mssqlsystemresource'.
    2014-06-14 08:45:18.30 spid7s      The resource database build version is 10.50.2500. This is an informational message only. No user action is required.
    2014-06-14 08:45:18.32 spid7s      Server name is 'MARTINDAHL-PC\ACT7'. This is an informational message only. No user action is required.
    2014-06-14 08:45:18.32 spid10s     Starting up database 'model'.
    2014-06-14 08:45:18.32 spid7s      Informational: No full-text supported languages found.
    2014-06-14 08:45:18.32 spid7s      Starting up database 'msdb'.
    2014-06-14 08:45:18.33 Server      Error: 17190, Severity: 16, State: 1.
    2014-06-14 08:45:18.33 Server      Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
    2014-06-14 08:45:18.33 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2014-06-14 08:45:18.33 Server      Error: 17182, Severity: 16, State: 1.
    2014-06-14 08:45:18.33 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.

    2014-06-14 08:45:18.33 Server      Error: 17182, Severity: 16, State: 1.
    2014-06-14 08:45:18.33 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.

    2014-06-14 08:45:18.33 Server      Error: 17826, Severity: 18, State: 3.
    2014-06-14 08:45:18.33 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2014-06-14 08:45:18.33 Server      Error: 17120, Severity: 16, State: 1.
    2014-06-14 08:45:18.33 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    -=-=-=-=-=-=-=-=-=-=

    I am logged into either the Administrator Account or my Account in which I am in the Adminstrator Group or an Admin.   My OS is Windows 7 Home Premium Edition, so I cannot clear out the MSSQL groups and things I have seen online.  Since this is Express, there is limited capabilities with the config tool.  

    I have tried to change the log in as in the SQL Configuration tool and every item I check, Local Service, Local System, Network Service all give the same error,

    "Cannot Find Object or Property. [0x80042004]

    SInce I have Home Premium, MMC will not load the snap in for Local Users and groups to check out these items.

    A check of the net user shows only the Administrator, Guest and my local login in Admin Account.  net localgroups show these items.

    *Administrators
    *Distributed COM Users
    *Event Log Readers
    *Guests
    *HomeUsers
    *IIS_IUSRS
    *IIS_WPG
    *Performance Log Users
    *Performance Monitor Users
    *SQLServer2005SQLBrowserUser$MARTINDAHL-PC
    *SQLServerFDHostUser$MartinDahl-PC$ACT7
    *SQLServerMSSQLServerADHelperUser$MARTINDAHL-PC
    *SQLServerMSSQLUser$MartinDahl-PC$ACT7
    *SQLServerSQLAgentUser$MARTINDAHL-PC$ACT7
    *Users
    The command completed successfully.

    I checked the SSL and Force Encryption is set to no and the certificates have been cleared.  

    I am not sure how to solve this problem.   Please help.   Thanks, in advance. 

    Saturday, June 14, 2014 2:40 PM

All replies

  • Hi,

    Are you able to start the services of Sql server express? Can you follow such steps below to uninstall that and then try to re-install it?

    http://technet.microsoft.com/en-us/library/ms143505(v=sql.90).aspx



    Many Thanks & Best Regards, Hua Min


    Saturday, June 14, 2014 2:47 PM
  • No SQL Espress Start Fails with the error log shown above.   I believe I un-installed all the items correctly as shown in the link you provided, but the link you provide is to 2005 SQL Express, not 2008.     I even deleted the SQL Folder under Program files when I re-installed.   These steps did not work.

    Saturday, June 14, 2014 2:53 PM
  • Hi,

    Please see work around and solution mentioned in This Link

    Please disable VIA protocol is enabled. Create a new account into your windows machine add it as local administrator and then try starting SQL server with this account Using Configuration manager. Make sure you change service account using SQL server configuration manager.

    If it does not work refer to below articles

    Similar issue reported here

    Detailed workaround mentioned in This article as well

    PS: THERE IS NO NED TO UNINSTALL SQL SERVER EXPRESS


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Saturday, June 14, 2014 3:02 PM
  • I un-installed and re-installed by this process many times with no success.
    Saturday, June 14, 2014 3:09 PM
  • I un-installed and re-installed by this process many times with no success.

    Like I mentioned please don't do this patiently go through links I have posted. Hua Minchen I totally irresponsible of you to say to uninstall SS express without knowing the issue.

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Saturday, June 14, 2014 3:15 PM
  • In regards to your first link.  I tried my Administrator Account on the local machine and this still fails to start SQL and I get the same error in the logs shown above.   I also have used my local log in User account with Admin rights and SQL will not start.   I have changed the login as in the SQL Configuration tool and the local system, local sevice, and network service accounts, all of these fail with this error.

    "Cannot find object or property. [0x80042004]"

    If I select my local Administrator Account and type in the password, I get the same result.  So the link which stated to change the account SQL uses to log in, does not work.  Either all my accounts are corrupted or something else is wrong. 

    Of course the first link mentions the "Service Account".   I have Windows 7 Home Premium and mmc.exe does not allow for the snap on to see Local Users and Groups to be loaded.   Looking at the command line at the net users command, I only get my three accounts listed on the system.   Administrator, Guest and my log in name "Martin Dahl", which is an admin account in the Administrators Group.   So not sure how to "fix" the Service Account they mention in this version of windows.  

    -=-=-=-=-=-=-=

    In the similar issue reported here link, they show a backup and temporary account listed under the users profiles screen.  I only have Default Profile, Administrators, Martin Dahl as my three profiles listed, there are no backup or temporary profiles listed.

    -=-=-=-=-=-=-=

    The thrid link refers to some certificate generation files, which look like they may help but reference Windows Server 2003, which I do not have, I have windows 7 Home Premium.   Also, the first step is to log into the "Service Account"

    "Log in to the server using the service account credentials"

    A search on Service Accounts revealed this link. 

    http://msdn.microsoft.com/en-us/library/windows/desktop/ms686005%28v=vs.85%29.aspx

    Which shows the Local Server, Local Service, and Network Service Accounts as Service accounts.

    This took me to this link.

    http://msdn.microsoft.com/en-us/library/windows/desktop/ms677959%28v=vs.85%29.aspx

    While good information, there is no information on how to log into the service account.

    Of course this was all working a day ago with no issues from my user account.   Not sure what changed and how to fix it.   These links do not seem to get me to a step by step in how to fix.   I know I am not the most windows savvy, hey, it should just work right! :-)   Any additional help would be welcome.   Thanks, I may need more hand holding than some here are used to, but I cannot seem to find why this is.  I would hate to have to start over from scratch reloading windows after a HD format.   Thanks in advance.

    Saturday, June 14, 2014 3:44 PM
  • I saw this link before, and I followed the steps before just like they said to un-install and re-install.  I followed the steps and still the same problem unless I missed something in the links, which is totally possible.   I will try again, but like I said, I think I followed the steps.    Since this is an ACT install, I even did this with their SQL people on the phone with me who un-installed and re-installed and basically followed the steps in the link.  So I did un-install, clean and re-install with a semi-expert with the same problem.  They (ACT) stopped helping me as they said this is a SQL issue on "my Machine" only.   Which I was fustrated with to say the least.   I am not an MS or SQL expert, just would like to get the db back started and the db attached.  I have never had this problem before and spent all day working with them (ACT) yesterday on un-install and re-installs.   I did so again this AM, after a re-image of my system prior to a SQL install.   Again, SQL gets installed, but will not start with the issue above.  So not sure if an un-install/re-install will help.   I will re-read the link again and see if there is a step I missed in a prior un-install and try again, but I have little or no hope this will work, but I am desperate and will try anything.  Thanks for the help.
    Saturday, June 14, 2014 3:54 PM
  • Oh by the way, VIA is disabled.
    Saturday, June 14, 2014 3:59 PM
  • This issue is not with SQL server but SQL server is victim here as per mentioned in below article

    http://support.microsoft.com/kb/947242

    Did you tried creating new Local account in your desktop then add it to local admin and the start SQL Server with that account. Please refer to above link and make changes accordingly


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Saturday, June 14, 2014 4:14 PM
  • I created a new Administrator account on the machine, mdahl.   I then started the SQL Configuration Tool and changed the log on to this new account.  Same problem.   Here is the SQL Log.


    2014-06-14 11:24:15.83 Server      Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
        Jun 17 2011 00:54:03
        Copyright (c) Microsoft Corporation
        Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    2014-06-14 11:24:15.83 Server      (c) Microsoft Corporation.
    2014-06-14 11:24:15.83 Server      All rights reserved.
    2014-06-14 11:24:15.83 Server      Server process ID is 11448.
    2014-06-14 11:24:15.83 Server      System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: '700Z3A/700Z4A/700Z5A/700Z5B'.
    2014-06-14 11:24:15.83 Server      Authentication mode is MIXED.
    2014-06-14 11:24:15.83 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG'.
    2014-06-14 11:24:15.83 Server      This instance of SQL Server last reported using a process ID of 5952 at 6/14/2014 11:21:35 AM (local) 6/14/2014 4:21:35 PM (UTC). This is an informational message only; no user action is required.
    2014-06-14 11:24:15.83 Server      Registry startup parameters:
         -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\master.mdf
         -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG
         -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\mastlog.ldf
    2014-06-14 11:24:15.83 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2014-06-14 11:24:15.83 Server      Detected 8 CPUs. This is an informational message; no user action is required.
    2014-06-14 11:24:15.87 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2014-06-14 11:24:15.88 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2014-06-14 11:24:15.90 spid7s      Starting up database 'master'.
    2014-06-14 11:24:15.91 spid7s      1 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
    2014-06-14 11:24:15.91 spid7s      0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
    2014-06-14 11:24:15.91 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2014-06-14 11:24:15.92 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'ACT7'.
    2014-06-14 11:24:15.93 spid7s      SQL Trace ID 1 was started by login "sa".
    2014-06-14 11:24:15.93 spid7s      Starting up database 'mssqlsystemresource'.
    2014-06-14 11:24:15.93 spid7s      The resource database build version is 10.50.2500. This is an informational message only. No user action is required.
    2014-06-14 11:24:16.03 spid7s      Server name is 'MARTINDAHL-PC\ACT7'. This is an informational message only. No user action is required.
    2014-06-14 11:24:16.03 spid10s     Starting up database 'model'.
    2014-06-14 11:24:16.03 spid7s      Informational: No full-text supported languages found.
    2014-06-14 11:24:16.03 spid7s      Starting up database 'msdb'.
    2014-06-14 11:24:16.03 Server      Error: 17190, Severity: 16, State: 1.
    2014-06-14 11:24:16.03 Server      Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
    2014-06-14 11:24:16.03 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2014-06-14 11:24:16.03 Server      Error: 17182, Severity: 16, State: 1.
    2014-06-14 11:24:16.03 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.

    2014-06-14 11:24:16.03 Server      Error: 17182, Severity: 16, State: 1.
    2014-06-14 11:24:16.03 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.

    2014-06-14 11:24:16.03 Server      Error: 17826, Severity: 18, State: 3.
    2014-06-14 11:24:16.03 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2014-06-14 11:24:16.03 Server      Error: 17120, Severity: 16, State: 1.
    2014-06-14 11:24:16.03 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


    Also, the link you provided is to Windows Vista, not Windows 7 Home Premium.  However, I did look at the registry setting they said to look at in the link.


    1. Locate the following registry subkey:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
    2. Under the ProfileList subkey, delete the subkey that is named <var>SID</var>.bak.

      Note <var>SID</var> is a placeholder for the security identifier (SID) of the user account that is experiencing the problem. The <var>SID</var>.bak subkey should contain a ProfileImagePath registry entry that points to the original profile folder of the user account that is experiencing the problem.
    3. Exit Registry Editor.

    Looking into my registry for my ProfilesList as mentioned. I have these items.

    S-1-5-19 Folder with Default (Value not set), Flags (REG_DWORD) 0x0000000, ProfileImagePath (REG_EXPANDS_SZ) C:Windows\ServiceProfiles\LocalService, State (REG_DWORD) 0x0000000

    S-1-5-20 Folder with Default (Value not set), Flags (REG_DWORD) 0x0000000, ProfileImagePath (REG_EXPANDS_SZ) C:Windows\ServiceProfiles\NetworkService, State (REG_DWORD) 0x0000000

    Then I have an item for each of my three accounts, Administrator, Martin Dahl, and mdahl, All admin Accounts, which has no sid.bak, but a Sid, so not sure how this link helps me either.   Still looking for assistance.  Still not starting.

    Saturday, June 14, 2014 4:36 PM
  • Can you please check this link

    initilising the failback certificate error

    In this link there are  executable( On THIS link)  to download and run see if it helps

    Refer This link as well

    Try below as well I found on one of the article

    Is SSL certificate installed for SQL server?? If not the do the following steps.

    1.) Go to SQL Server Configuration Manager
    2.) Click on SQL Server 2005 Network Configuration
    3.) In the right pane, Right click on "Protocols for <servername>"
    4.) Check whether "Force Encryption" option is set to "yes", if this is on then make it to "No", click ok.
    5.) Then try starting the service


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles



    Saturday, June 14, 2014 4:58 PM
  • I went to the first link and took me to a page where I could download an app to test the creation of a Crypt Keyset.   I downloaded this and ran it and got this error.

    Unable to open Keyset.CryptAcquireContext failed with error: 0x80090016

    Will try creating key

    CryptAcquireContext failed creating key.Error: 0x8009000F

    Handle could not be released.

    I checked the folder C:\Users\Martin Dahl\AppData\Roaming\Microsoft\Crypto Folder and the my user account and the Administrator account has access to this folder as well as the two folders above this. 

    I did a search on the error above and did not find anything I could see solves the issues for me.   I did check out the registry as the link above suggests to check the registry key:

    HKEY_USERS\S-1-X-XXX\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\AppData

    I did check this and it does point to the %USERPROFILE%\AppData folder.

    Any other suggestions.   I am still not able to start SQL.

    Saturday, June 14, 2014 5:33 PM
  • ON the second link.  It mentions a different error than I am getting, but looking into the troubleshooting steps, it states....


    1) Tried starting SQL Server (MSSQLServer) using LOCAL SYSTEM in SCM.

    I am windows 7 Home premium there is no SCM in this version I think.   Let me know if I am wrong....

    2) We created a ‘Certificate’ of type - REG_STRING value in registry - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\

    Next it says "create a Certificate"   Not sure how to do that and the link does not contain a step by step on how to do this.   Also, mentions a .BAK profile and .RSC profiles all which do not exist in my registry. 

    It does also say to delete the user profile.  I deleted the Administrator Profile and will try to log in under this account again.   Also, I cannot delete the Martin Dahl Profile, my main profile as the delete box is greyed out and not available.

    Saturday, June 14, 2014 5:41 PM
  • I would suggest raising case with Microsoft I guess I cannot help further it would require physical access to system and through log analysis

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Saturday, June 14, 2014 5:43 PM
  • Did you ever change your port or port clashes happened recently?

    Also check if IP is correct working for you.

    You said resinstall and uninstall so many times, did you have correctly not removed any required registry key too.


    Santosh Singh

    Saturday, June 14, 2014 7:04 PM
  • I cannot be sure that when I deleted I got all the offending registry entries.  If there is a good how to on how to delete any registry entries in reference to SQL Express 2008 R2, that would be helpful.   I just recovered to the state after my last un-install and am back to square 1 with the system.   I do not have a support contract with Microsoft so I may be back to a backup of data and re-install of windows and the SQL.   Thanks for all the recommendations.   This is a tough one and one that has a pretty serious back door problem.  I suspect my computer crashed while SQL was up and live and hence the situation I find myself in.  About time to migrate to a different platform.   Thanks all....
    Saturday, June 14, 2014 8:24 PM
  • I am not sure how to check the port and or change the port used for SQL in the Express version on WIndows 7 Home, that is over my head.  My IP and internet connection is working fine, all other applications all working fine as normal.   Thanks again for the assistance and information.
    Saturday, June 14, 2014 8:26 PM
  • There is one good link about the proper removal about registry and other, this may help:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3974daa9-9da1-46d9-8001-57b8517d3470/how-to-uninstall-properly-sql-server-2008-?forum=sqlsetupandupgrade

    This was for Sql Server 2008, however it can point you to check properly as these are two main locations to verify.

    Some more link to just give you some idea.

    http://sqlblog.com/blogs/davide_mauri/archive/2010/05/04/sql-server-2008-r2-installation-and-the-phantom-of-sql-server-2005-express.aspx

    Now port is something if you are not needed to give while connecting, then probably default port, check if you can do telnet and all.

    For IP, you can check with connecting IP too.


    Santosh Singh

    Sunday, June 15, 2014 7:35 PM
  • Hi,

    Before reinstalling the system, you may try restoring the system to previous time and see if it helps.

    To restore system will preserve all the software and files before the previous restore point. And all of your private date will be preserved.

    Reference:

    http://windows.microsoft.com/en-hk/windows/turn-system-restore-on-off#1TC=windows-7

    Hope it helps.

    Tracy Cai
    TechNet Community Support

    Monday, June 16, 2014 6:37 AM
  • Hi,

    Before reinstalling the system, you may try restoring the system to previous time and see if it helps.

    To restore system will preserve all the software and files before the previous restore point. And all of your private date will be preserved.

    Reference:

    http://windows.microsoft.com/en-hk/windows/turn-system-restore-on-off#1TC=windows-7

    Hope it helps.

    Tracy Cai
    TechNet Community Support

    Tracy can this thread be locked

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Thursday, June 26, 2014 1:35 PM