Enable remote connections for SQL Server 2014 Expr

2019-08-07 11:03发布

问题:

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?

回答1:

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):

Tick the checkbox Allow remote connections to this server