April 20, 2004 at 12:37 pm
This question may be too broad, but I'll give it a shot anyway!
My company is in the process of implementing Active Directory.
What issues related to SQL Server to I need to surface? Will migrating SQL Server from our NT Domain to Active Directory present any particular problems?
Thank you in advance for your thoughts.
April 20, 2004 at 12:48 pm
I've not experienced any problems with this. Presumably you will be migrating the users as a part of the changeover? If so the users sids will be consistent and you won't experience any problems. Should this information change (ie you create new users to replace the old) you might run into some authentication issues.
April 20, 2004 at 12:52 pm
Thank you! Something to consider.
April 20, 2004 at 1:03 pm
When we did the migration we used a tool from BindView called bv-Admin. This migrated all user accounts along with their profiles, mailboxes etc, and saved us from running into the problem of unmatched sids.
April 20, 2004 at 1:20 pm
Are you setting up a side-by-side NT 4.0 and AD or are you upgrading the existing AD environment?
K. Brian Kelley
@kbriankelley
April 20, 2004 at 1:29 pm
They are implementing AD for the first time, so I guess side by side NT 40.0 and AD
April 20, 2004 at 1:42 pm
Then a tool like stacenic described makes the job really easy if that's possible. We're in a side-by-side and having to do a lot of conversions by hand. It's not been too bad overall. Minor impact on SQL Server now. The key is to ensure if it's a side-by-side to create proper security principals in the new environment (users and groups) matching the old. That's where said tool comes in really handy.
K. Brian Kelley
@kbriankelley
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply