sql 2005 install fails on XP SP3 -- Error Number : 29508

Question

Hello, I am trying to install sql server 2005 express on xp (media center edition) with windows service pack 3. I am getting the following messages in the summary log.. Can you please help? I can send other logs if necessary.. thanks!


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Time            : Sun Feb 14 21:18:55 2010
 
STEVE-LAJB : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
STEVE-LAJB : To install Microsoft SQL Server 2005, COM+ should work.
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_MSXML6_2.log
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : SQL Server Database Services
Error           : SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user Compaq_Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : SQL Server Database Services
Error           : SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user Compaq_Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQL.log
Last Action     : InstallFinalize
Error String    : SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user Compaq_Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.
Error Number    : 29508
--------------------------------------------------------------------------------
Machine         : STEVE-LAJB
Product         : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.2.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Tools.log
--------------------------------------------------------------------------------

 SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


Time            : Sun Feb 14 21:26:10 2010


List of log files:
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Core(Local).log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLSupport_1.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLNCLI_1.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SqlWriter_1.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_MSXML6_1.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLSupport_2.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQLNCLI_2.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_MSXML6_2.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SQL.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Tools.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Datastore.xml
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_.NET Framework 2.0.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SNAC.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Core.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_Support.log
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0036_STEVE-LAJB_SCC.log

Answer 1

Hello,

I found the following post:

http://blogs.technet.com/sbs/archive/2009/06/11/error-while-installing-sql-2005-express-on-sbs-2008.aspx

The registry key mentioned on that post is the same.

Please make sure you run setup using an administrator or a user with administrative privileges.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thanks, Alberto.. I have found this post as well in my research effort, and the error is exactly the same, so I had hoped the solution would be this easy. Nope.. the registry key does contain the correct hostname in the originalmachinename key..

I am running the install logged on as Administrator, even though my default account also has admin privileges, but I thought I would try that too, but no luck.

Any other suggestions? Would another log file be helpful?

Thanks in advance!

Answer 3

Hi,

To work around the issue, try the following steps:
1. Add a group SQLServer2005SQLBrowserUser$STEVE-LAJB under Local Groups on the box.
2. Add Local Admin & Domain account running SQL Server Setup into this group.

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 4

I'm having the same problem; can you provide some more information on where and how to add a group "on the box"?

 

thanks in advance

Answer 5

Refer this screenshot.

---

Pradeep Adiga
Blog: sqldbadiaries.com

Answer 6

Thanks for the screenshot but - I created the group and added the administrator and "user" but still get the same error.  Are there any logs I can post that might be of benefit?  I didn't see anywhere to add the permissions, but the "user" account is set up as an administrator so if it follows the normal path that should not be a hindrance.

I've tried 3 different install disks to make sure that it's not just the disk.  I'd really appreciate any other thoughts or suggestions; I'm trying to install HAZUS, a FEMA product that we need.

Thanks