2/7/2018 11:09:46 AM / By: Administrator
When you try to connect to an instance of Microsoft SQL Server 2012 Express from a remote computer, you might receive an error message.
Named SQL instances listen on dynamic ports. This is the function of the Sql Server Browser Service to inform the clients of the actual port. The Sql Browser listens on UDP 1434 and answers all client request with the port number the current instance is using. Sql Server Browser service is required for both TCP and named pipes protocols. SQL Server Browser is used by clients transparently and there is no need for special configuration.
To configure SQL Server 2012 Express to allow remote connections, you must complete these steps:
If you want to use GPO to configure SQL server Standard or Enterprise to accept remote connections see my new post: How to use GPO to allow SQL 2012 accept remote connections
1. Open SQL Management Studio and right-click server name in the left pane and select Properties
2/7/2018 11:09:46 AM
1/1/0001 12:00:00 AM