March 21, 2012 at 3:27 pm
Hi All,
I was unable to find this scenario anywhere so I"m looking for some advice. We are moving from a Windows 2003 domain to 2008 but the name has to change as it has an underscore in it.
The network team has plans to move the users first (building by building, we have 5) and once all the users have been moved we will move the servers. This will happen over the course of a couple months.
There is a trust between the domains but how do I setup Windows Authenticated user accounts in SQL 2005 for users that have been moved to the new domain? The new domain does not come up as a location when I try to create the new security accounts.
Their AD accounts will persist on the old domain until the servers are moved, will that be enough to allow them to connect to SQL using windows auth while logged into the new domain? If not how do I get SQL to see the new domain?
Thanks
Kelsey
March 22, 2012 at 2:46 am
you can manually type in the domain extension into the login box instead of searching for the users if the domains are not in the same forest, if they are then you should be able to search in the entire directory.
could also do a manual script which recreates the login as the new domain account and sets all the security as it was to the old account
March 22, 2012 at 10:23 pm
I have seen that script but wasn't sure it would work because I couldn't actually browse to the domain. I will give it a try after they move the first couple of users.
Thanks so much for the reply,
Kelsey
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply