SQL 2005 “cluster build” common failures
March 23, 2011 Leave a Comment
Hello.
This is a quick post about the common failures we come across when installing SQL Server 2005 across a windows active/passive cluster.
Permissions on the service group
Make sure the account you are installing SQL Server under has the necessary permissions to add members to the Service Account Group. If you don’t have the required privileges you will encounter the following error -
“You do not have privileges to add accounts to the domain groups specified for this failover cluster. Ask your domain administrator for privileges to add new accounts to the domain groups, or log on using an account that does have permission”
Windows task scheduler is not running on the passive node
Now this is very subtle and still catches me out every now and then. During the installation phase you will just experience a very generic installation error.
Make sure that the Windows Task Scheduler is enabled and is running on the passive node otherwise because this is how the installation process installs the binaries from the active node on to the passive node.
