RE: NT4 Migration



Hi,

My understanding is you want to restructure the NT4 domain into a AD
domain. Regarding this, please refer to following article first:

Restructuring Windows NT 4.0 Domains to an Active Directory Forest
<http://technet2.microsoft.com/WindowsServer/en/Library/7c829c8b-e944-49f2-9
f20-004685aa86321033.mspx?mfr=true>

I know your major concern is move SQL server 2000 to new domain.

First, which authentication method did you use? Windows Authentication or
Mixed authentication? Basically if you enabled SID history feature in AD,
the users are still able to log in with old sid. If you want to remove sid
hirstory, check following steps:

1) Stopped all SQL Related Services and modified the startup mode to
manual.
2) Migrated SQL Server to new domain.
3) Modified the startup account for SQL.
4) Started SQL Server.
5) Generate output of sp_help_revlogin stored procedure.
6) Generated Permission script.
7) Detached all the user Database.
8) Dropped all the logins.
9) Used the permission script to recreate logins and add server level roles
10) Attached the user database.
11) Mapped the SIDS using sp_sidmap procedure.

SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://support.microsoft.com/?id=298897

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: NT4 Migration
thread-index: AcaV6XlI4FzO3/JhTkikofQ1kGeGbQ==
X-WBNR-Posting-Host: 212.15.92.234
From: =?Utf-8?B?SVRDIEdpcmw=?= <ITCGirl@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: NT4 Migration
Date: Thu, 22 Jun 2006 03:49:02 -0700
Lines: 14
Message-ID: <1E6B725A-E94E-4913-AE93-D507AD11F587@xxxxxxxxxxxxx>
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.1830
Newsgroups: microsoft.public.windows.server.migration
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.windows.server.migration:24177
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.migration

Hi,

I am currently planning an upgrade of our domain from NT4 to W2003AD.
Current hardware will not take an upgrade so we are replacing both the
PDC
and BDC with new kit and will be using the old kit for rollback (just in
case). I have one major concern that an advice on would be great: -

We have a W2003 server that is running SQL2000 and Microsoft Great Plains
V8
- I am not planning to upgrade this server but need to add it to the new
domain. I have spoken with our support people for Great Plains and they
suggest that we take the SQL server off the old domain and add it to the
new
domain.

Has anyone experienced problems with this in the past?


.



Relevant Pages

  • RE: SQL server migration
    ... which authentication method did you use? ... Basically if you enabled SID history feature in AD, ... Migrated SQL Server to new domain. ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • RE: SQL server migration
    ... which authentication method did you use? ... Basically if you enabled SID history feature in AD, ... Migrated SQL Server to new domain. ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • Re: use of tempdb by union all
    ... there are special situation where space inside the user database are ... enhancement to SQL Server is that we can specify tempdb to be used for this. ... > that "SQL will not allocate 'scratch space' from the user database" might ...
    (microsoft.public.sqlserver.programming)
  • Re: use of tempdb by union all
    ... SQL Server will indeed allocate "scratch space" from the user database, ... >> It was my impression that the tempdb database will be used when SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: Replacing domain SID on ACEs in DACL
    ... As your script walks the storage, examining DACLs, ... If the storage was originally in NT4, ... >> the users to the data is via sid history. ...
    (microsoft.public.win2000.file_system)