Simple setup tutorial for MSSQL LocalDb

Install LocalDB

• Use SQLLocalDB.msi

Install SSMS to manage our DB

• Use "Web PlatForm Installer"

Create LocalDB instance:

SQLLocalDB.exe Create ["Instance Name"]

For example: SQLLocalDB.exe Create "MSSQLLocalDB"

Start LocalDB instance:

SQLLocalDB.exe Start ["Instance Name"]

For example: SQLLocalDB.exe Start "MSSQLLocalDB"

Deploy DB file:

-Deploy by visual studio

-Set Access Permission of APP_DATA folder for Application Pool in IIS

Attach DB(or Attach MDF file) by SSMS:

1. Login\Connect to SQL server

2. Attach MDF

         -Right click "Database" & select Attach...

          -press "Add.." and select you MDF file

Check LocalDB is installed:

by looking for this registry:

Debug LocalDB:

-Check log file

%localappdata%\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB

-Check log file