CODEWITHSUNDEEP
sql-servervisual-studio-2017
Mr.Y
Mr.Y

Reputation: 875

Missing sql server configuration manager

I'm using Windows 10 and have just installed Visual Studio 2017 community edition, as u can see, sql server express 2016 localdb is installed:

enter image description here

However, "SQLServerManager13.msc"(or any trace of configuration manager) is nowhere to be found on my machine.

I'm suspecting it's not installed. But SQL server configuration manager is not available to download as a stand-alone application. Please advise as to what should I do?

Thanks

Upvotes: 2

Views: 10380

Answers (1)

Kevin LaBranche
Kevin LaBranche

Reputation: 21078

This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.

It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.

If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.

If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.

Upvotes: 6

Related Questions