1

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?

Community
  • 1
  • 1
etalon11
  • 895
  • 2
  • 13
  • 36

1 Answers1

2

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459