<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
installing the SQL server 2005 Enterprise
12 posts, Page 1 of 2
1
2
»»
installing the SQL server 2005 Enterprise
Rate Topic
Display Mode
Topic Options
Author
Message
MAK1
MAK1
Posted Thursday, December 16, 2010 12:37 PM
SSC 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
MostInterestingMan
MostInterestingMan
Posted Thursday, December 16, 2010 1:41 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 8:48 AM
Points: 240,
Visits: 594
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
MAK1
MAK1
Posted Thursday, December 16, 2010 1:53 PM
SSC 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
MAK1
MAK1
Posted Friday, December 17, 2010 10:44 AM
SSC 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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Friday, December 17, 2010 11:29 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 8:24 AM
Points: 31,426,
Visits: 13,739
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
MostInterestingMan
MostInterestingMan
Posted Friday, December 17, 2010 12:43 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 8:48 AM
Points: 240,
Visits: 594
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
MAK1
MAK1
Posted Friday, December 17, 2010 1:15 PM
SSC 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
MostInterestingMan
MostInterestingMan
Posted Friday, December 17, 2010 4:55 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 8:48 AM
Points: 240,
Visits: 594
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
Deb Anderson
Deb Anderson
Posted Wednesday, January 05, 2011 7:48 AM
SSC 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
MostInterestingMan
MostInterestingMan
Posted Wednesday, January 05, 2011 11:44 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 8:48 AM
Points: 240,
Visits: 594
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
