Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts

Tuesday, March 27, 2012

Changing collation when installing SQL2000

Hi,
I'm installing SQL2000 on a new cluster server.
I selected a 'custom installation' and was presented with a
'Collation settings' screen.
I need it to be SQL_Latin1_General_CP1_CI_AS collation
as I will be restoring databases with this collation.
What should I choose from the 'Collation designator' and 'SQL
Collations' box.
Is it 'Dictionary order, case-insensitive, for use with 1252
characters'?

What will be the default? Will it be the same default as for the
'typical' installation?
Thanks(polinaskulski@.aol.com) writes:
> I'm installing SQL2000 on a new cluster server.
> I selected a 'custom installation' and was presented with a
> 'Collation settings' screen.
> I need it to be SQL_Latin1_General_CP1_CI_AS collation
> as I will be restoring databases with this collation.
> What should I choose from the 'Collation designator' and 'SQL
> Collations' box.
> Is it 'Dictionary order, case-insensitive, for use with 1252
> characters'?

I would guess that is be the one, although the description also fits into
SQL_Latin1_General_CP1_CI_AI.

When you install Window collations, there are check-boxes for the
sensitivity stuff, but there might not be for SQL collations. (I
never install these.)

> What will be the default? Will it be the same default as for the
> 'typical' installation?

I believe that SQL_Latin1_General_CP1_CI_AS is the default is your
regional settings is English (USA).

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sunday, March 25, 2012

Changing Collation on a Cluster

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
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" <anonymous@.microsoft.com> wrote in message
news:uWLbw$EOIHA.2376@.TK2MSFTNGP02.phx.gbl...
> 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
>
|||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" <anonymous@.microsoft.com> wrote in message
news:u0QWCrFOIHA.4272@.TK2MSFTNGP06.phx.gbl...
> 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" <anonymous@.microsoft.com> wrote in message
> news:uWLbw$EOIHA.2376@.TK2MSFTNGP02.phx.gbl...
>
|||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" <SQLCraftsman@.gmail.com> wrote in message
news:e96bTBOOIHA.2208@.TK2MSFTNGP06.phx.gbl...
> 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" <anonymous@.microsoft.com> wrote in message
> news:u0QWCrFOIHA.4272@.TK2MSFTNGP06.phx.gbl...
>

Changing cluster configuration

In a two node cluster, is it possible to change from a Active-Passive configuration to Active-Active without completely reinstalling?

ThanksI do not think this is supported. At any time, there should be only one node owns cluster resource such as physical shared disk, IP address, cluster group, etc. This node is called the active node. When you failover to another node in a cluster, all owned resources in the active node will be switched, too.sql

Changing cluster configuration

My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this? My reason for considering this is the size
of the current server, and the need to bringup other applications on the
seconday node.
Active/Passive and Active/Active are old terms. What you want to build is a
multi-instance cluster. You simply install a new instance of SQL server
with its own disk(s), IP address, and network name. After the installation
you can configure each instance to have preferred owner nodes under normal
conditions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:1EB1CFF5-CACD-41A2-B9ED-06F02A766BC8@.microsoft.com...
> My current cluster configuration is Active/Passive, I'm exploring a change
to
> Active/Active, but I haven't been able to find any informaon on how to do
> this, has anyone ever done this? My reason for considering this is the
size
> of the current server, and the need to bringup other applications on the
> seconday node.
|||Jerrick,
Geoff's answer is dead on!
The only other thing to consider is that there can only be ONE default
instance PER CLUSTER.
The second instance you install will likely be a NAMED INSTANCE.
The virtual server name you choose for your second instance MUST BE UNIQUE,
and the instance name will of course need to be unique as well.
Here are some good resources:
http://www.microsoft.com/technet/pro.../failclus.mspx
and in BOL -
Multiple Instances of SQL Server
Failover Clustering Example - This is very good and I think speaks to your
question perfectly as well.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support

Monday, March 19, 2012

Changed Version of SQL Server

I have Windows 2000 Advanced Server with SQL Server 2000
with SP3A in a Active\Active Cluster.
When I loaded Windows 2000 SP4 on the server it changed
SQL Server 2000 version to "Microsoft SQL Server 2000 -
8.00.194 (Intel X86)".
If the Active (Node A)\ Active (Node B) cluster was moved
from original location could this change the SQL Server
version number. (Move Node A to Node B)
What could cause the version number to change within SQL
Server 2000. If the version is wrong is there away to
determine the version by SQL Server file dates?
Please help me resolve this issue.
Thanks,
Mark
weird normally the best way is to type the query below in Query Analyzer
which is determined by the version of SQLServr.exe.
SELECT @.@.VERSION
http://support.microsoft.com/default...b;en-us;321185
Although ocasionally (as with build 819 from
http://support.microsoft.com/default...b;en-us;826161) the real
version is not reflected as SQLServr.exe is not updated. In this case check
the registry @. HKLM\SOFTWARE\Microsoft\MSSQLServer\Hotfixes\0819
regards,
Andy.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:024a01c48aea$87d32a80$a601280a@.phx.gbl...
>
> I have Windows 2000 Advanced Server with SQL Server 2000
> with SP3A in a Active\Active Cluster.
> When I loaded Windows 2000 SP4 on the server it changed
> SQL Server 2000 version to "Microsoft SQL Server 2000 -
> 8.00.194 (Intel X86)".
> If the Active (Node A)\ Active (Node B) cluster was moved
> from original location could this change the SQL Server
> version number. (Move Node A to Node B)
>
> What could cause the version number to change within SQL
> Server 2000. If the version is wrong is there away to
> determine the version by SQL Server file dates?
>
> Please help me resolve this issue.
> Thanks,
> Mark

Sunday, February 19, 2012

Change Server name in SQL2005 Cluster

Once the SQL2005 cluster is installed can I change the "physical" server name of the 2 server nodes in the cluster. I do not want to change the virtual server name but the "physical" Windows server name....

Steve Dunn

sdunn@.esiindy.com

BOL refers:

When an instance of SQL Server is part of a SQL Server failover cluster, the process of renaming the computer differs from the process of renaming a computer that hosts a stand-alone instance. For information about renaming a computer that hosts a failover cluster instance of SQL Server 2005, see How to: Rename a SQL Server 2005 Virtual Server.

SQL Server does not support renaming computers that are involved in replication, except in the case of using log shipping with replication. The secondary computer in log shipping can be renamed if the primary computer is permanently lost. For more information, see Replication and Log Shipping.

When renaming a computer that is configured to use database mirroring, you must turn off database mirroring before the renaming operation, and then re-establish database mirroring with the new computer name. Metadata for database mirroring will not be updated automatically to reflect the new computer name.

After the computer renaming operation, users who connect to SQL Server through a Windows group that uses a hard-coded reference to the computer name will not be able to connect to SQL Server if the Windows group specifies the old computer name. To ensure that such Windows groups have SQL Server connectivity following the renaming operation, update the Windows group to specify the new computer name.

Change Server name in SQL2005 Cluster

Once the SQL2005 cluster is installed can I change the "physical" server name of the 2 server nodes in the cluster. I do not want to change the virtual server name but the "physical" Windows server name....

Steve Dunn

sdunn@.esiindy.com

BOL refers:

When an instance of SQL Server is part of a SQL Server failover cluster, the process of renaming the computer differs from the process of renaming a computer that hosts a stand-alone instance. For information about renaming a computer that hosts a failover cluster instance of SQL Server 2005, see How to: Rename a SQL Server 2005 Virtual Server.

SQL Server does not support renaming computers that are involved in replication, except in the case of using log shipping with replication. The secondary computer in log shipping can be renamed if the primary computer is permanently lost. For more information, see Replication and Log Shipping.

When renaming a computer that is configured to use database mirroring, you must turn off database mirroring before the renaming operation, and then re-establish database mirroring with the new computer name. Metadata for database mirroring will not be updated automatically to reflect the new computer name.

After the computer renaming operation, users who connect to SQL Server through a Windows group that uses a hard-coded reference to the computer name will not be able to connect to SQL Server if the Windows group specifies the old computer name. To ensure that such Windows groups have SQL Server connectivity following the renaming operation, update the Windows group to specify the new computer name.

Change server name in MSSQL cluster

Hi all, I've got PDC and BDC Windows NT 4.0 Servers (Enterprise edition) installed in the MS cluster. The clustered application is MS SQL server 7.0. Now I need to change names of both nodes - PDC and BDC Windows NT 4.0 Servers. Has anyone any experience with such operation ? Is it too risky ? Thanks a lot for any hint MichalChanging the server names will break your SQL servers.

I did this on a standalone (changed the server name) and SQL stopped working. The fix according to Microsoft was to reinstall SQL on the servers. When the installation starts it will see that all the components are already installed and then see the name resolution conflict and fix it.

This worked for the standalone but I dont' know about the cluster.|||Furthermore, you can not change the name of a PDC without reinstalling NT 4 server.

Friday, February 10, 2012

Change node names and move cluster to new domain

I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
want me to rename both nodes and also move the cluster to a new domain. How
would I do that ?.
Regards
Tony Dawson
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson
|||You might want to ask yourself if the reasons for doing this are strong
enough to outweigh the risk and efford of this excercise.
Are there any technical reasons why you want to do this ?
Oh, and take a backup... and test the backup before you begin.
But sure that goes for every maintenance you do.
rgds,
Edwin.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
> There is no easy way to do this.
> http://support.microsoft.com/kb/915846/en-us
> will get you through the domain change. To change the node names, you
will[vbcol=seagreen]
> have to evict, change, and readd each node.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Tony Dawson" <noone@.nowhere.org> wrote in message
> news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
bosses[vbcol=seagreen]
How
>
|||Geoff, that KB article handles the domain *group* change but not changing
the domain. I don't think you can move a cluster to another domain.
As for renaming nodes, the only way to do that is to:
1) evict one node
2) rename the node
3) bring the node back into the cluster
4) re-apply the binaries to the node
5) repeat for all nodes
This is all a major PITA. I think there has to be very compelling reason to
change domains or rename nodes within a server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson