MSSQL localdb

by Nov 3, 2019

How can I connect to SQL server (localdb)\mssqllocaldb with Aqua Data Studio?

Response

Lisa Waugh over 3 years ago
You have to register the server with Aqua Data Studio. Please see the documentation to launch the server registration dialog link. http://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20/page/81/Registering-a-Database-Server

This is what I tried without any success.
In the server name, It also tried:

\mssqllocaldb

\localdb

\(localdb)

\(localdb)\mssqllocaldb

but nothing is working

+1Lisa Waugh over 3 years ago in reply to KissNation
Hello,

My engineer was kind enough to point out that The Microsoft SQL Server JDBC driver does not support localDB. See the comment http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx#10250447

For more information see link provided below.

https://stackoverflow.com/questions/11345746/connecting-to-sql-server-localdb-using-jdbc