Post reply

Reset Password for linked server login

  • January 22, 2010 at 4:17 am

    #142001

    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 !

  • January 22, 2010 at 5:16 am

    #1107248

    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]

  • January 22, 2010 at 6:21 am

    #1107284

    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 !

  • January 25, 2010 at 5:08 am

    #1108083

    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