Skip to content

Instantly share code, notes, and snippets.

@zganger

zganger/Jetbrains_localdb.md

Last active April 18, 2017 18:26
Show Gist options
  • Save zganger/eb1c3d74d3f2c10e7adcc3eed54c587f to your computer and use it in GitHub Desktop.
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