Unable to connect azure sql server with any of setted Admin

Lupin Sharma 21

Unable to connect azure sql server with any of setted Admin

Anurag Sharma 17,606 Reputation points

2020-09-14T15:28:32.417+00:00
Hi @Lupin Sharma , Welcome to the Q&A Community.

Would it be possible for you to share the screenshot of error messages and few other details as below:

How are you trying to connect to Azure Sql Database? Through SSMS, Azure Portal or any other tool?

Have you configured the firewall rules from where you are trying to connect?
Anurag Sharma 17,606 Reputation points

2020-10-09T10:59:25.177+00:00

Hi @Lupin Sharma , just wanted to check if you are still facing the issue or is it resolved?
Lupin Sharma 21 Reputation points

2020-10-09T18:04:00.66+00:00

It's resolved.

Accepted answer

Jaguaraci Silva 81 Reputation points

2020-09-25T16:24:58.963+00:00

HI,

1) you should verify on Azure portal if the services and resources are allowed to access the Azure SQL Server instance [yes option].

2) use sqlcmd on Azure cloud shell and connect to database server.

3) set the firewalls rules with client IP address range that you is using with the sp below on sqlcmd prompt:

EXECUTE sp_set_database_firewall_rule N'Allow appServer database level rule', '[From IP Address]', '[To IP Address]';
GO
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer