SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums SQL Server 2008 Security (SS2K8) Access Denied to backup but xp_cmdshell no Acess Denied RE: Access Denied to backup but xp_cmdshell no Acess Denied

  • Welsh Corgi

    SSC Guru

    Points: 116520

    More actions

    February 18, 2010 at 7:05 pm

    #1121526

    You should disable the xp_cmdshell unless absolutely needed:

    http://www.sqlservercentral.com/Forums/Topic828767-386-1.aspx

    http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=123821

    http://blogs.msdn.com/sqlsecurity/archive/2008/01/10/xp-cmdshell.aspx

    Respectfully,

    Welsh

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo