Reset Password for linked server login

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Reset Password for linked server login

Reset Password for linked server login

Rate Topic

Display Mode

Topic Options

Author

Message

haichells

Posted Friday, January 22, 2010 4:17 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, March 09, 2010 4:45 AM
Points: 51, Visits: 179

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 !

Post #851896

Sqlfrenzy

Posted Friday, January 22, 2010 5:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, March 15, 2010 11:01 PM
Points: 1,316, Visits: 1,241

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,
Sqlfrenzy

Post #851926

haichells

Posted Friday, January 22, 2010 6:21 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, March 09, 2010 4:45 AM
Points: 51, Visits: 179

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 !

Post #851968

haichells

Posted Monday, January 25, 2010 5:08 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, March 09, 2010 4:45 AM
Points: 51, Visits: 179

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

Post #852928

« Prev Topic | Next Topic »

Permissions