The LocalName property identifies a Microsoft® SQL Server™ login record used by a second server for privilege determination.
object.LocalName [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | String identifying an existing SQL Server login |
One SQL Server installation can implement SQL Server connection authorization for another SQL Server installation. An authorized server may connect to execute a remote procedure call or for other purposes.
To establish authorization, a remote server is defined on the authorizing SQL Server installation. A mapping (remote login) for a login established and maintained on the remote server can be built on the authorizing SQL Server installation.
For example, a server, called AcctPay, used by an organization’s accounts payable department, may execute remote stored procedures on the purchasing department’s Purch server. On Purch, an AcctPayRemote login is created and given appropriate rights for all accounts payable department users. For each authorized login on AcctPay, a remote login is created and mapped to AcctPayRemote.
Note Remote server and login records enable SQL Server Authentication for connections initiated by a SQL Server installation.
String
Read/write
HRESULT GetLocalName(SQLDMO_LPBSTR pRetVal);
HRESULT SetLocalName(SQLDMO_LPCSTR NewValue);
Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.