SQL Server "Allow connection to this server" configuration

In the properties of SQL Server, we can see an option to ' Allow remote connections to this server ' (in English, remote access) with the default value of 1, which means that this option is turned on.

But this parameter is not literally shown, control the remote connection switch, in fact this parameter and whether can connect to the database has no relationship, in the future version will be discarded, its function will be completely replaced by the linked server.

Website Explanation:

The remote access option controls the execution of a stored procedure from a local or remote server that is running an instance of SQL Server. The default value for this option is 1. This authorizes the execution of local stored procedures from a remote server or the execution of remote stored procedures from the local server. set this option to 0 if you want to prevent local stored procedures from executing on the remote server or when remote stored procedures are executing on the local server.

The next version of Microsoft SQL Server will remove the feature. do not use this feature in new development work, and modify applications that are currently using the feature as soon as possible. use sp_addlinkedserverinstead.

SQL Server "Allow connection to this server" configuration