Azure SQL Database connection error with SQL authentication

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

1 comment
Comment actions Permalink

Could you email me your IDE logs to ?


Please sign in to leave a comment.