Moving Databases/DTS Packages between servers

[StevenK]

When I move either databases or DTS packages from one server to another - when I attempt to do anything with the moved object I get a problem due to a mismatch in the username/password used. It appears that the username/password is being saved as part of the moved object and I then have to re-enter the password for accessing the database objects on the target server in the case of a database. For a DTS package I am prevented from accessing it on the target server due to a mismatch in passwords (the SQL Server the objects are saved from have no password and the SQL Server moved to has a password set.).
Can anyone suggest a way round this ?
Thanks in advance
Steve

 

[tlbroadbent]

Do you mean the logins on the new server have a passowrd? Or are you referring to DTS PAcakages with passwords? I don't quite understand.

It is common to have mismatches between logins and users when moving databases from one server to another. You can easily fix that problem with sp_change_users_login.

Check this article for more info.

Fixing broken logins and transferring passwords

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[StevenK]

The databases/DTS packages are created (and backed up) on one SQL server and then restored onto a different SQL server which does not have a username password (for 'sa' user) matching that of the source SQL Server.
When I try to open database objects on the target server (where I have performed the restore) I have to re-enter my password for each object. In the cases of restore DTS packages (on the target server) I am unable to gain any access for editing and executing.
Hope this provides enough details.
Steve

 

[Guest_imported]

Hi,

maybe I'm missing something, but when I move a DTS package from server to server nothing works unless I manually open the DTS on the destination server and change the server name and user/pwd. I can set up matching accounts on both servers, but how do I fix ther server name problem?

thanks!