MS SQL (Express, 32bit - Standard, 64bit - Enterprise)

  • 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

  • - 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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