Search code examples
sql-server-2014-expressremote-connection

Enable remote connections for SQL Server 2014 Express


I have a SQL Server 2014 Express installed and I want to allow remote connections. I have read this answer, but I can't find the configuration manager installed on the system.

So my question: where can this configuration be done?


Solution

  • Fire up SQL Server Management Studio, and in the Object Explorer, right-click on the server node, choose Properties.

    You should get a dialog something like this (it might look a little bit different in Express, but basically, that's what you should get):

    enter image description here

    Tick the checkbox Allow remote connections to this server