Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reset Password for linked server login Expand / Collapse
Author
Message
Posted Friday, January 22, 2010 4:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 28, 2014 9:13 PM
Points: 81, Visits: 384
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
Posted Friday, January 22, 2010 5:16 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 3:10 AM
Points: 1,475, Visits: 1,623
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
Posted Friday, January 22, 2010 6:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 28, 2014 9:13 PM
Points: 81, Visits: 384
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
Posted Monday, January 25, 2010 5:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 28, 2014 9:13 PM
Points: 81, Visits: 384
Can anyone help on my second query please....
Post #852928
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse