June 18, 2010 at 3:15 pm
In the middle of installing SQL Server on a 2 node cluster and i got the below error
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."
*********************************************************
I am using a domain account to do the installation
Anybody seen this error message before
Thx
Nak
June 19, 2010 at 8:16 am
can you supply more information about the setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2010 at 8:16 pm
If you check the bootstrap folder on your system drive you will get more detailed information on what failed. Just make sure that you are an admin on both nodes and that the account for the seq services have full permissions to the drives it is being installed on. Also for ease of install, I make the service accounts local admins on the nodes until the install has been completed, this ensures that there are appropiate permissions. A bit of overkill I know, just don't forget to set them back after the install has completed and the nodes have failed over.
June 23, 2010 at 1:34 am
Setup applies any permisssions or policies that are required during installation!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2010 at 3:50 am
Totaly true on the permissions, but since I was stung installing sql08 on a 2000 domain, I have decided to make this alteration to my setup. It just guarantees that any domain craziness will not be propogated to the servers. easy enough to remove the account from the local admins after. It is a good idea to check if it is a 08 DC before you begin....
June 23, 2010 at 4:24 am
henners72 (6/23/2010)
Totaly true on the permissions, but since I was stung installing sql08 on a 2000 domain, I have decided to make this alteration to my setup. It just guarantees that any domain craziness will not be propogated to the servers. easy enough to remove the account from the local admins after. It is a good idea to check if it is a 08 DC before you begin....
do you mean 2000 domain or 2000 server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2010 at 8:34 pm
I wish it was that simple. It was an 08 Domain in a 2000 forest. There were very odd things happening on the install, I posted looking for help about a month ago and you were the only one to respond. Because I am constantly going form site to site, I can never be sure of thir security configurations, that is why I now hedge my bets when it comes to permissions and installs.
June 28, 2010 at 3:25 am
Have you found the point in the setup log where the problem occurs. Very often the first error is many kb away from the bottom of the log, so finding it can take time.
I have seen many situations where a slow server can cause a SQL install to fail, particularly on a virtual server. If your problem happens in a 'timing test' block this may be your problem. I have also seen this happen when the install media is on a sluggish network drive (including where extracted install media gets put on a network drive even though the primary media is local). IMHO the SQL install process is far too intolerant of slow machines or drives.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 28, 2010 at 7:48 am
Ed, I concur. This is why I always prefer to copy the installation files locally.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2010 at 3:49 pm
I am still having the problems, i have had both node rebuilt and i try the installation again and still having the problem.
using domain account for the installation which is a local admin on both nodes
node 2 is up but nothing is login
The installation fails at configure Microsoft SQL Server portion, it throws out error that i stated earlier.
I am not sure what is going
I have attached screen shots to this post
Any help will be appreciated
July 1, 2010 at 6:19 am
please supply more details on the sql server service account(s) and domain groups for the clustered services!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply