Enable or activate xp_cmdshell

--Step 1: Switch to ‘master’ Database
USE master
GO

--Step 2: Enable the advanced options of the SQL Server
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE

--Step 3: Enable xp_cmdshell
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE

----Step 4: Assign the proxy account for xp_cmdshell – the proxy account is used to execute the programs
--EXEC master.dbo.sp_xp_cmdshell_proxy_account ‘Domain\User’, ‘password’
--
----Step 5: Grant the right to xp_cmdshell for SQL User Login
--GRANT EXECUTE ON master.dbo.xp_cmdshell TO [SQL_USER]