Forum Discussion
Connect to Azure SQL database with Point to Site Connection and Private Link
Hallo, I'd like to try to get the following done only somehow it doesn't seem to work I have configured a Logical Server within Azure with VNet and Private Link enabled Within th...
Great to hear that Hector
I found an easier way to Connect to SQL DB with P2S.
After you have Created your VPN Gateway and Private Endpoint Connection for SQL DB, on the client machine in SSM login Window you will need to Enter at the servername the IP Address of your SQL Endpoint Connection and the user name should be entered like this: username @ yourdatabasename.privatelink.database.windows.net
In Options Enable Trust Server Certificate and Encrypt Connection also Enabled. Afterwards you will have access to the DB directly from your local Client via P2S Connection.
I hope this helps!
Cheers Alex.
- Hi AlexBolo this solution works well for Sql Server Authentication. How to make it work with Active Directory Authentication. Any help will be apricated
