Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Lists information on the credential that the target server uses to sign in to the master server.
Transact-SQL syntax conventions
Syntax
sp_msx_get_account
[ ; ]
Arguments
None.
Return code values
0 (success) or 1 (failure).
Result set
Returns the following result set:
| Column name | Type | Description |
|---|---|---|
msx_connection |
int | Master server connection number. |
msx_credential_id |
int | ID of the credential used for this master server connection. |
msx_credential_name |
sysname | Name of the credential used for this master server connection. |
msx_login_name |
nvarchar(4000) | Domain name and user name of the Windows user for the credential. |
Remarks
Returns an empty result set if there's no credential specified for this target server. To set the credential, use sp_msx_set_account.
Permissions
You can grant EXECUTE permissions on this procedure, but these permissions might be overridden during a SQL Server upgrade.
Examples
The following example lists information for the credential that this target server uses to connect to the master server.
USE msdb;
GO
EXECUTE dbo.sp_msx_get_account;
GO
Here's a sample result set:
msx_connection msx_credential_id msx_credential_name msx_login_name
-------------- ----------------- -------------------- -----------------------------
1 65538 MsxAccount AdventureWorks2022\MsxAccount