Hi, I’m trying to connect my database to UI Bakery, from the host side, it seems all correct, I did follow all the steps to ensure that my DB is active and reachable, I set up the firewall to accept the IP addresses required from UI Bakery, however I’m getting the error in the screenshot.
I am using Microsoft SQL Server Management Studio 20.2 to host my database.
Hello @Mahad_Mahad,
There must still be an issue with either the Host field, or it can’t be reached from outside your network/machine.
There is also a chance that UI Bakerys MS SQL driver doesn’t allow named SQL server addresses. In that case, you could try accessing via server name or IP address.
But without knowing how your MS SQL server is set up, it’s difficult to tell what the issue is.
I tried also with the IP address, but it still can’t access it.
I followed every step, yet still nothing, I was considering redoing my database on MySQL with the hope that I will not have the same issue.
But for now, I’d like to practice in a realistic manner on UI bakery.
It is possible to create a software using only spreadsheet? including actions and functions? If so i may go for that option.
Hi @Mahad_Mahad
It looks like you are trying to connect to a local database server from the cloud version. If you’d like to host the solution locally, you can try the on-premise solution, or connect to a local database from a cloud using a proxy or an SSH tunnel.
Spreadsheets are also an option, you can refer to this guide.
If you still experience any issues, let us know!
