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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply