After starting the Azure SQL Database, Excel cannot connect to it.

Question

I am running a serverless database.
It does not switch from the suspended state to the active state, it cannot connect from the local environment and times out.
If the data source called from Excel is specified in the database, it will fail with a timeout.

The database itself is active because the results are returned when the query is executed directly in "AzurePortal".

If you know the cause and solution of the above connection failure, please reply.

Answer 1

I also made a connection in SSMS and confirmed that the connection failed.

 In addition, the firewall settings are set to allow communication to port 1433.

 In case unconnnected, changing the AzureDB core CPU settings and I'll be able to connect after reconfiguring the database.
Therefore, I supporse that it is not due to improper firewall settings.

 Based on the above, do you have any idea what causes the connection to fail?

Answer 2

Have you tried to connect to Azure SQL Database using another program in your computer like SSMS.

Could you please confirm you have configured Windows Firewall to allow access on port TCP 1433 as explained here? Do the same with any security software on the computer.

Make sure you have created a firewall rule on Azure SQL to allow your public IP address access to Azure SQL as explained here.

Finally make sure you are connecting correctly to Azure SQL as explained here.