Hello,
Previously, in v24.4, I was able to configure a data source for SQL Server. Now, in v25.1, I can't. Any suggestions?
Here the error:
Thanks in advanced!
Allan
Discussion posts and replies are publicly visible
Do you think it is a good idea to share server URL, database name und the account name of the admin on the public internet?
It's a bad idea, but we couldn't find any help from support, nor could we find specific documentation for this error. It's part of the desperation.
Did you try to contact communityedition@appian.com?
Yes, and they told me that they cannot help for specific projects.
Well, then it is trail&error.
Did you enable SSL on the server side?
Yes of course, the DB is located in Azure.
In your screenshot, I see that you did not follow the hint regarding SSL.
Yes, here a new screenshot with the properties:
OK. Just wanted to be sure on this. Without any details on the error, it is hard to say what is wrong. Do you have access to the logs on the server side?
Hello Stefan, I've already asked the administrator to review the logs in Azure, but in the meantime I'd like to ask if it's possible to make this connection to an on-premise server: jdbc:sqlserver://192.168.15.202:1433;databaseName=DemoDB, is it possible in the cloud version?
I also checked the environment settings and I think the drivers are missing, is that correct?
Thanks
SQL server drivers are included by default, same as any of the other officially supported DB systems.
I think, from the Appian perspective, this should just work. But, there are so many things, firewall, network filters, etc., that can go wrong, that it is impossible to tell from the outside.
The other day, I connected an on-premise Appian kubernetes setup to an Azure hosted PostgreSQL. Just works.
Thanks Stefan. I keep trying....