Change Domains

I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
I had to do this recently. I start from scratch and then attached the
databases. Worked great.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Harvey Hall" <Harvey Hall@.discussions.microsoft.com> wrote in message
news:F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com...
>I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
> considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
> cluster in the new Domain, and (b) migrating MSCS to the new domain per
> kb26196: "How to Move a Windows Cluster Server from one domain to
> another",
> and then using SQL Server's Setup program, Cluster Administrator, and
> regedt32 to migrate the instances to the new domain, per per kb319016:
> "How
> To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Thanks for your response. Glad to hear that "from scratch" works well. Do you
have any thoughts about what I call plan (b) below, that is:
(b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
Cluster Server from one domain to another", and then using SQL Server's Setup
program, Cluster Administrator, and regedt32 to migrate the instances to the
new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
Failover Cluster"
Would you recommend one approach over another?
"Harvey Hall" wrote:
I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Hello Harvey,
With regards to the options I would utilise the option of building from
scratch if this option is available to you as this will gurantee you that
setup is clean, whereas with the migration option using the KB artilces you
have specified you can run into issues which can be caused by objects not
being created during the migration, etc; service account issues, etc.
However the KB articles are tested and proven to work but as is with most
cases if you can start from scratch its always better, especially in a
cluster environment where you want to gurantee a clean environment for high
availability and ease of troubleshooting.
Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Change Domains
| thread-index: AcTZXDH2uVyKQNVbSwSq4yvHs8qoUw==
| X-WBNR-Posting-Host: 69.89.128.5
| From: "=?Utf-8?B?SGFydmV5IEhhbGw=?="
<HarveyHall@.discussions.microsoft.com>
| References: <F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com>
| Subject: RE: Change Domains
| Date: Fri, 3 Dec 2004 09:19:07 -0800
| Lines: 20
| Message-ID: <011FD8E0-BBF7-4040-B2BD-1A9098C71D6D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.clustering
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGXA01.phx.gbl!TK2MSFTNGXA
03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:15918
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
| Thanks for your response. Glad to hear that "from scratch" works well. Do
you
| have any thoughts about what I call plan (b) below, that is:
|
| (b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
| Cluster Server from one domain to another", and then using SQL Server's
Setup
| program, Cluster Administrator, and regedt32 to migrate the instances to
the
| new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
| Failover Cluster"
|
| Would you recommend one approach over another?
|
| "Harvey Hall" wrote:
|
| I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
| considering two alternatives: (a) a node by node rebuild to a
Win2k3/SQL2k
| cluster in the new Domain, and (b) migrating MSCS to the new domain per
| kb26196: "How to Move a Windows Cluster Server from one domain to
another",
| and then using SQL Server's Setup program, Cluster Administrator, and
| regedt32 to migrate the instances to the new domain, per per kb319016:
"How
| To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|
sql

chack attribute domain

How can I be sure that a attribute in a table only can accepta {1,2,3}

You could add CHECK constraint

Code Snippet

createtable test

(

id int,

valueint

)

altertable test addconstraint chk_possible check(valuein(1,2,3))

insertinto test values(1,1)--Works

insertinto test values(1,7)--Fail

Certificate creation problem

Hello to all

I have two SQL 2005 server and I want to start mirroring a database.
Since there's no windows domain I'm trying to use certificates to grant connection between servers.

At this point I find some difficulties...

I've read on MSDN that 'active FOR begin_dialog = ON' option must be specified; look at the code below, when I execute I get following error:

Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'FOR'.

CREATE CERTIFICATE Polx

WITH SUBJECT = 'Mirror certificate',

START_DATE = '10/31/2001',

EXPIRY_DATE = '10/31/2009',

active FOR begin_dialog = ON;

GO

CREATE SYMMETRIC KEY Key1

WITH ALGORITHM = RC4

ENCRYPTION BY CERTIFICATE Polx

GO

Any suggestion will be really appreciated!!!

By the way, do I have to create same certificate on the mirror server after creating it on the master?

Thanks, Carlo

You should try removing the comma before the ACTIVE keyword. From my experience with database mirroring, however, I don't remember this clause being required. The certificate used for mirroring needs to exist on both the principal and the mirror.

Thanks
Laurentiu|||

Here's some additional information about setting up database mirroring. I hope this will help:

http://blogs.msdn.com/lcris/archive/2005/09/14/466268.aspx

Thanks
Laurentiu