I have multiple SQL databases which are on the same host SQL server. I'm trying to add a new Data Source - entered a connection URL (without specifying a database name), selected needed schemas in the Schema tab but then, when I click on either Apply or OK button, nothing happens.
Can someone give me advice what is wrong here?
If I try to input a connection URL with a concrete database name - Data Source is being successfully created.
Finally, I did it.
I decided to give this a try: