Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

installing the SQL server 2005 Enterprise Expand / Collapse
Author
Message
Posted Thursday, December 16, 2010 12:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 29, 2011 11:02 AM
Points: 32, Visits: 62
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

Post #1036061
Posted Thursday, December 16, 2010 1:41 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 8:31 AM
Points: 243, Visits: 601
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
Post #1036116
Posted Thursday, December 16, 2010 1:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 29, 2011 11:02 AM
Points: 32, Visits: 62
Thanks for reply., I will try this.
Post #1036126
Posted Friday, December 17, 2010 10:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 29, 2011 11:02 AM
Points: 32, Visits: 62
Hi,

I install successfully, but services is still not starting. I try both mathod.
can you please advice?
Post #1036656
Posted Friday, December 17, 2010 11:29 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 33,088, Visits: 15,197
Is there any other entry in the Windows event logs?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1036670
Posted Friday, December 17, 2010 12:43 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 8:31 AM
Points: 243, Visits: 601
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
Post #1036708
Posted Friday, December 17, 2010 1:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 29, 2011 11:02 AM
Points: 32, Visits: 62
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
Post #1036725
Posted Friday, December 17, 2010 4:55 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 8:31 AM
Points: 243, Visits: 601
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
Post #1036798
Posted Wednesday, January 5, 2011 7:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 2:47 PM
Points: 88, Visits: 351
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!


Post #1043082
Posted Wednesday, January 5, 2011 11:44 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 8:31 AM
Points: 243, Visits: 601
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
Post #1043256
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse