Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Changing Collation on a Cluster

  
   Database Forums (Home) -> Clustering RSS
Next:  Select MAX, 2nd highest, etc.  
Author Message
Chris Wood

External


Since: Jun 29, 2007
Posts: 72



(Msg. 1) Posted: Thu Dec 06, 2007 2:34 pm
Post subject: Changing Collation on a Cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
Hi,

I am sure that someone has managed to do this. We have a 64_bit Clustered
SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin. We want
to change it to the North American default but keep getting errors. The
latest was: - SQL Server Setup is unable to run on this node as it is
unavailable due to a SCC failure or other reason
SQL Server Setup is unable to run. Either the owning node or all nodes that
are currently part of the virtual server are not available. Review any SCC
failures and validate that all nodes are online.

Can someone help before we uninstall? Will we have problems if we uninstall?

Thanks

Chris

 >> Stay informed about: Changing Collation on a Cluster 
Back to top
Login to vote
Chris Wood

External


Since: Jun 29, 2007
Posts: 72



(Msg. 2) Posted: Thu Dec 06, 2007 3:51 pm
Post subject: Re: Changing Collation on a Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Ureka. We did it. We found that the registry key value as to where the
install came from was different on the two nodes and we were using the sa
password for the adminpassword instead of the Windows account we installed
with.

The build still shows 3200, where we had got to, even though BOL seems to
think that this may not be right. It mentioned about having to re-apply the
service packs and hotfix builds.

Chris

"Chris Wood" wrote in message

> Hi,
>
> I am sure that someone has managed to do this. We have a 64_bit Clustered
> SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin. We
> want to change it to the North American default but keep getting errors.
> The latest was: - SQL Server Setup is unable to run on this node as it is
> unavailable due to a SCC failure or other reason
> SQL Server Setup is unable to run. Either the owning node or all nodes
> that are currently part of the virtual server are not available. Review
> any SCC failures and validate that all nodes are online.
>
> Can someone help before we uninstall? Will we have problems if we
> uninstall?
>
> Thanks
>
> Chris
>

 >> Stay informed about: Changing Collation on a Cluster 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 3) Posted: Fri Dec 07, 2007 9:49 am
Post subject: Re: Changing Collation on a Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
BOL is correct.

The binaries on all the nodes are build 3200, but likely the procedures on
Master (and possibly the resource database) are still at RTM. Reapply all
service packs and hotfix/cumulative updates to guarantee binaries and data
elements are all in sync.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Chris Wood" wrote in message

> Ureka. We did it. We found that the registry key value as to where the
> install came from was different on the two nodes and we were using the sa
> password for the adminpassword instead of the Windows account we installed
> with.
>
> The build still shows 3200, where we had got to, even though BOL seems to
> think that this may not be right. It mentioned about having to re-apply
> the service packs and hotfix builds.
>
> Chris
>
> "Chris Wood" wrote in message
>
>> Hi,
>>
>> I am sure that someone has managed to do this. We have a 64_bit Clustered
>> SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin. We
>> want to change it to the North American default but keep getting errors.
>> The latest was: - SQL Server Setup is unable to run on this node as it is
>> unavailable due to a SCC failure or other reason
>> SQL Server Setup is unable to run. Either the owning node or all nodes
>> that are currently part of the virtual server are not available. Review
>> any SCC failures and validate that all nodes are online.
>>
>> Can someone help before we uninstall? Will we have problems if we
>> uninstall?
>>
>> Thanks
>>
>> Chris
>>
>
>
 >> Stay informed about: Changing Collation on a Cluster 
Back to top
Login to vote
Chris Wood

External


Since: Jun 29, 2007
Posts: 72



(Msg. 4) Posted: Fri Dec 07, 2007 9:49 am
Post subject: Re: Changing Collation on a Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks Geoff.

I checked the summary.txt says 1399.06. That's what made me suspicious.
Looks like MS need to make a change somewhere otherwise people will not
re-run the updates.

Chris

PS. Hope this is handled better in SQL2008.

"Geoff N. Hiten" wrote in message

> BOL is correct.
>
> The binaries on all the nodes are build 3200, but likely the procedures on
> Master (and possibly the resource database) are still at RTM. Reapply all
> service packs and hotfix/cumulative updates to guarantee binaries and data
> elements are all in sync.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
>
> "Chris Wood" wrote in message
>
>> Ureka. We did it. We found that the registry key value as to where the
>> install came from was different on the two nodes and we were using the sa
>> password for the adminpassword instead of the Windows account we
>> installed with.
>>
>> The build still shows 3200, where we had got to, even though BOL seems to
>> think that this may not be right. It mentioned about having to re-apply
>> the service packs and hotfix builds.
>>
>> Chris
>>
>> "Chris Wood" wrote in message
>>
>>> Hi,
>>>
>>> I am sure that someone has managed to do this. We have a 64_bit
>>> Clustered SQL2005 SP2 build 3175 server that we created as
>>> Latin1_General_Bin. We want to change it to the North American default
>>> but keep getting errors. The latest was: - SQL Server Setup is unable to
>>> run on this node as it is unavailable due to a SCC failure or other
>>> reason
>>> SQL Server Setup is unable to run. Either the owning node or all nodes
>>> that are currently part of the virtual server are not available. Review
>>> any SCC failures and validate that all nodes are online.
>>>
>>> Can someone help before we uninstall? Will we have problems if we
>>> uninstall?
>>>
>>> Thanks
>>>
>>> Chris
>>>
>>
>>
>
 >> Stay informed about: Changing Collation on a Cluster 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Changing IP of the cluster - Hello! We will be moving our two cluster running SQL Server 2005 64-bit SP2 on Windows 2003 to the different datacenter. IP addressed of both nodes will be changed by DNS names remain the same. I was wondering if anyone had issues with this. Out..

SQL Server 2005 - Changing Port in Cluster Environment - I have setup an Active Passive Cluster in SQL Server 2005. For security issue we wanted to change the port from default 1433 to 1456. In SQL Server 2000 it was pretty straight forward but it looks complicated in SQL Server 2005. If anyone has done..

Why SQL cluster changing owner after taking offline and br.. - Hi, I have a failover cluster with SQL Server 2000 SP4 installed on it. The SQL Server is on the current active node which is SQLUU. last night, I took the SQL Server offline from cluster administrator, and then immediatelt bring online again...

Database resource won't start after changing cluster subnet - I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask of my public network config, as well as the MCS virtual subnet and two database resource subnets (all are using the..

Changing SQL Service account passowrd on a cluster configu.. - Hi, I have SQL 2005 server (with Named Instance) running on a two node Cluster Configuration (Active/Passive). SQL Instance, SQL Server Agent, SQL Server Browser services are running under a service account (domain account). Similarly Cluster service...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]