July 25, 2012 at 12:19 am
Hi,
domain migration database server.
Example
X - Old domain
y - New domain
Currently database & application servers are running X domain name,
Only database server to be change Y domain,
Not convert to application server Y domain as it is old domain X.
Please let me know, Does application should working with multiple domains?
thanks
ananda
July 25, 2012 at 1:53 am
What authentication method do you use for the applications? Windows or SQL?
Will there be a two way trust in place between the domains?
Do you use hostname or IP for the connection string to SQL?
Can the connection strings be easily changed?
July 25, 2012 at 3:05 am
1. What authentication method do you use for the applications?
SQL Server configured Mixed mode authentication, application using SQL authentication.
2. Windows or SQL?
Application connected with SQL user.
3. Will there be a two way trust in place between the domains?
Between two domain trust relation, it can be access two way
Do you use hostname or IP for the connection string to SQL?
This is more important question.
1. Application connection string using IP address.
2. Hostname & Ip addresswill be changed during new domain migration
SQL Configuration manager -> New IP address need to modified also connection string at application server.
3. Can the connection strings be easily changed?
yes, It can easily changed conection strings at xml file format.
thanks
ananda
July 25, 2012 at 3:10 am
As long as DNS can resolve between the two domains, then you should be fine. As your using IP it should just be a simple connection string change, if you use the actual hostname I would change it to the FQDN hostname so that DNS knows where to direct traffic.
As your not using windows auth in the connection string the two way trust isn't needed, but if you have developers or users which connect via windows then you will need two way trust.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply