Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-23 : 08:38:03
|
| totusPorcus writes "I am in the process of moving all databases from server A to server B.I need to move the databases, userids with logins, jobs, alerts, operators, DTS packages and LINKED SERVERS.Using various tools and scripts available, I have been able to do everthing except script out the passwords for LINKED SERVERS.I have found scripts that allow me to transfer database userids and passwords basically using a script that generates as part of a series of sp_addlogin commands with the string 'skip_encryption'.Basically, I would like to be able to do the exact same thing for a script that is used to move LINKED SERVERS from one machine to another.Is this possible? What is the trick?Thanks." |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-11-26 : 10:33:42
|
| I faced the same problem some time back. Luckily i had the passwords for my linked servers. I don't think there is a script for linked server migration.Why don't you create your own new userid/pwd for linked server. Since this login is not used anywhere else, i feel you can create a new login ID.------------------------I think, therefore I am |
 |
|
|
|
|
|
transfer linked server PASSWORDS possible via script