Cannot connect Budibase to MS SQL Server

[Emokores256]

I have been trying to connect Budibase to SQL Server but all in vain. I have enabled the SQL Server Browser and SQL Server (SQLEXPRESS), however, I have failed to enable the SQL Server Agent (SQLEXPRESS). I have restarted the service and database instance several times. I keep getting the error

Error creating datasource: Unable to connect: Failed to connect to localhost\SQLEXPRESS in 15000ms.

I have tried enabling and disabling the Encrypt option too but I get the same result.

I am using SQL Authentication to log in. On my system, I login successfully. I have also enabled the TCP/IP for SQLEXPRESS. Unfortunately, nothing works for me. Are there any other suggestions or ways I can get these two to connect?

[andz-bb]

hey @Emokores256

I converted this one to a discussion as we don't have a widespread bug around connecting to MS SQL server.

Are you running your Budibase instance inside docker-compose? You may need to use something like host.docker.internal\\SQLEXPRESS for this so that it can access your machine's local IP rather than the docker VM's.

Could you also check your firewall settings to see if the connection from docker could be getting blocked by it? Thanks

[Emokores256]

Thank you @andz-bb for your response. I am running Budibase from the browser. I have never used a docker container before.