Microsoft SQL LocalDB is a minimal version of Microsoft SQL Server,meant to provide a fully fledged SQL database without the pain of installing and configure an SQL Server. The installer of LocalDB is as straightforward as it can get, and the setup is truly minimal. This is what you need to get Tabbles (or any other application running on Microsoft SQL Server) to run LocalDB:
- Install the right version for you: if you have a 64bit OS, you’ll need to install a 64bit version (such as LocalDB 2016), as a 32bit installer (supported up to version 2014) won’t work on a 64bit machine – and viceversa. Also, do not try fiddle with msiexec and install LocalDB somewhere else: LocalDB seems to only work if installed in the default path. Therefore
- After the installation is successfully completed, initialize LocalDB via those 3 commands sent via cmd.exe (or “Run”):
"C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" create LocalDBApp1
"C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" start LocalDBApp1
"C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" info LocalDBApp1
The first line creates an instance of LocalDb, and the second line starts the Instance. You can use the third to check if the process worked: if in the output you see “State: Started” then you’re good to go. More info are on the Microsoft LocalDB reference page. Note: if you’re using Microsoft SQL 2014 LocalDB, you will need to change the “130” in the path with a “120” as that number represents the version of SQL Server. Also, don’t try to fiddle with the name of the instance, leave the experiments for later and use LocalDBApp1 as mentioned above.
- Create the database from the Tabbles GUI, using Windows Authentication and the (localdb)\MSSQLLocalDB as server:
After creating the database, you’ll need to follow the wizard to create a Superuser and then Tabbles will login automatically.
If you have issues, please let us at firstname.lastname@example.org.
Maurizio and Andrea