Post reply

migrate linkedserver

  • October 21, 2010 at 1:59 am

    #228210

    i'm migrating a db in 2008 to another,there's lots of linkedserver,and i've lost the password of some server,how can i migrate them?

    thanks

  • October 21, 2010 at 2:23 pm

    #1240589

    The linked server can be scripted to a new query by right clicking on the linked server. You may execute this script on the destination instance.

    Hope I understood your question right.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 21, 2010 at 2:32 pm

    #1240594

    I think the original poster is out of luck.

    when you script a linked server, you get this specific comment/message, telling you that it won't script the password:

    /* For security reasons the linked server remote logins password is changed with ######## */

    AFAIK, the actual username and password, if you are not using a trusted connection, gets stored as a CREDENTIAL, and thus is not exposed to scripting, decoding or anything else i'm aware of.

    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!

  • October 21, 2010 at 7:44 pm

    #1240676

    thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply