December 2, 2009 at 10:52 pm
Hi,
can any one help me with the following.
How can u monitor remote connection enabled or disabled on multiple servers.we know remote connection set to '0' or '1' to enable or diable stored in regedit.where does it stores the details in sql server sys tables etc..
And
How does enabling/disabling remote connection show impact on the server.
December 3, 2009 at 12:17 am
Run sp_configure with no parameters or query the sys.configurations catalog view. See BOL for details, permissions, etc.
December 3, 2009 at 12:37 am
Following query can be run to update the remote access.
exec sp_configure 'remote access', '1'
reconfigure
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply