Link to home
Start Free TrialLog in
Avatar of dcadler
dcadler

asked on

SQL Server 2008R2 Copy Database fails trying to create a domain login

I have an existing SQL Server 2008R2 server on Domain_A and a new SLQ Server 2008R2 on Domain_B. I am trying to use the Copy Database SSIS method to copy an existing database from Domain_A to Domain_B. I am using SQL authentication on both accounts to get around untrusted domain issues.

In to Copy Database Wizard, on the "Select Server Objects" page, I removed the Logins object from the "Select related objects" field because I want to re-create logins form Domain_B once the database is copied.

However, the copy database wizard fails with an Event ID 12550 in the destination server application event log (source: SQLISPackage100), stating the following;

Message: Error: Error code= -1073548784  description = Executing the query "Create user [Domain_A\IUSR_MA3] for login [Domain_A\IUSR_MA3] failed with the following error: Windows NT user or group "Domain_A\IUSR_MA3" not found.

It appears that it is trying to create a login for the database on the destination server, even though I explicitly removed the "logins" from the Selected server objects list.

Any ideas?

Thanks,

Dave
SOLUTION
Avatar of Abdul Jalil Abou Alzahab
Abdul Jalil Abou Alzahab
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dcadler
dcadler

ASKER

Well, I can't create trusts between the domains because the whole purpose of the project is to separate the companies.

I had removed the user IUSR_MA3 from the DomainA database and I made sure to not include logins in the copy. It still did not work. I ended up just doing a manual backup/restore to move the database from DomainA to DomainB

I appreciate your help and I'll go ahead and split the points
Well, I can't create trusts between the domains because the whole purpose of the project is to separate the companies.
I don't believe anyone was suggesting that, but I am glad you got figured out.