Setting the value of the Remote Access server configuration to 0

The remote access option controls the execution of the local stored procedures on the remote servers or the remote stored procedures on the local server .

To set the value of the remote access option to 0, run this T-SQL command on the IRC and the CM database:

EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'remote access', 0;
RECONFIGURE;
GO
EXECUTE sp_configure 'show advanced options', 0;RECONFIGURE;