Reset Password for linked server login

  • Hi All,

    Please help me on the below scenario.

    * SQL Server 'A' has 1..n different linked servers pointing Server 'B' with different remote logins.

    * Password got modified for one account i.e. 'login1' in Server 'B'

    Can you please help how to fetch the linked servers using remotelogin as 'login1' . so that i can reset password for only those linked servers

    Thanks in advance !

  • try this...

    select srv.name,lgn.Remote_name

    from sys.servers srv, sys.linked_logins lgn

    where srv.server_id=lgn.server_id

    and lgn.remote_name='login1'

    also refer to the BOL link

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/06d53a67-7804-4f1f-8201-3e42dc48ba79.htm

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • Thanks a lot !

    One more query. I used this login/pwd to create Distributor db and so all my replications are runing on this. Can you please help me with the command to reset the password for the Distribution DB.

    Thanks again !

  • Can anyone help on my second query please....

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

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