none
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
    Monday, February 15, 2010 3:25 AM

Answers

  • 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***
    Thursday, February 18, 2010 7:31 AM
    Moderator

All replies

  • 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

    Monday, February 15, 2010 12:15 PM
    Moderator
  • 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!
    Monday, February 15, 2010 4:10 PM
  • 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***
    Thursday, February 18, 2010 7:31 AM
    Moderator
  • 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

    Friday, December 10, 2010 6:25 PM
  • Refer this screenshot.


    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    Sunday, December 12, 2010 5:31 PM
  • 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

     

     

    Wednesday, December 15, 2010 3:06 PM