SQL 2008 R2 installation - why does it fail?

• gamgammele

  SSC Enthusiast

  Points: 174

  More actions

  December 20, 2018 at 8:48 am

  #373357

  Hi thanks for reading,

  I posted this question on multiple locations (stackoverflow, microsoft social). Apologies for the redundancy.

  My system: Genuine WinXP Pro SP3 32bit

  My profile: no SQL knowledge, limited programming knowledge and limited winxp OS knowledge.

  Problem description: I'm installing a software that itself installs a SQL Server 2008 R2. Just at the end of the SQL server installation it fails. Apparently it got something to do with server health check (GetSqlServerProcessHandle). Without installation of the SQL server the installation of the 'parent' program also fails.

  Steps taken to fix it (in vain):
-validated the executable
-endless numbers of reinstalls of the relevant program
-made sure i have the right permissions; it could apparently be a debugging issue

  Why could the health check fail? Is there a way to bypass it? Maybe more importantly; how can I solve this problem? Thanks for your help!

  Here are relevant lines from the Details.txt log that is produced during the installation. I changed the name of the sql server to MYSERVER

• 2018-12-20 15:12:36 Slp: Sco: Attempting to start service MSSQL$MYSERVER
2018-12-20 15:12:37 Slp: Sco: Service MSSQL$MYSERVER started
2018-12-20 15:12:37 Slp: Sco: Attempting to get service process id for service MSSQL$MYSERVER
2018-12-20 15:12:37 Slp: Invoking QueryServiceStatusEx Win32 API
2018-12-20 15:12:37 Slp: Sco: Returning service process id 2312
2018-12-20 15:12:37 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle'
2018-12-20 15:12:37 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$MYSERVER' to be created
2018-12-20 15:12:38 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$MYSERVER' or sql process handle to be signaled
2018-12-20 15:12:38 SQLEngine: : Checking Engine checkpoint 'WaitSqlServerStartEvents'
2018-12-20 15:12:43 SQLEngine: --SqlServerServiceSCM: SQL Server process has died while waiting for SQL Server to start. Process id: 2312
(...)
2018-12-20 15:12:43 Slp: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
(...)
2018-12-20 15:12:44 Slp: Message: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes..
(...)
2018-12-20 15:12:44 Slp: Parameter 3 : 0xBE03358B@1306@24
(...)
2018-12-20 15:13:21 Slp: Error result: -2061893608
2018-12-20 15:13:21 Slp: Result facility code: 13062018-12-20 15:13:21 Slp: Result error code: 24