before there a "TEST" button there. but now it is already gone.
I am asking this. aside from option putting the Pre-SQL.
I've just installed version 2022.1 and I'm having the same issue. I can click OK to connect to the server, but how do I set a default database?
Hi @Christina_H
I think that we can't set the default database. But If you connect it, the Designer shows all database.
Hi @Christina_H
the only way I have been able to set the default database is to setup the new connection without a database then update the SystemAlias.xml or UserAlias.xml file with the database name. Not great for users who are not used to working with xml files directly but they are quite straight forward files.
It seems that the published workaround is to use a DSN Connection instead which is less than ideal.
thanks
Daryl