How to install localdb separately?

sql sql-server localdb
user1687824 picture user1687824 · Apr 27, 2014 · Viewed 89.9k times · Source

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

I have SQL Server 2008 R2 Management Studio installed, SQL Server 2012 installed, .net 4.0.2 update installed. But I don't see localdb in the PC yet.

Answer

Andrey Morozov picture Andrey Morozov · Apr 27, 2014

From MSDN

The primary method of installing LocalDB is by using the SqlLocalDB.msi program. LocalDB is an option when installing any SKU of SQL Server 2012 Express. Select LocalDB on the Feature Selection page during installation of SQL Server Express. There can be only one installation of the LocalDB binary files for each major SQL Server Database Engine version. Multiple Database Engine processes can be started and will all use the same binaries. An instance of the SQL Server Database Engine started as the LocalDB has the same limitations as SQL Server Express

enter image description here

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

enter image description here

To locate localdb instance on your PC simply try to connect to (localdb)\Projects

enter image description here

Related questions

Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'

I am getting an error, While I am trying to connect (LocalDB)\MSSQLLocalDB through SQL Server management studio. I also tried to login with default database as master the error is same. Here is the Server details.

Read More
How do I connect to an older sql database using LocalDb in VS 2012?

I am trying to construct a connection string to a 2008 SQL Express database file in VS 2012. I am getting an error dialog: This database file is not compatible with the current instance of SQL Server. To resolve this issue, you …

Read More
How do I copy SQL Server 2012 database to localdb instance?

I'm looking to copy a SQL Server 2012 Standard database to my localdb instance. I've tried the wizard which complains that localdb isn't a SQL Server 2005 or later express instance. I also did a backup/restore but upon the restore in …

Read More