Brand new Azure account. Created a vnet (10.25.0.0/16) and an SQL DB/Server (no AD, just an admin login: sadmin/***)
Using SSMS, I can connect the SQL server through its public endpoint (prompted for Azure login by SSMS. FW rule added on-the-fly) ✔
Now, I'm trying to connect through a private endpoint:
Created a VNet gateway and OpenVPN access: I am now connected to my vnet using OpenVPN ✔
Connected the SQL server to the VNet using a private endpoint (10.25.0.4)
Access to server through Azure resources enabled. No specific FW rules.
Using SSMS (on my computer) and SQL Server authentication (sadmin/***), I can connect the SQL server but login fails:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.) (Microsoft SQL Server, Error: -2146893022)
Also, telnet 10.25.0.4 1433 connects, which confirms the message above about successful connection.
Same error message even if I use a wrong password or username.
Note: I reset the sadmin password (through the portal) to make sure I use the correct password.
What's wrong? Note: I am neither a SQL server specialist nor a DBA. I may miss the obvious.