Classe LinkedServerLogin
The LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
Gerarchia di ereditarietà
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.LinkedServerLogin
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<SfcElementTypeAttribute("Login")> _
Public NotInheritable Class LinkedServerLogin _
Inherits NamedSmoObject _
Implements ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable
'Utilizzo
Dim instance As LinkedServerLogin
[SfcElementTypeAttribute("Login")]
public sealed class LinkedServerLogin : NamedSmoObject,
ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable
[SfcElementTypeAttribute(L"Login")]
public ref class LinkedServerLogin sealed : public NamedSmoObject,
ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable
[<SealedAttribute>]
[<SfcElementTypeAttribute("Login")>]
type LinkedServerLogin =
class
inherit NamedSmoObject
interface ISfcSupportsDesignMode
interface ICreatable
interface IDroppable
interface IAlterable
end
public final class LinkedServerLogin extends NamedSmoObject implements ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable
Nel tipo LinkedServerLogin sono esposti i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
LinkedServerLogin() | Initializes a new instance of the LinkedServerLogin class. | |
LinkedServerLogin(LinkedServer, String) | Initializes a new instance of the LinkedServerLogin class for the specified linked server and with the specified name. |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
DateLastModified | Gets the date and time when the linked server logon was last modified. | |
Impersonate | Gets or sets the Boolean property value that specifies whether the SQL Server authenticated logon account connects to the linked server using its own credentials or using a specified logon name and password. | |
Name | Gets or sets the name of the linked server log-in. Esegue l'override di NamedSmoObject.Name. | |
Parent | Gets or sets the Server object that is the parent of the LinkedServerLogin object. | |
Properties | Gets a collection of Property objects that represent the object properties. Ereditato da SqlSmoObject. | |
RemoteUser | Gets or sets an alternative logon name for the linked server logon to impersonate when it accesses data on a linked server. | |
State | Gets the state of the referenced object. Ereditato da SmoObjectBase. | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. Ereditato da SqlSmoObject. | |
UserData | Gets or sets user-defined data associated with the referenced object. Ereditato da SmoObjectBase. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
Alter | Updates any property changes on an instance of SQL Server. | |
Create | Creates a linked server logon as defined by the LinkedServerLogin object. | |
Discover | Discovers a list of type Object. Ereditato da SqlSmoObject. | |
Drop | Removes the linked server logon. | |
Equals | Ereditato da Object. | |
FormatSqlVariant | Formats an object as SqlVariant type. Ereditato da SqlSmoObject. | |
GetContextDB | Gets the context database that is associated with this object. Ereditato da SqlSmoObject. | |
GetDBName | Gets the database name that is associated with the object. Ereditato da SqlSmoObject. | |
GetHashCode | Ereditato da Object. | |
GetPropValue | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetServerObject | Gets the server of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetType | Ereditato da Object. | |
Initialize() | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
IsObjectInitialized | Verifies whether the object has been initialized. Ereditato da SqlSmoObject. | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. Ereditato da SqlSmoObject. | |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. Ereditato da SqlSmoObject. | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. Ereditato da SqlSmoObject. | |
SetRemotePassword(SecureString) | Sets the password for an alternative login name used when a distributed query or another SQL Server process accesses data on a linked server using an OLE DB Provider. | |
SetRemotePassword(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. | |
ToString | Returns a String that represents the referenced object. Ereditato da SqlSmoObject. | |
Validate | Validates the state of an object. Ereditato da SmoObjectBase. |
In alto
Eventi
Nome | Descrizione | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. Ereditato da SqlSmoObject. | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. Ereditato da SqlSmoObject. |
In alto
Implementazioni esplicite dell'interfaccia
Nome | Descrizione | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetDomainRoot | Returns the root of the domain. Ereditato da SqlSmoObject. | |
IAlienObject.GetParent | Gets the parent of this object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyType | Gets the type of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. Ereditato da SqlSmoObject. | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. Ereditato da SqlSmoObject. | |
IAlienObject.SetPropertyValue | Sets the property value. Ereditato da SqlSmoObject. | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. Ereditato da SqlSmoObject. | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. |
In alto
Osservazioni
To get LinkedServerLogin object properties, users can be a member of the public fixed server role.
To set LinkedServerLogin object properties, users must have ALTER ANY LOGIN permission on the server or be a member of the sysadmin fixed server role.
To create or drop a linked server login, users must have ALTER ANY LOGIN permission on the server or be a member of the sysadmin fixed server role.
To set the password for the linked server login, users must have ALTER ANY LOGIN permission on the server or be a member of the sysadmin fixed server role.
Thread Safety
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Esempi
Utilizzo di server collegati in SMO
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo