Solved

Affect of doing a Domain Rename on SQL Server 2005 logins?

Posted on 2008-10-03
4
978 Views
Last Modified: 2008-11-16
Hi, 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 do a "Domain Rename" and I'm not sure how this will affect SQL Server.  Will the 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?
0
Comment
Question by:jjltpc
4 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 22634634
I believe it should be fine, so long as all of the accounts keep the same sid.
0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 250 total points
ID: 22634661
The domain name is just a use friendly representation.  All that matters is the guts of it.  As long as your SID doesn't change you're fine.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 62
Truncate vs Delete 63 105
How to use TOP 1 in a T-SQL sub-query? 14 45
What is wrong with the below insert statement. Getting error when executing. 5 37
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question