PSA: How to set up a LocalDB data source in Rider

How to setup Rider to use a (localdb) data source was not clear to me (and Rider IDE currently returns 404 for the help concerning database connections) so for others in the same situation, this is what I did in order to get access to my (localdb) in Rider.

From the Database tool window:

  1. Add a new data source using the 'SQL Server (jTds)' driver (not the 'SQL Server (Microsoft)' driver)
  2. Using the drop-down menu to the right of the URL select 'LocalDB'
  3. Enter your Database name
  4. Select an instance from the Instance drop-down menu
  5. Enter your Username and Password (or select to use Windows domain authentication)



Please sign in to leave a comment.