locked
Will disabling 'remote access' break any app connectivity RRS feed

  • Question

  • I have been recommended by a Security Audit team to disable the remote access option to harden our SQL Server instances.

    sp_configure 'remote access', 0

    As I understance this only prevents legacy code using RPC's and as such should not break any app connectivity. Can someone pls advise if there are any drawbacks to doing this.

    I have referred the discussion in the below thread.

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


    Paul - SQL DBA

    Friday, July 20, 2012 11:34 AM

Answers

  • It should be safe to remove it if you are not using remote servers for any database activity.  It only applies to Remote Server execution. Preferred way is to use linked servers, as this function has been deprecated in 2012.

    Reference: http://msdn.microsoft.com/en-us/library/ms191464.aspx


    Mohit K. Gupta --- MCTS, MCITP, MCC2011
    My Blog OpsVault My MSDN Blog Twitter @SQLCAN

    • Marked as answer by Iric Wen Monday, July 30, 2012 8:18 AM
    Friday, July 20, 2012 5:51 PM