We have set up a PaaS SQL Server with no public access. It's connected via a Private Endpoint.
The network card has a private IP which we use to connect, and we have internal DNS on Windows Server to provide a suitable "A Record" for the IP.
Problem is, to connect to the database, I have to say TrustServerCertificate=yes in ODBC connection strings and in SSMS.
Would I just need to create an internal certificate for the "A record" I created so I can trust the certificate?
I looked in the Azure portal but was not able to see anything relating to certificates.
Look forward to hearing from you.