locked
SQL Server 2012 instllation failed due to "SQM does not active session" RRS feed

  • Question

  • Hi folks,

    SQL 2012 server instllation failed due to "SQM does not have active session"

    Windows 2012 RTM stand edition.

    What is the solution for this?

    Thanks in advance

    Wednesday, November 19, 2014 7:17 AM

Answers

  • Hi vijay_1234,

    As your description, you come across an error(SQM does not have active session) when installing SQL Server. Please help to post SQL Server setup logs for further analysis. By default, SQL Server setup log file locates in C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log.

    Based on my research, the error could occur when you use a bad media to install the SQL Server, or the setup file attempts to open registry key.

    Firstly, you could follow the steps below to check if you use a bad media. If it is a bad media, please download the media again and re-install SQL Server.

    a. Download the File Checksum Integrity Verifier (fciv.exe) from http://support.microsoft.com/kb/841290.
    b. Installing the package will prompt where to extract the utility. I extracted it to the location where my SQL ISO file was present.
    c. Open command prompt an navigate to location of fciv.exe and run below command:
    fciv.exe –SHA1  en_sql_server_2012_enterprise_edition_x86_x64_dvd_813294.iso
    d. This command generate the SHA1 code 0d878a8136fd657d9800f05322b0d4594bce92b8 and this code was different from actual media SHA1 code (Case Sensitive) 07DBC8EAFE16DCC0BF8888F7C55105BC02CE0211
    e. You will be able to find the SHA1 code in the details section of the media download page of the media. (MSDN subscriber download page). For more information about the process, please refer to the article: http://www.pythian.com/blog/sql-server-2012-installation-failed/

    However, if there is no problem with the media, the error might occur when the setup file attempts to open registry key, you could follow the steps below to troubleshoot your issue.

    a. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap]
    "BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\110\\Setup Bootstrap\\"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap\Setup]
    "PatchLevel"="11.00.2100.60"

    b. Next, copy the following files and folders(X64/X86 folder, Setup.exe and Resources folder) from the media to the specified destinations(C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012), and next, re-run the setup. For more information about the process, please refer to the similar thread: http://blogs.msdn.com/b/sqljourney/archive/2012/05/07/sql-2008-2008-r2-setup-disappears-fails-when-installing-setup-support-files.aspx

    Regards,
    Michelle Li

    • Marked as answer by vijay_1234 Tuesday, November 25, 2014 2:20 AM
    Monday, November 24, 2014 11:09 AM

All replies

  • Wednesday, November 19, 2014 9:37 AM
  • Hi vijay_1234,

    As your description, you come across an error(SQM does not have active session) when installing SQL Server. Please help to post SQL Server setup logs for further analysis. By default, SQL Server setup log file locates in C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log.

    Based on my research, the error could occur when you use a bad media to install the SQL Server, or the setup file attempts to open registry key.

    Firstly, you could follow the steps below to check if you use a bad media. If it is a bad media, please download the media again and re-install SQL Server.

    a. Download the File Checksum Integrity Verifier (fciv.exe) from http://support.microsoft.com/kb/841290.
    b. Installing the package will prompt where to extract the utility. I extracted it to the location where my SQL ISO file was present.
    c. Open command prompt an navigate to location of fciv.exe and run below command:
    fciv.exe –SHA1  en_sql_server_2012_enterprise_edition_x86_x64_dvd_813294.iso
    d. This command generate the SHA1 code 0d878a8136fd657d9800f05322b0d4594bce92b8 and this code was different from actual media SHA1 code (Case Sensitive) 07DBC8EAFE16DCC0BF8888F7C55105BC02CE0211
    e. You will be able to find the SHA1 code in the details section of the media download page of the media. (MSDN subscriber download page). For more information about the process, please refer to the article: http://www.pythian.com/blog/sql-server-2012-installation-failed/

    However, if there is no problem with the media, the error might occur when the setup file attempts to open registry key, you could follow the steps below to troubleshoot your issue.

    a. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap]
    "BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\110\\Setup Bootstrap\\"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap\Setup]
    "PatchLevel"="11.00.2100.60"

    b. Next, copy the following files and folders(X64/X86 folder, Setup.exe and Resources folder) from the media to the specified destinations(C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012), and next, re-run the setup. For more information about the process, please refer to the similar thread: http://blogs.msdn.com/b/sqljourney/archive/2012/05/07/sql-2008-2008-r2-setup-disappears-fails-when-installing-setup-support-files.aspx

    Regards,
    Michelle Li

    • Marked as answer by vijay_1234 Tuesday, November 25, 2014 2:20 AM
    Monday, November 24, 2014 11:09 AM
  • Hi Michelle,

    Thanks you for your valuable time and such a big content.

    We noticed that " media is corrupted"

    It is very good point "fciv.exe –SHA1" to validate the software.

    Thanks so much.

    Tuesday, November 25, 2014 2:25 AM