Jetbrains Datagrip cannot connect sql server without specify database

Question

i try to use Datagrip as my primary sql server query tools, bit i meet a problem that i can not move forward.

When i setup the project data source, i have to choose a Database, otherwise it will goto the default tempdb, how i can work like sql server management studio, that i can see all database list.

i have tried both jTds and Microsoft drivers, both not works.

or can i choose multi-database? i do not want to create one data source for one database.

if i connect to mysql, it works like expected.

tks

Answer 1

It is possible to connect without specifying the database. Just leave this field blank. After entering other settings (host, port, user, password), go to Schemas tab in Data Source properties and select all the Databases and schemas you want to work with. Then invoke Synchronize action for this Data Source in Database tool window.