December 7, 2009 at 4:49 am
I wish to change the collation of a SQL Server instance on a W2008 cluster. I have experience of rebuilding the master on stand-alone instances, but not previously with a clustered instance. I read what I needed to know, concocked a statement and ran it.However, towards the end the process fails with the message:
The cluster resource cannot be made dependent because it is already dependent.
The logs don't give which resource it concerns here. I can figure that out ofcourse, because I know which instance I am altering and which resources are used. I find very little about a remedy on the internet; the only 1 looking worthwhile tells me to remove the dependency of the resource, but if I do that SQL Server will either not work or failover to the passive node, not really useful, I think.
Also I do not understand the dependencyproblem: when I uninstall and install there is no issue with this.
What also irked me was, I could not find if I should do anything like putting it in single-user mode, or shoudl I take resources off-line, or even take the passive node off-line, or such.
Any hint on what can cause this? Do I miss somethhing in rebuilding in a cluster?
Greetz,
Hans Brouwer
December 10, 2009 at 2:44 am
Hey, please let me know if you were able to find a solution for this one.
My thought would have been to take it out of the cluster and then rebuild the database, then join into the cluster
Regards
Akhil
December 10, 2009 at 2:53 am
We had a problem with setting the collation when building a SQL 2008 cluster, the solution for us was to slipstream service pack 1 into the installation file and then install the cluster via an ini file (unattended install). What also works is to build a SQL 2005 cluster and upgrade it to 2008 as then you shouldn't have collation issues. It seems there are some issues to face when installing a SQL 2008 cluster currently.
We never tried rebuilding the master database so can't help with that I'm afraid.
December 17, 2009 at 10:55 am
This is a bug
See http://support.microsoft.com/kb/973250.
Your particular issue (not being able to rebuild the db's) can be solved by stopping the SQL services before running the exe.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply