Enable the xp_cmdshell and remote access

  1. In SQL Server Management Studio, right-click the registered server and select Facets.
  2. In the Facets list, select Surface Area Configuration.
  3. Under Facet properties, set the XPCmdShellEnabled property to TRUE.
  4. In the Facet list, select Server Configuration.
  5. Under Facet properties, set the RemoteAccessEnabled property to TRUE.
  6. From the Start menu, select Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager .
  7. Right-click your database and select Restart to apply the changes.