Monday, February 27, 2012

Sql Server 2008 Express SP1 installation on Windows XP SP 3

Hi Guys,

 

I was working with my team creating setup package using VS 2010 for a desktop application. The requirement is to install Sql Server 2008 Express Edition with SP1 along with other tools. The setup was working fine Windows 7 and Windows XP. But with Windows XP SP 3 64 bit machine, we started facing issues installing Sql Express 2008 SP1. We were getting the following exception log message:

 

An error occurred attempting to install SQL Server 2008 Express Service Pack 1

Installing using command 'C:\DOCUME~1\TICKSE~1\LOCALS~1\Temp\VSDB.tmp\SqlExpress2008\SQLEXPR32_x86_ENU.EXE' and parameters '/q /hideconsole /action=Install /features=SQL /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck'

Process exited with code -2067922433

After lot of googling and with help of my team, I got the following link that discusses about addressing permission issue with the registry key “Microsoft Sql Server”. We tried the option and bingo!!! It worked. Here are the steps if in case you are stuck with similar issue.

 

Steps

 

1.       Located HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server in registry

2.       Right click and go to Permission

3.       Click on Advance

4.       Tick on both check box (I. Inherit from parent the permission... II. Replace permission entries on all child objects...), click OK

5.       Click OK again