How to install localdb separately?

Question

If I need to work with localdb , should we install it separately?

I have installed SQL Server 2008 R2 Management Studio, installed SQL Server 2012, installed .net 4.0.2 update. But I still do not see localdb on the PC.

Answer 1

From MSDN

The main method of installing LocalDB is to use the SqlLocalDB.msi program. LocalDB is an option when installing any SQL Server 2012 Express SKU. Select LocalDB in the page feature selection during SQL Server Express installation . There can only be one installation of LocalDB binaries for each core SQL Server Version Database Engine. The processes of several database components can be and all will use the same binaries. SQL Server Database Engine instance started because LocalDB has the same limitations as SQL Server Express

Or you can download standalone SqlLocalDB.msi from the list of available downloads on the SQL Express page to download

To find the localdb instance on the PC, try connecting to (localdb)\Projects

Answer 2

If you downloaded SqlLocalDB.msi , you can use a silent installation.

 msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES 

Remember the administrative rights to install!

Answer 3

Note for people who have received SQL 2016. In fact, you need to select Express during the installation of SQL 2016 to select the localDB option. If you choose something else (for example, the version for developers), "localDB" will not be displayed as an option in the "General Functions" section

Developer edition

SQL Express

Answer 4

The question is old, but I think it's always nice to know:

How to check if LocalDB is installed, and if you have one, then which version:

• Open command line
• Enter "SqlLocalDB info" (without quotes)
• Press 'Enter' and you will see something like this ,

which means you have the version of "MSSQLLocalDB" installed.

There are several versions:

• v11.0
• v12.0
• v13.0 and
• MSSQLLocalDB