Learn how to a build a cloud-first strategyRegister Now


SQL Server Service failed to start during installation new cluster

Posted on 2009-02-19
Medium Priority
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
  • 2
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 80 total points
ID: 23680532
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..

Author Comment

by:Sander Stad
ID: 23680885
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.


Accepted Solution

Sander Stad earned 0 total points
ID: 23753385
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: http://support.microsoft.com/kb/954835

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

810 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