Home Forums SQL Server 2005 SQL Server 2005 Security Is there any way to script out Linked server with remote login password ? RE: Is there any way to script out Linked server with remote login password ?

  • January 16, 2013 at 12:26 pm

    #1577991

    nope it's not possible.

    linked server password, remote credential password, and also the password used for smtp authentication for any mail profiles are stored in a CREDENTIAL object, and there is no way to reverse engineer/read the value from the database.

    so you can script out the settings, and enter the correct value into the script afterwards(if you know it)

    but there is no way to get it from SQL.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!