zganger/Jetbrains_localdb.md

Last active April 18, 2017 18:26

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/zganger/eb1c3d74d3f2c10e7adcc3eed54c587f.js"></script>
Save zganger/eb1c3d74d3f2c10e7adcc3eed54c587f to your computer and use it in GitHub Desktop.

Download ZIP

Using JetBrains tools with SQL Server LocalDB

Raw

Jetbrains_localdb.md

How to set up a connection to LocalDb using JetBrains IDEs

Microsoft does not provide suport for LocalDb using the Microsoft driver. Use jTds.

Add a Sql Server (jTds) or LocalDb driver
Select LocalDb next to URL type
Find LocalDb executable at C:\Program Files\Microsoft Sql Server\<version>\Tools\Binn\SqlLocalDB.exe
Enter the name of the database
Select the instance your db runs on
Use windows domain auth (You don't need to set it up this way, but it is the easiest to do so)
Under Advanced tab, add your machine's hostname under the DOMAIN field
Test Connection & apply

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment