bdorsey63
asked on
Accessing MS SQL server from different AD domain
Assumptions:
We are moving clients from one domain to another.
The application is client/sever.
The clients are moving to a new domain,
the MS SQL 2005 server is remaining in the old domain
The current clients are using AD authentication.
All new client will log into the new domain.
What are the issue I will face regarding having the clients in the new doamin access the server in the old domains?
1. Do I need to change the user ids in the ms sql database?
2. If the old domain controller is available, is there a method to map old ids to the new id's and there for still have single sign on?
3. Is sql login ids an option?
4. What else can be done on the client side to access the old sql server running on the old domain? Change ODBC config?
We are moving clients from one domain to another.
The application is client/sever.
The clients are moving to a new domain,
the MS SQL 2005 server is remaining in the old domain
The current clients are using AD authentication.
All new client will log into the new domain.
What are the issue I will face regarding having the clients in the new doamin access the server in the old domains?
1. Do I need to change the user ids in the ms sql database?
2. If the old domain controller is available, is there a method to map old ids to the new id's and there for still have single sign on?
3. Is sql login ids an option?
4. What else can be done on the client side to access the old sql server running on the old domain? Change ODBC config?
If your new domain is within the same firewall that your old domain resides in, then you should have no problem.
I am not real sure if you are referring to server when you use the word domain.
Quite frankly, the whole thing is a bit confusing.
I am not real sure if you are referring to server when you use the word domain.
Quite frankly, the whole thing is a bit confusing.
ASKER
Do you plan to have trusts in place between the old and the new domain? Yes
The word from the windows team is that they will use "SID History".
Does the application itself ask for a username and password or is it pass-through authentication? Good question, I will find out next week.
I am not real sure if you are referring to server when you use the word domain.
Good catch... By domain, I mean active directory domain.
The word from the windows team is that they will use "SID History".
Does the application itself ask for a username and password or is it pass-through authentication? Good question, I will find out next week.
I am not real sure if you are referring to server when you use the word domain.
Good catch... By domain, I mean active directory domain.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Does the application itself ask for a username and password or is it pass-through authentication?