LinkedServerLogin.SetRemotePassword Method (String)

Sets the password for an alternative logon name used when a distributed query or another SQL Server process accesses data on a linked server using an OLE DB Provider.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub SetRemotePassword ( _
    password As String _
)
'Usage
Dim instance As LinkedServerLogin 
Dim password As String

instance.SetRemotePassword(password)
public void SetRemotePassword(
    string password
)
public:
void SetRemotePassword(
    String^ password
)
member SetRemotePassword : 
        password:string -> unit
public function SetRemotePassword(
    password : String
)

Parameters

Remarks

This property is valid only when the Impersonate property is set to the value True.

Examples

Using Linked Servers in SMO

See Also

Reference

LinkedServerLogin Class

SetRemotePassword Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Linked Servers (Database Engine)

sp_addlinkedsrvlogin (Transact-SQL)