Product:
SQL AZURE server
Issue:
Can not connect to AZURE SQL server in SSMS.
Error like:
the server was not found – msg 110001
Solution:
You need a new DNS record to point to the server-name in azure (db.database.windows.net).
There are more than one DNS zone where you need to update DNS records for your resource (privatelink.database.windows.net).
If you get a different error that, the server is connected but refuse to allow your user, then try with some other login method like:
Azure Active Directory – integrated
Azure Active Directory with MFA
SQL Server authentication (native login)
The allowed login method change with from where you try to connect and how firewall/DNS is setup.
More information:
https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-dnsÂ
https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql