December 16, 2010 at 12:37 pm
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
December 16, 2010 at 1:41 pm
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
December 16, 2010 at 1:53 pm
Thanks for reply., I will try this.
December 17, 2010 at 10:44 am
Hi,
I install successfully, but services is still not starting. I try both mathod.
can you please advice?
December 17, 2010 at 11:29 am
Is there any other entry in the Windows event logs?
December 17, 2010 at 12:43 pm
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
December 17, 2010 at 1:15 pm
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
December 17, 2010 at 4:55 pm
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
January 5, 2011 at 7:48 am
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!
😎
January 5, 2011 at 11:44 am
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
January 5, 2011 at 2:33 pm
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.
😎
January 10, 2011 at 4:17 am
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