Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


installing the SQL server 2005 Enterprise


installing the SQL server 2005 Enterprise

Author
Message
MAK1
MAK1
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
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
MostInterestingMan
MostInterestingMan
SSC Veteran
SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)

Group: General Forum Members
Points: 257 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
MAK1
MAK1
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 62
Thanks for reply., I will try this.
MAK1
MAK1
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 62
Hi,

I install successfully, but services is still not starting. I try both mathod.
can you please advice?
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36145 Visits: 18748
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
My Blog: www.voiceofthedba.com
MostInterestingMan
MostInterestingMan
SSC Veteran
SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)

Group: General Forum Members
Points: 257 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
MAK1
MAK1
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
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
MostInterestingMan
MostInterestingMan
SSC Veteran
SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)

Group: General Forum Members
Points: 257 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
Deb Anderson
Deb Anderson
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
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!

Cool
MostInterestingMan
MostInterestingMan
SSC Veteran
SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)

Group: General Forum Members
Points: 257 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search