In configuring log shipping, i have been attempting to follow directinos and
set up a job to transfer logins frm the Production server to the standby
server. This job includes a step that runs a DTS package that uses the
Transfer Logins Task step. This step fails with an Unspecified Error
everytime it runs.

I have modified the sp_resolve_logins stored procedure on each server as
specified in Knowledge Base article 310882.

Both servers are Windows 2003 with SQL Server 2000, SP 3.

Any thoughts or ideas?

Thanks,

Matt

BandoM@CSCTechnologies remove dot com

I think I found the culprit. When the SQL cluster for the Production server
was initially installed, a login was created for an account that was local to
one of the cluster nodes for some reason, and this obviously fails on the
Standby server during login transfer.

Thanks,

Matt

"Matthew Bando" wrote: