DTS: The login already has an account under different user name
Came across this package failing one today when trying to copy database objects to a different server.
After trying various things discovered the cause was the client had setup dbo ownership to a local account.
You can test this by running;
select ‘MyDatabase’, l.loginname as [login name],u.name as [user name]
from [MYDatabase]..sysusers u
inner join master..syslogins l
on u.sid=l.sid
Your options are then to either change the owner or in my case where the owner is currently out of reach, go into the package/task properties and untick any options to carry over dependencies. For example in the transfer objects task you will see a option for ‘use default settings’, if you unclick this then you will see further options allowing you not to transfer user and login information across which will let the package complete successfully.
Loading...