SQL Server Domain Migration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server Domain Migration

SQL Server Domain Migration

Rate Topic

Display Mode

Topic Options

Author

Message

inderrathore

Posted Sunday, March 07, 2010 11:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:50 PM
Points: 8, Visits: 60

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

FabricioLimaDBA

Posted Monday, March 08, 2010 6:23 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:34 AM
Points: 33, Visits: 547

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 »

Permissions