-
Notifications
You must be signed in to change notification settings - Fork 10
Configure xp_cmdshell Proxy Account
| Previous Configure SA Account | Manual Configuration | Configure Database Owner Account Next |
|---|
FineBuild can configure the xp_cmdshell Proxy Account.
The xp_cmdshell Proxy Account is not normally needed. However, if there is a requirement for users without Sysadmin authority to use xp_cmdshell then a Proxy Account must be created.
The xp_cmdshell Proxy Account configuration relates to Process Id 5CE and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupCmdshell: | No | No | N/A |
| SQL2017 | /SetupCmdshell: | No | No | N/A |
| SQL2016 | /SetupCmdshell: | No | No | N/A |
| SQL2014 | /SetupCmdshell: | No | No | N/A |
| SQL2012 | /SetupCmdshell: | No | No | N/A |
| SQL2008R2 | /SetupCmdshell: | No | No | N/A |
| SQL2008 | /SetupCmdshell: | No | No | N/A |
| SQL2005 | /SetupCmdshell: | No | No | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /ConfigCmdshell: can also be used.
FineBuild also uses the following parameters to help Configure xp_cmdshell Proxy Account:
| Parameter | Default Value | Description |
|---|---|---|
| /CmdShellAccount: | none | Name of the xp_cmdshell Proxy Account |
| /CmdShellPassword: | none | Password for the xp_cmdshell Proxy Account |
FineBuild will not by default configure the xp_cmdshell Proxy Account, because most sites do not need this functionality.
If you want FineBuild to configure the xp_cmdshell Proxy Account, then you must add the following parameter when you run FineBuild, and also supply the CmdShellAccount and CmdShellPassword parameters:
/SetupCmdshell:Yes
The following steps show what you would have to do for manual xp_cmdshell Proxy Account configuration. FineBuild does all of this work for you automatically.
To configure the XP_Cmdshell Proxy Account, follow the procedure given in xp_cmdshell Proxy Account.
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure SA Account | Top | Configure Database Owner Account Next |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP