SQL Server Performance Forum – Threads Archive

Transfer Login Task (DTS)

I have a problem with „Transfer Login Task” (DTS) which I use to copy the logins from the primary server to the secondary server When I execute the package it returns error – 1 task fail during execution – Unspecified error What is funny, logins are transferred to the standby server. But not all data is right, the logins default language on the standby server is different from the primary server. I#%92m worrying that there are more differences. Does anybody know how to fix it? This is the output from the SQL Profiler: set noexec off set parseonly off
go
— ‘sp_addlogin’ was found in the text of this event.
— The text has been replaced with this comment for security reasons.
go
set noexec off set parseonly off
go
— ‘sp_addlogin’ was found in the text of this event.
— The text has been replaced with this comment for security reasons.
go
set noexec off set parseonly off
go
exec sp_configure ‘allow updates’, 0
reconfigure with override
go
set noexec off set parseonly off
go

---

Are you sure both primary and secondary servers collation and other settings are similar?
What is the level of service pack on both the servers? Take help from this KBAhttp://support.microsoft.com/default.aspx?kbid=246133 to fix the orphaned users and other issues. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>