July 21, 2003 at 3:41 pm
How do you transfer the remote login and password fields in linked servers to another server?
July 22, 2003 at 6:26 am
What do you mean by transfer?
Far away is close at hand in the images of elsewhere.
Anon.
July 22, 2003 at 12:33 pm
We have a new server and I was able to recreate everything on the new server from the old server except the logins and passwords on the linked servers that have remote logins and passwords.
July 23, 2003 at 2:33 am
If you are using a remote login in a linked server, that login does not need to be transferred to your new server, just create the Linked Server with the same details as the old server. I don't remember if it is possible to script the Linked Server details, try searching this forum or the web.
Far away is close at hand in the images of elsewhere.
Anon.
July 23, 2003 at 11:51 am
I am unable to fully create the new linked servers because I don't know the passwords, that's why I was trying to find a way to transfer logins and passwords.
July 23, 2003 at 12:27 pm
You should know the login created in old linked server. That is the login for you connect to the remote server. You can review the the login's database access and permissions in remote server and create a similar one with new password. Use the new login with known password to create the linked server completely.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply