installing the SQL server 2005 Enterprise

  • am admin on my box.

    I try to install SQL Server 2005 Enterprise in my server that reuung window 2003, but I getting these error

    installing SQL Server 2005 --ERROR Code 1053 (Error 29503. The SQL Server service failed to start)

    detail

    Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

    MSI (s) (F0!C4) [16:11:14:967]: PROPERTY CHANGE: Adding SqlCOMPlusInstalled property. Its value is '1'.

    Could not get the ASP temp directory.

    RegOpenKeyEx failed on Key(Software\Microsoft\MSSQLServer\MSSQLServer\Parameters) with returncode 2

    RegOpenKeyEx failed on Key(Software\Microsoft\MSSQLServer\MSSQLServer\Parameters) with returncode 2

    RegOpenKeyEx failed on Key(Software\Microsoft\MSSQLServer\MSSQLServer\Parameters) with returncode 2

    MSI (s) (F0!E0) [16:11:15:201]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.

    RegOpenKeyEx failed on Key(Software\Microsoft\MSSQLServer\MSSQLServer\Parameters) with returncode 2

    RegOpenKey(,Key=Microsoft.SqlServer.Management.Smo.FailedOperationException,,BinaryType=0)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegAddValue(,Value=Microsoft.SqlServer.Management.Smo.FailedOperationException,)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegOpenKey(,Key=Microsoft.SqlServer.Management.Smo.FailedOperationException.9,,BinaryType=0)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegAddValue(,Value=Microsoft.SqlServer.Management.Smo.FailedOperationException,)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegOpenKey(,Key=Microsoft.SqlServer.Management.Smo.FailedOperationException.9\CLSID,,BinaryType=0)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegAddValue(,Value={A920D03E-342D-3C81-B694-317FED286BF5},)

    MSI (s) (F0:64) [16:11:41:920]: Executing op: RegOpenKey(,Key=Microsoft.SqlServer.Management.Smo.FailedOperationException\CLSID,,BinaryType=0)

    MSI (s) (F0:64) [16:11:41:936]: Executing op: RegAddValue(,Value={A920D03E-342D-3C81-B694-317FED286BF5},)

    MSI (s) (F0:64) [16:11:41:936]: Executing op: RegOpenKey(,Key=Microsoft.SqlServer.Management.Smo.FailedOperationException\CurVer,,BinaryType=0)

    MSI (s) (F0:64) [16:11:41:936]: Executing op: RegAddValue(,Value=Microsoft.SqlServer.Management.Smo.FailedOperationException.9,)

    MSI (s) (F0:64) [16:11:41:936]: Executing op:

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQLSERVER

    Error Code: 1053

    MSI (s) (F0!34) [08:52:28:403]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (1053) The service did not respond to the start or control request in a timely fashion.

    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (1053) The service did not respond to the start or control request in a timely fashion.

    .

    <Func Name='GetCAContext'>

    <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>

    Doing Action: Do_sqlScript

    PerfTime Start: Do_sqlScript : Thu Dec 16 08:52:28 2010

    Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Dec 16 08:52:28 2010

    Unable to start service (1053)

    Error Code: 0x8007041d (1053)

    Windows Error Text: The service did not respond to the start or control request in a timely fashion.

    Source File Name: sqlsetuplib\service.cpp

    Compiler Timestamp: Fri Sep 16 13:20:12 2005

    Function Name: sqls::Service::Start

    Source Line Number: 316

  • Are you running a multicore processor machine? If so the article below should solve your problem:

    http://support.microsoft.com/kb/954835

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • Thanks for reply., I will try this.

  • Hi,

    I install successfully, but services is still not starting. I try both mathod.

    can you please advice?

  • Is there any other entry in the Windows event logs?

  • MAK1 (12/17/2010)


    Hi,

    I install successfully, but services is still not starting. I try both mathod.

    can you please advice?

    Launch SQL Server Configuration Manager and try starting the services from there....

    start -> all programs -> microsoft sql server 2005 -> configuration tools -> sql server configuration manager

    All your services will be listed here. You can even see and set properties...for example change the service account. Let me know if it works.

    ...make sure sql server is set up to run under a valid account.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • SQL server 2005 installed but I can't start the services, I am a local admin of my server, I use my account and also I user local system account, still getting following error

    "The SQL Server(MSSQLSERVER) service on local computer started and then stoped.Some services stop automatically if they have no work to do, for example. the performance logs and Alerts service"

    Also on configration manager I change the Protocols for MSSQLSERVER Named Pipes to Enable

  • MAK1 (12/17/2010)


    SQL server 2005 installed but I can't start the services, I am a local admin of my server, I use my account and also I user local system account, still getting following error

    "The SQL Server(MSSQLSERVER) service on local computer started and then stoped.Some services stop automatically if they have no work to do, for example. the performance logs and Alerts service"

    Also on configration manager I change the Protocols for MSSQLSERVER Named Pipes to Enable

    Okay, one of two things may be happenning:

    1) The service account running sql server may have had a recent password change and you haven't updated the password in sql server. If that is the case, sql server is trying to use the old password that was associated with the account. Under sql server properties, on the "log on" tap update the password.

    2) You are on an eval copy of the product and it has expired. Check the error log located @ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG and search for "expired".

    My guess is you changed the service account password and need you need to bounce your box.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • this is what I had to do and it worked for me ...

    I found it on this url - http://forums.amd.com/forum/messageview.cfm?catid=319&threadid=102894

    Here is the solution for your problem

    1. Uninstall everything related to SQL 2005

    2. If you have SQL 2005 SP2 installed on another computer go to that computer and copy sqlservr.exe and sqlos.dll from the installation folder (C:/Program Files/MS SQL Server/MSSQL.1/MSSQL/Binn).

    3. Try to install SQL 2005 again

    4. When you get the error prompt, without canceling it paste the files sqlservr.exe and slqos.dll to C:/Program Files/MS SQL Server/MSSQL.1/MSSQL/Binn

    5. Go back to the error prompt and press Retry

    6. Installation should now go thru and finish

    7. Install SP2 and restart

    Your good to go.

    good luck!

    😎

  • Deb Anderson (1/5/2011)


    this is what I had to do and it worked for me ...

    I found it on this url - http://forums.amd.com/forum/messageview.cfm?catid=319&threadid=102894

    Here is the solution for your problem

    1. Uninstall everything related to SQL 2005

    2. If you have SQL 2005 SP2 installed on another computer go to that computer and copy sqlservr.exe and sqlos.dll from the installation folder (C:/Program Files/MS SQL Server/MSSQL.1/MSSQL/Binn).

    3. Try to install SQL 2005 again

    4. When you get the error prompt, without canceling it paste the files sqlservr.exe and slqos.dll to C:/Program Files/MS SQL Server/MSSQL.1/MSSQL/Binn

    5. Go back to the error prompt and press Retry

    6. Installation should now go thru and finish

    7. Install SP2 and restart

    Your good to go.

    good luck!

    Did the site outlined why the problem occurred?

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • I inferred that it was Processor related, but no, didn't state it outright. Interestingly enough, though SQL will install with this previously mentioned hack, I cannot patch it to sp 3 afterwards. So, I guess it is only partially successful. I'm now trying other MS endorsed hacks to see if it will work.

    http://support.microsoft.com/kb/954835

    #2 didn't work at all for me. SQL finished installing but then wouldn't start.

    #1 Also didn't work for me. Same issue: cannot patch to sp 3.

    😎

  • Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Dec 16 08:52:28 2010

    This combination of startup parameters is used during the install process to customise the master database for the new installation. Until this has been done and the rest of the install process has completed successfully then you cannot say that the install is complete. Certainly, without this work and the subsequent scripts in the install process that run against master being completed, your SQL instance will not behave as you expect.

    The situation you have is very unusual. I do not think I have had this particular problem, but I have had various unusual failures when installing SQL Server on a slow machine, typically as a virtual guest machine that does not have enough CPU resource or has slow I/O to disks. Is your server virtualised? If so, talk to your server management team to see if you can get more resource allocated to your server.

    Before you rerun, you should uninstall all SQL Server components from the server. If I was doing the reinstall, I would get a new copy of Windows installed, so that I know that everything on the server is as it should be.

    Finally, if the problem recurrs then you should raise a case against Microsoft. The problem you have should definitely not be happening.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply