Connecting to SQL Server LocalDB using JDBC

by

Yes, it is possible.

The connection string for a LocalDB instance using jTDS looks like this:

jdbc:jtds:sqlserver://./DatabaseName;instance=LOCALDB#88893A09;namedPipe=true

This works as of jTDS 1.3.2. You can download a release here:

https://github.com/milesibastos/jTDS/releases/download/v1.3.2/jtds-1.3.2-dist.zip

To find the named pipe for your desired LocalDB, run

SqlLocalDb info NameOfTheLocalDBInstance

which will give you something like np:\\.\pipe\LOCALDB#88893A09\tsql\query

It’s probably best to connect with a specific username/password, so create a login and user for your database in that LocalDB instance as well (if you haven’t already):

sqlcmd -S np:\\.\pipe\LOCALDB#88893A09\tsql\query

CREATE LOGIN dbuser WITH PASSWORD = 'dbpassword'
GO
CREATE USER dbuser
GO
ALTER AUTHORIZATION ON DATABASE::DatabaseName TO dbuser
GO

More Related Contents:

  1. LocalDB deployment on client PC
  2. SqlServer: Login failed for user
  3. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  4. Sql Server – connect with windows authentication
  5. How to prevent SQL Server LocalDB auto shutdown?
  6. displaying multiple records by using resultset
  7. SQL Server (localdb)\v11.0 explained
  8. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  9. SQL server query to output the data shown below
  10. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  11. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  12. JDBC connection failed, error: TCP/IP connection to host failed
  13. How to use a variable for the database name in T-SQL?
  14. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  15. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  16. Create a view with ORDER BY clause
  17. INSERT INTO vs SELECT INTO
  18. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  19. How to remove accents and all chars a..z in sql-server?
  20. RODBC odbcDriverConnect() Connection Error
  21. Calling an API from SQL Server stored procedure
  22. SSIS Excel Import Forcing Incorrect Column Type
  23. Is there a way to not use square brackets in SQL Server?
  24. Use of Begin / End Blocks and the Go keyword in SQL Server?
  25. How do you set autocommit in an SQL Server session?
  26. Avg of float inconsistency
  27. Milliseconds wrong when converting from XML to SQL Server datetime
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment