To allow remote access to or from a server, including Backup Server, set allow remote access to 1:
sp_configure "allow remote access", 1
To disallow remote access at any time, set allow remote access to 0:
sp_configure "allow remote access", 0
Only a System Security Officer can set the allow remote access parameter.
You cannot perform database or transaction log dumps
while the allow remote access parameter is set
to 0.
