sp-xp-cmdshell-proxy-account-transact-sql.md

---

title: "sp_xp_cmdshell_proxy_account (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/16/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology:

• "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
• "sp_xp_cmdshell_proxy_account"
• "sp_xp_cmdshell_proxy_account_TSQL" dev_langs:
• "TSQL" helpviewer_keywords:
• "sp_xp_cmdshell_proxy_account"
• "xp_cmdshell" ms.assetid: f807c373-7fbc-4108-a2bd-73b48a236003 caps.latest.revision: 15 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "On Demand" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

---

sp_xp_cmdshell_proxy_account (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Creates a proxy credential for xp_cmdshell.

Note

xp_cmdshell is disabled by default. To enable xp_cmdshell, see xp_cmdshell Server Configuration Option.

Transact-SQL Syntax Conventions

Syntax

  
sp_xp_cmdshell_proxy_account [ NULL | { 'account_name' , 'password' } ]  

Arguments

NULL
Specifies that the proxy credential should be deleted.

account_name
Specifies a Windows login that will be the proxy.

password
Specifies the password of the Windows account.

Return Code Values

0 (success) or 1 (failure)

Remarks

The proxy credential will be called ##xp_cmdshell_proxy_account##.

When it is executed using the NULL option, sp_xp_cmdshell_proxy_account deletes the proxy credential.

Permissions

Requires CONTROL SERVER permission.

Examples

A. Creating the proxy credential

The following example shows how to create a proxy credential for a Windows account called ADVWKS\Max04 with password ds35efg##65.

EXEC sp_xp_cmdshell_proxy_account 'ADVWKS\Max04', 'ds35efg##65';  
GO  

B. Dropping the proxy credential

The following example removes the proxy credential from the credential store.

EXEC sp_xp_cmdshell_proxy_account NULL;  
GO  

See Also

xp_cmdshell (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sys.credentials (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)