Enable remote connections for SQL Server 2014 Expr

2019-08-07 10:39发布

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条回答
狗以群分
2楼-- · 2019-08-07 11:04

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

查看更多
登录 后发表回答