Search code examples
localdbsql-server-2016

How to force LocalDB to use a certain version

On my machine I've installed LocalDb 2012, 2014 and 2016. When I run my application it won't pick the latest version by default.

The used connection string:

Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\ServiceLocal.mdf;Integrated Security=True;Connect Timeout=5

So I use 'MSSQLLocalDB' (instead of v11.0). But it won't run 2016, but 2014 (i.e 12.0.2000.8). It doesn't work to choose v13.0. So what else can I do?

Solution

  • I now understand the concepts. Each instance is really an instance. The connection string targets such an instance, so to get another version you either create a new instance with that version. In the case of MSSqlLocalDb, delete the instance and it will be automatically recreated when queried using the lastest installed version of LocalDb