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
Microsoft SQL Server 2008Microsoft SQL ServerWindows Server 2008SSIS

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon
SOLUTION
Abdul Jalil Abou Alzahab

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Anthony Perkins

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
Anthony Perkins

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61