I cannot connect to Azure SQL Database using SQL authentication. The error is:
Connection to nhspsedhdwprod failed.
[08S01] The TCP/IP connection to the host , port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
I can connect to this database using Azure Data Studio, and from SQL Server Management Studio via a Windows 10 VM on the same machine. I am using the same connection details in all three cases.
I can connect to another Azure SQL Database instance using SQL authentication from DataGrip.
All I have done in all 4 cases is to enter a host, user name, password and database name. I have not altered any of the default settings.
What might the problem be? Thanks