次の方法で共有

LinkedServerLogin Object

  • [アーティクル]

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The LinkedServerLogin object exposes the properties of an authentication record mapping used when an instance of Microsoft SQL Server attempts to connect to a linked server.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

LocalLogin Property

RemotePassword Property

Impersonate Property

RemoteUser Property

Methods

Remove Method (Objects)

 

解説

SQL Server supports Transact-SQL queries against data stored in one or more SQL Server and heterogeneous databases. SQL Server distributed queries use OLE DB to access a non-local data store.

OLE DB defines a provider as an OLE DB component that can deliver data from a store. Typically, OLE DB providers can discriminate among applicable, available data stores. OLE DB defines a data source as that information necessary for the successful delivery of data from the store (such as a user identifier and password).

SQL Server implements persistent storage of an OLE DB provider name and data source definition called a linked server. A record maintaining authentication data for a linked server is called a linked server login.

With the LinkedServerLogin object, you can:

  • Map SQL Server authentication data to authentication data required by a linked server.
  • Configure existing authentication mappings.
  • Remove an existing authentication mapping, disabling linked server accessibility for the SQL Server login record mapped.

To create a linked server login

  1. Create a LinkedServerLogin object.

  2. Set the LocalLogin property.

  3. Optionally, if authentication impersonation is supported, set the Impersonate property. If authentication impersonation is not required then set the RemoteUser and RemotePassword properties to authentication data values valid for the linked server.

  4. Add the LinkedServerLogin object to the LinkedServerLogins collection of a LinkedServer object referencing the appropriate linked server.

ms135657.note(ja-jp,SQL.90).gifメモ :
When a linked server is created, SQL Server creates a default linked server login specifying a NULL local login name and authentication impersonation. This special purpose login mapping record provides authentication data mapping for those logins not mapped explicitly.