question

MaruthiKarthik-1265 avatar image
0 Votes"
MaruthiKarthik-1265 asked Sirlupinwatson answered

Unable to connect to Azure Database due to network settings issue

Unable to connect to Azure SQL via portal, stating the issue as below error:

A connection to the server 'XXXX.database.windows.net' could not be established. This might indicate an issue with your local firewall configuration or your network proxy settings.

I tried the below:

Opened ports 1433, 443
Added Client IP in the firewall settings and the IP is whitelisted for access


Still the issue exists

azure-active-directory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ManuPhilip avatar image
0 Votes"
ManuPhilip answered

Hello @MaruthiKarthik,

Check "SQL Server Configuration Manager" for "SQL Server Network Configuration". Under "Protocols for Name", make sure that "TCP/IP" is enabled. Select "IP Addresses" Tab -and- Go to the last entry "IP All". Enter "TCP Port" 1433.
Now Restart "SQL Server .Name." from windows services. Check if it resolves the issue


Please mark as "Accept the answer" if the above steps helps you. Others with similar issues can also follow the solution as per your suggestion

Regards,

Manu

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sirlupinwatson avatar image
0 Votes"
Sirlupinwatson answered

Hi @MaruthiKarthik-1265

Have you got a connector as a redirect that have policy to Inbound traffic, and outbound traffic, if your port are forwarded, open, whitelisted, i would do a
connectivity test, see what kind of statistics results output from there and pursue investigations.

Would you mind giving a configuration of your current system, but also what you are trying to do. Right now the interpretation of this work order is
incomplete. Actual Configuration and Action that lead to your problem, will clarify and you get more chance to resolve your demands.

Sometimes providing config, spec and details will be useless, but here we could take them. Please, on your futur post, make sure to add those details.

I hope it help you.

Regards, Armand B.



"If the answer did help you, Upvote it, other user will access those informations swiftly."

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.