SQL Server Service failed to start during installation new cluster

Posted on 2009-02-19
Last Modified: 2012-05-06
I have been searching the internet for over a day now and I just don't get this SQL 2005 cluster installed. I have the following situation.
I have two cluster nodes installed with Windows Server 2003 Enterpsior 64x Edition. The failover with the clusters is all tested and works like a charm.
I have a shared resource for both servers where the data is coming and it's only active on one node at the time.

Everytime I start the installation of SQL 2005 (Enterprise 64x Edition) everything goes smoothly until I get an error. The  printscreen of the error is uploaded under the name "1.jpg".
It's not crucial and the installation continues. Then almost at the very end the sql services need to be started and i get the error that can be seen at "2.jpg".

When I go to the logfiles to see what the problem is see that the service did not respond in a timely fashion.
The logfiles are added too.

The users are configured corrctly and teh service account has administrative rights on the local machine (both nodes). The service groups for the SQL Server, SQL Server Agent and the SQL Server Full Text Search services are configured correctly and have the service account added to them.

Can anybody shine some light on this.

Question by:Sander Stad
    LVL 57

    Assisted Solution

    by:Raja Jegan R
    The DLL File which is specified over there is corrupt. Kindly copy it from another working machine.
    Not able to attach in this comment as dll files are not allowed.

    Hope that would solve your second issue too..
    LVL 9

    Author Comment

    by:Sander Stad
    The error with the dll can be fixed but my real problem is the service that will not start at the end of the installation.
    Because when error 2 occurs I can only choose to cancel and after the cancellation the installation of the SQL Services is rolled back.

    LVL 9

    Accepted Solution

    I solved the problem. Is seems that MS SQL 2005 (without a service pack) can not the amount of cores that I use in my servers.
    The servers are configured with 4 cpu with 6 cores.

    For the people who will have the same problem as me. Here is an article that will allow you to install MS SQL 2005 in your cluster environment:

    The problem is solved in SP2 of MS SQL 2005 so you could also try to slipstream the cd and install MS SQL 2005 with SP2


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now