How to connect to localdb in Rider?

Question

Trying to connect to localdb using Database tab in Rider. I adding SqlServer jTds and Rider shows this error

Connection to SunEngineDb1 failed. [08S01] Network error IOException: .\pipe\MSSQL$LOCALDB#E65C6709\sql\query (Can not find the specified file)

What am I missing, and how it can be solved?

It is ASP.NET Core 2.0 project with localdb database on development. If I run it it works perfectly including database connect.

Possible duplicate of https://stackoverflow.com/questions/11345746/connecting-to-sql-server-localdb-using-jdbc — ErikEJ, Dec 07 '17 at 15:54
Hello! Did you connect according to the tutorial? https://blog.jetbrains.com/datagrip/2016/10/07/connecting-datagrip-to-sql-server-express-localdb/ — moscas, Dec 07 '17 at 16:19
@moscas Hallow! Yes, tried this, and tried also to extract pipename from `SqlLocalDB.exe info`. But not 100% equal, i use Windows Domain Autentification. — Dmitrij Polyanin, Dec 07 '17 at 16:30

score 2 · Accepted Answer · answered Dec 13 '17 at 06:44

Well, finally we discovered the problem. It is the mistake in the driver we provide. To have this issue fixed urgently, delete the file \config\jdbc-drivers\jdbc-drivers.xml and restart the IDE. Then, please, refresh your driver to 1.3.1.1 or just put [latest] there.

How to connect to localdb in Rider?

1 Answers1