DB connectionm Problem

Christian

Hi guys,
I'm having the problem that db connection won't work in Axon Ivy Designer. I configured the connection in config section, database.yaml. db connection in Visual Studio works. Tried host name, IP,...

Axon Ivy Designer Version: 10.0.13
MS-SQL Version: 2022
Do you have any idea?
Thanks, Christian

Alexander Suter

Christian You may work with the legacy instanceName concept. Read more here:
https://community.axonivy.com/d/290-using-instancename-for-ms-sql-server-jdbc-connection

Christian

Hi Alexander,
Thank you for your fast answer.
I'm not using an instance. So I tried "MSSQLSERVER" as instance name. But no succes right now

Alexander Suter

Christian You need to go to the SQL Server Administration Center to find you which is the correct instanceName.

Christian

I googled a little but MSSQLSERVER seems to be correct. But still no success 😟

Alexander Suter

Christian Maybe a network issue? Firewall?

Christian

Many thanks for the time you spent, Alexander. Finally I found the solution.
When using instanceName the SQL Server Browser has to be started. And when the SQL Server Broser is used ,TCP/IP has to be enambled in SQL Server Network Configuration.
Many thanks
Christian

Alexander Suter

Christian You are welcome. I'm glad to help.