Post reply

Script to change linked server password

  • October 2, 2012 at 11:37 am

    #265123

    Hi,

    Anyone have any script to change linked server password..or advise how to change linked server passoword. I tried using SSMS....and it's not working.

    Thanks,

    SueTons

    Regards,
    SQLisAwe5oMe.

  • October 2, 2012 at 2:29 pm

    #1544585

    1) Connect to SQL Server instance.

    2) Select Server Objects folder and expand.

    3) Select Linked Servers folder and expand.

    4) Right click on linked server which you want to change the password and select properties.

    5) Select Security and change the password on right side window and hit OK.

  • October 2, 2012 at 2:37 pm

    #1544587

    catchmekiran (10/2/2012)

    1) Connect to SQL Server instance.

    2) Select Server Objects folder and expand.

    3) Select Linked Servers folder and expand.

    4) Right click on linked server which you want to change the password and select properties.

    5) Select Security and change the password on right side window and hit OK.

    Yes, got it....Thanks Kiran.

    SueTons.

    Regards,
    SQLisAwe5oMe.

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

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