Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Domain Migration Expand / Collapse
Author
Message
Posted Sunday, March 7, 2010 11:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:25 AM
Points: 8, Visits: 61
Hi Champs,

I have requirement to Migrate SQL server 2005 from one doamin/forest to another Domain/forest.

I have few applications and some applications use SQL authentication and some uses AD authentication. I am pretty comfortable about applications those are using SQL authentication is there will not be issue if i move Application anywhere to domain/forest.

My concern was on SQL Databases and application those are tied up AD authentication. Will you experts suggest me what would be approach and steps tp move such types of SQL setups to different domain/forest where users getting authetincated Via Active directory.

Thanks in Advance :)

Regards
Inder.
Post #878424
Posted Monday, March 8, 2010 6:23 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:28 AM
Points: 33, Visits: 628
For each Windows Autentication Login you need to create another login in the new DOMAIN.

You need to change the account that start the SQL Server services if that use a Domain account.

I change my DOMAIN a few month ago. Try to translate this post:
http://www.mcdbabrasil.com.br/modules.php?name=Forums&file=viewtopic&t=3595



I'm from Brazil. I have a basic English. I hope help you.


Fabrício França Lima
MCITP – Database Administrator
Twitter: @fabriciodba
http://fabriciodba.wordpress.com/

Post #879030
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse