| title | sp_helplinkedsrvlogin (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | a2b1eba0-bf71-47e7-a4c7-9f55feec82a3 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Provides information about login mappings defined against a specific linked server used for distributed queries and remote stored procedures.
Transact-SQL Syntax Conventions
sp_helplinkedsrvlogin [ [ @rmtsrvname = ] 'rmtsrvname' ]
[ , [ @locallogin = ] 'locallogin' ]
[ @rmtsrvname = ] 'rmtsrvname'
Is the name of the linked server that the login mapping applies to. rmtsrvname is sysname, with a default of NULL. If NULL, all login mappings defined against all the linked servers defined in the local computer running [!INCLUDEssNoVersion] are returned.
[ @locallogin = ] 'locallogin'
Is the [!INCLUDEssNoVersion] login on the local server that has a mapping to the linked server rmtsrvname. locallogin is sysname, with a default of NULL. NULL specifies that all login mappings defined on rmtsrvname are returned. If not NULL, a mapping for locallogin to rmtsrvname must already exist. locallogin can be a [!INCLUDEssNoVersion] login or a Windows user. The Windows user must have been granted access to [!INCLUDEssNoVersion] either directly or through its membership in a Windows group that has been granted access.
0 (success) or 1 (failure)
| Column name | Data type | Description |
|---|---|---|
| Linked Server | sysname | Linked server name. |
| Local Login | sysname | Local login for which the mapping applies. |
| Is Self Mapping | smallint | 0 = Local Login is mapped to Remote Login when connecting to Linked Server. 1 = Local Login is mapped to the same login and password when connecting to Linked Server. |
| Remote Login | sysname | Login name on LinkedServer that is mapped to LocalLogin when IsSelfMapping is 0. If IsSelfMapping is 1, RemoteLogin is NULL. |
Before you delete login mappings, use sp_helplinkedsrvlogin to determine the linked servers that are involved.
No permissions are checked.
The following example displays all login mappings for all linked servers defined on the local computer running [!INCLUDEssNoVersion].
EXEC sp_helplinkedsrvlogin;
GO
[!INCLUDEssResult]
Linked Server Local Login Is Self Mapping Remote Login
---------------- ------------- --------------- --------------
Accounts NULL 1 NULL
Sales NULL 1 NULL
Sales Mary 0 sa
Marketing NULL 1 NULL
(4 row(s) affected)
The following example displays all locally defined login mappings for the Sales linked server.
EXEC sp_helplinkedsrvlogin 'Sales';
GO
[!INCLUDEssResult]
Linked Server Local Login Is Self Mapping Remote Login
---------------- ------------- --------------- --------------
Sales NULL 1 NULL
Sales Mary 0 sa
(2 row(s) affected)
The following example displays all locally defined login mappings for the login Mary.
EXEC sp_helplinkedsrvlogin NULL, 'Mary';
GO
[!INCLUDEssResult]
Linked Server Local Login Is Self Mapping Remote Login
---------------- ------------- --------------- --------------
Sales NULL 1 NULL
Sales Mary 0 sa
(2 row(s) affected)
Security Stored Procedures (Transact-SQL)
sp_addlinkedserver (Transact-SQL)
sp_droplinkedsrvlogin (Transact-SQL)
System Stored Procedures (Transact-SQL)