Vidhya Sagar – Blog One Stop for SQL Server related Queries

Enable \ Disable Remote connections Via DOS or T-SQL

I've seen in forums seeking to enable \ disable Remote connections via DOS prompt \ T-SQL. I've searched google for this topic and didn't get any article on this topic, so i decided to write a procedure to change Remote connections via T-SQL so that this can be called from DOS.

Enabling \ Disabling Remote connections are nothing but changing registry values in "HKLM\Software\Microsoft\Microsoft SQL Server\MSSQLSERVER\Supersocketnetlib\Protocol", with respect to the values in the registry it enables are disables the protocol for Remote connection.