Hi....

Please Help.... I want to transfer my whole databases from my server to another server at everyday night. But when I use the DTS Transfer Database Task its gives an error "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Unspecified error". Again If I use DTS Copy SQL Server Object task then another error arise "Microsoft SQL-DMO (ODBC SQLState: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The login 'accessuser' does not exist." Can any of you guys help me out??? Thanks in advance

Thanks a lot...

Regards...

Rajib.

Hi,

Without tracking correct error statement we can identify the bug. So, unspecified error doesnot give correct meaning.

"The login 'accessuser' does not exist" specifies that the user accessuser does not exist into new database server. So, u can try creating the user first into the new server(destination) and then u can try the same.

A.D.Ramkumar

thanks a lot...A.D.Ramkumar


Thanks a lot...

Regards...

Rajib.