Today, I worked on a service request that is very odd. Our customer is using PHP with a very old driver and trying to connect to the public endpoint of Manage Instance they got several errors like: [Microsoft][SQL Native Client][SQL Server]Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
The first point that I found is that the public endpoint of a Azure SQL Managed Instance is using 5 parts to identify the FQDN, InstanceName.Public.VirtualCluster.database.windows.net, for the error message all points to that in this driver version is validating the server name.
So, for any specific reason, our customer needs to use the public endpoint instead of the normal FQDN: InstanceName.VirtualCluster.database.windows.net.
So, we know that the connection needs to be validated with our certificates and domain database.windows.net, my suggestion, meanwhile our customer tries to update the driver was:
Enjoy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.