Can't connect to SQL Server database

Questions / Help
,
1

Trying to connect to an SQL Server database using TDS

Everything is fine on development, but stop working on deploy with these errors

23:11:12.649 [error] Tds.Protocol (#PID<0.1965.0>) failed to connect: ** (Tds.Error) tcp connect: nxdomain

23:11:29.200 request_id=GDG3fR224Q2rQPIAAARR [error] ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 10428ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

Any help ?

3

Is the SQL Server instance running inside Fly, or is it supplied by an external provider?

4

Hi

SQL Server database is supplied by an external provider, i really like the fly.io general context, but if can’t resolve this issue, have to look for another alternative to deploy my application

Thanks for your time.

5

I am not troubled if you stay or leave, I am just a Fly customer. However, it’s worth bearing in mind that each cloud provider has its complexities, and you can’t leave them all :zany_face:

Try shelling into your running machine and seeing if you can make a connection to the database server. If the host is a DNS name rather than an IP, see if it resolves. Also, see if it resolves to an IPv6 or an IPv4 address, and if so, which one the db host requires.

Check the port is correct too. Finally, there may be a firewall on the db provider side, and I wonder if you need to add an address or a range to let a connection from Fly succeed.

6

Thank you so much for responding.

I thought you were part of fly.io’s technical support team. I really appreciate the time you took to help me.

In any case, I think I’ll opt for a platform with formal technical support.

Thank you very much.