Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Unable to install SQL Server

Respondido Unable to install SQL Server

  • Friday, January 04, 2013 5:54 AM
     
     
    Sign In to Vote
    0

    I had Visual Studio 2010 installed on my Windows 7 machine and I could create and manage SQL Server database from within the VS platform. I wanted the full database environment so  I tried installing SQL Server Express using the downloaded file SQLEXPR32_x86_ENU. However,  the following error occurs:

    TITLE: Microsoft SQL Server 2008 Setup
    ------------------------------

    The following error has occurred:

    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xE53883A0%25400xBE03358B%25401306%254024

    Thereafter, my SQLServer Express has stopped working from within VS also.

    This is my Errlog:

    2013-01-04 13:23:12.89 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
        Jul  9 2008 14:43:34
        Copyright (c) 1988-2008 Microsoft Corporation
        Express Edition on Windows NT 6.1 <X86> (Build 7600: )

    2013-01-04 13:23:12.89 Server      (c) 2005 Microsoft Corporation.
    2013-01-04 13:23:12.89 Server      All rights reserved.
    2013-01-04 13:23:12.89 Server      Server process ID is 3096.
    2013-01-04 13:23:12.89 Server      System Manufacturer: 'LENOVO', System Model: '20031'.
    2013-01-04 13:23:12.89 Server      Authentication mode is WINDOWS-ONLY.
    2013-01-04 13:23:12.89 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    2013-01-04 13:23:12.91 Server      Registry startup parameters:
         -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
         -e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
         -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    2013-01-04 13:23:12.91 Server      Command Line Startup Parameters:
         -m SqlSetup
         -f
         -Q
         -q SQL_Latin1_General_CP1_CI_AS
         -T 4022
         -T 4010
         -T 3659
         -T 3610
         -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Template Data\master.mdf
         -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf
    2013-01-04 13:23:13.25 Server      Warning: The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically.  After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server.
    2013-01-04 13:23:13.25 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2013-01-04 13:23:13.25 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2013-01-04 13:23:13.38 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2013-01-04 13:23:13.38 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.
    2013-01-04 13:23:19.07 Server      Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2013-01-04 13:23:19.10 Server      Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using the minimal configuration option. This is an informational message only. No user action is required.
    2013-01-04 13:23:19.12 spid6s      Warning ******************
    2013-01-04 13:23:19.12 spid6s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2013-01-04 13:23:19.12 spid6s      Starting up database 'master'.
    2013-01-04 13:23:19.25 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2013-01-04 13:23:19.48 spid6s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
    2013-01-04 13:23:19.48 spid6s      Server started with '-f' option. Auditing will not be started. This is an informational message only; no user action is required.
    2013-01-04 13:23:19.48 spid6s      Starting up database 'mssqlsystemresource'.
    2013-01-04 13:23:19.53 spid6s      The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
    2013-01-04 13:23:19.88 spid6s      Error: 15209, Severity: 16, State: 1.
    2013-01-04 13:23:19.88 spid6s      An error occurred during encryption.

    I hope you will be able to help me with installation of SQLServer Express 2008 on my machine as I am stuck with my work half done now!

    Thanks!

     

All Replies

  • Friday, January 04, 2013 6:13 AM
     
     
    Sign In to Vote
    1

    here is the solution by bala

    http://blogs.msdn.com/b/blakhani/archive/2009/11/24/sql-server-2005-express-setup-failure-with-error-an-error-occurred-during-encryption.aspx

    Ramesh Babu Vavilla MCTS,MSBI

     
  • Friday, January 04, 2013 7:02 AM
     
     
    Sign In to Vote
    0

    Thanks, went through the solution and as suggested, ran ProcMon.

    Again, got the same error in errLog

    2013-01-04 14:36:37.86 spid7s      Error: 15209, Severity: 16, State: 1.
    2013-01-04 14:36:37.86 spid7s      An error occurred during encryption.

    Mapping to procmon for these times, I have a number of "Name Not Found" errors. Cant make any sense of what to do now. This is the dump from ProcMon:

    14:36:37.8605273    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\ParentFolder    NAME NOT FOUND    Length: 144
    14:36:37.8605447    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Description    NAME NOT FOUND    Length: 144
    14:36:37.8605613    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\RelativePath    SUCCESS    Type: REG_SZ, Length: 32, Data: AppData\Roaming
    14:36:37.8605795    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\ParsingName    NAME NOT FOUND    Length: 144
    14:36:37.8605952    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\InfoTip    NAME NOT FOUND    Length: 144
    14:36:37.8606095    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\LocalizedName    NAME NOT FOUND    Length: 144
    14:36:37.8606245    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Icon    NAME NOT FOUND    Length: 144
    14:36:37.8606395    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Security    NAME NOT FOUND    Length: 144
    14:36:37.8606545    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\StreamResource    NAME NOT FOUND    Length: 144
    14:36:37.8606695    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\StreamResourceType    NAME NOT FOUND    Length: 144
    14:36:37.8606845    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\LocalRedirectOnly    NAME NOT FOUND    Length: 144
    14:36:37.8606995    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Roamable    NAME NOT FOUND    Length: 144
    14:36:37.8607137    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\PreCreate    NAME NOT FOUND    Length: 144
    14:36:37.8607374    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Stream    NAME NOT FOUND    Length: 144
    14:36:37.8607516    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\PublishExpandedPath    NAME NOT FOUND    Length: 144
    14:36:37.8607666    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\Attributes    NAME NOT FOUND    Length: 144
    14:36:37.8607808    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\FolderTypeID    NAME NOT FOUND    Length: 144
    14:36:37.8607950    sqlservr.exe    1388    RegQueryValue    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\InitFolderHandler    NAME NOT FOUND    Length: 144
    14:36:37.8608274    sqlservr.exe    1388    RegOpenKey    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions\{3EB685DB-65F9-4CF6-A03A-E3EF65729F3D}\PropertyBag    NAME NOT FOUND    Desired Access: Read

     
  • Sunday, January 06, 2013 3:48 PM
    Moderator
     
     Proposed
    Sign In to Vote
    1

    Hi KD,

    SQL Server 2008 Express includes both 32-bit and 64-bit versions. SQLEXPR32_x86 is a smaller package that can be used to install SQL Server 2008 Express onto only 32-bit operating systems. SQLEXPR_x86 is the same product but supports installation onto both 32-bit and 64-bit (WoW) operating systems. SQLEXPR_x64 is a native 64-bit SQL Server 2008 Express and supports installation onto only 64-bit operating systems. Make sure you download the appropriate setup file based on the Operating System is 64-bit or 32-bit.

    Download SQL Server 2008: http://www.microsoft.com/en-us/download/details.aspx?id=1695.

    Thanks.

    Maggie Luo
    TechNet Community Support

     
  • Tuesday, January 08, 2013 12:15 AM
     
     
    Sign In to Vote
    0

    Thanks Maggie

    I have a 32-bit machine and hence had downloaded and tried installing SQLEXPR32_x86. Not working!

    Now, I have even tried re-installing Visual Studio2010 and service pack. I get an Interactive Services error "Application Data Folder for Visual Studio could not be created"

    Any more ideas??

    Thanks!

     
  • Tuesday, January 08, 2013 2:30 AM
    Moderator
     
     
    Sign In to Vote
    0
    I would suggest installing express 2008 with latest service pack (SP3).

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

     
  • Tuesday, January 08, 2013 3:38 AM
     
     
    Sign In to Vote
    0

    Hi Ahmed

    My installation with SQLEXPR32_x86_ENU ends in error! How do I install service pack after this? Is there another installation file that comes inbuilt with the service pack?

    Thanks

    KD

    KD001

     
  • Friday, January 11, 2013 2:32 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Can you try downloading and installing SQL Server 2008 SP3 express from

    http://www.microsoft.com/en-us/download/details.aspx?id=27597

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Marked As Answer by KD001 Saturday, January 12, 2013 5:45 AM
    •  
     
  • Saturday, January 12, 2013 5:46 AM
     
     
    Sign In to Vote
    0

    Thanks, this has worked!

    KD

    KD001