July 5, 2010 at 2:12 am
Hi. I have forgotten the password for my linked server in SQL Server 2000, so I want to retrieve it to re-create the linked server in SQL Server 2005. Is it possible? How? Many thanks
July 5, 2010 at 3:02 am
It's not possible to retrieve current password. You can only change it.
Can you log in with a different account and reset that password?
-- Gianluca Sartori
July 5, 2010 at 6:32 am
Ok. I hope to retrieve the pwd. Fe, it is possible to retrieve logins and passwords to migrate logins from SQL Server 2000 to 2005. Thanks
July 6, 2010 at 2:02 pm
No, not possible.
July 6, 2010 at 2:53 pm
Is it not possible to retrieve the password encrypted? Thanks
July 7, 2010 at 1:07 am
I think you can retrieve the encrypted password, but you won't do much with it.
If you want to migrate logins, follow the guidelines described here: http://support.microsoft.com/?scid=kb;en-us;246133&x=15&y=18
-- Gianluca Sartori
July 7, 2010 at 2:33 am
Hi. The goal is to migrate the entire linked server, thus also with the password.
I don't want to retrieve the pwd to know it but in order to migrate the linked server from SQL Server 2000 to 2005.
Thanks
July 7, 2010 at 2:37 am
OK, so you should find the information you're looking for in the document I posted.
-- Gianluca Sartori
July 7, 2010 at 7:49 am
I have a look to the article.
I want to migrate a linked server and the related password. A linked server can point to a different data source respect to SQL Server. My question isn't about to transfer logins in SQL Server from 2000 to 2005. I think that as it is possible to migrate a login as it is possible to migrate a linked server with the related password.
Thanks
July 8, 2010 at 6:25 am
It was stated earlier that you can not recover a password only reset it, whether or not you migrate the logon from any SQL Server version.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy