| title | sp_pdw_remove_network_credentials | |
|---|---|---|
| titleSuffix | Azure Synapse Analytics | |
| description | sp_pdw_remove_network_credentials removes network credentials stored in Azure Synapse Analytics. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.reviewer | randolphwest | |
| ms.date | 06/23/2025 | |
| ms.service | sql | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016 || =azure-sqldw-latest |
[!INCLUDE applies-to-version/asa-pdw]
sp_pdw_remove_network_credentials removes network credentials stored in [!INCLUDE ssazuresynapse-md] to access a network file share. For example, use this stored procedure to remove permission for [!INCLUDE ssazuresynapse-md] to perform backup and restore operations on a server that resides within your own network.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
Syntax for Azure Synapse Analytics and Analytics Platform System (PDW).
sp_pdw_remove_network_credentials 'target_server_name'
Note
[!INCLUDE synapse-analytics-od-unsupported-syntax]
Specifies the target server host name or IP address. target_server_name is nvarchar(337) with no default. Credentials to access this server are removed from [!INCLUDE ssazuresynapse-md]. This doesn't change or remove any permissions on the actual target server, which is managed by your own team.
0 (success) or 1 (failure).
Requires ALTER SERVER STATE permission.
An error occurs if removing credentials doesn't succeed on the Control node and all Compute nodes.
This stored procedure removes network credentials from the NetworkService account for [!INCLUDE ssazuresynapse-md]. The NetworkService account runs each instance of SMP [!INCLUDE ssNoVersion] on the Control node and the Compute nodes. For example, when a backup operation runs, the Control node and each Compute node use the NetworkService account credentials to access the target server.
To list all credentials and to verify the credentials have been removed, use sys.dm_pdw_network_credentials.
To add credentials, use sp_pdw_add_network_credentials (Azure Synapse Analytics).
The following example removes user name and password credentials for accessing the target server, which has an IP address of 10.192.147.63.
EXECUTE sp_pdw_remove_network_credentials '10.192.147.63';