October 21, 2008 at 3:19 pm
I'm running SQL Server 2005 with mixed-mode authentication where I use Windows domain login accounts in SQL Server. My network admin needs to change our domain and I'm not sure how this will affect SQL Server. The SQL Server machine name and IP address will remain the same. I know how to join the SQL Server machine to a new domain. My questions are:
Will the network domain change automatically propogate through to SQL Server so the logins will specify the new domain name?
Or do I need to somehow change them manually or do some other modifications?
If so, what do I need to do and how do it do it?
Thanks, Joan
October 21, 2008 at 4:19 pm
If you change to a new domain, the logins will keep working only if the SIDs of the user accounts on the new domain remain the same.
October 21, 2008 at 4:20 pm
You'll need to change the logins. This data is stored in the server, so if the outside domain changes, you need to either setup trust or change the logins. You can likely script them out (drops and adds) and then do a search and replace on the domain.
October 22, 2008 at 10:02 am
How do I ensure that the SIDs remain the same? Do they change or get recreated when you change the domain the server belongs to?
October 22, 2008 at 10:06 am
Can I simply rename the logins manually via Management Studio and replace the old domain name with the new domain name?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply