July 22, 2010 at 3:44 am
Event viewer errors below during the failed installation attempts ...
This is the 1st time I encountered these ...
Windows Server 2003 SP2 on the server
6 Core AMD Opteron
The reason for this is because the previous/original SQL Express that was on the server stopped working which had the Mcafee DB on it ...
Since then we removed SQL Express and tried 32bit - Standard, 64bit - Enterprise and they failed to install.
McAfee Host Intrusion Prevention had logs about sqlserver.exe an then we disabled it and tried to install but still no joy ...
During each attempt we removed sql from the registry and still no joy !!!
Any clues???
I install with Mix mode and with the local admin or local system with no joy!!!
below is from the event viewer ...
APPLICATION
Product: Microsoft SQL Server 2005 (64-bit) -- 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.
.
Event Type:Error
Event Source:Application Error
Event Category:(100)
Event ID:1000
Date:2010/07/22
Time:10:00:56 AM
User:N/A
Computer:MYSERVER
Description:
Faulting application sqlservr.exe, version 2005.90.1399.0, faulting module sqlservr.exe, version 2005.90.1399.0, fault address 0x0000000000b323f0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 73 71 6c ure sql
0018: 73 65 72 76 72 2e 65 78 servr.ex
0020: 65 20 32 30 30 35 2e 39 e 2005.9
0028: 30 2e 31 33 39 39 2e 30 0.1399.0
0030: 20 69 6e 20 73 71 6c 73 in sqls
0038: 65 72 76 72 2e 65 78 65 ervr.exe
0040: 20 32 30 30 35 2e 39 30 2005.90
0048: 2e 31 33 39 39 2e 30 20 .1399.0
0050: 61 74 20 6f 66 66 73 65 at offse
0058: 74 20 30 30 30 30 30 30 t 000000
0060: 30 30 30 30 62 33 32 33 0000b323
0068: 66 30 f0
SYSTEM
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7000
Date:2010/07/22
Time:10:00:56 AM
User:N/A
Computer:MYSERVER
Description:
The SQL Server (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7009
Date:2010/07/22
Time:10:00:56 AM
User:N/A
Computer:MYSERVER
Description:
Timeout (30000 milliseconds) waiting for the SQL Server (MSSQLSERVER) service to connect.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
July 22, 2010 at 5:06 am
- I've also had these timeouts during the setup. Starting the instance manually worked in my cases.
- have you tried to run the sp3 install ( or the latest cumulative update for that matters ) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 22, 2010 at 8:17 am
SP3 for Windows Server 2003???
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
July 22, 2010 at 11:38 am
Hi,
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
Cause: When SQL is installed on windows servers which has processors not equal to the power of 2 then we face such kind of errors during installation.
Find the article about it http://support.microsoft.com/kb/954835
Example: Total processor slots on the server should be 22 24 28 this way for SQL 2005 installation.
Solution: When the above 2 methods of Microsoft link doesn’t work copy the files from bin directory of any other server which has SQL installed with sp2 or higher
1.)Sqlos.dll
2.)Sqlservr
And past to SQL bin directory during the process of installation,, click on retry.
let me know if you find any issues during installation
Thank you,
UmaKanth Rao Vydyula.
SQLDBA.RAO (at)Gmail(dot)COM
July 22, 2010 at 11:51 am
no. sp3 of our subject (sql2005)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2010 at 7:21 am
Hi, I got it installed as per umakanthvydyula and ALZDBA's replies thanx ;-);-)
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
July 23, 2010 at 8:16 am
Thank you for the feedback. I'm glad you got it in a working state.
Have a nice weekend.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 31, 2010 at 2:30 pm
thank you guys!!! thanks to you i was able to fix the same error
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy