Forum Discussion
Connect to Azure SQL database with Point to Site Connection and Private Link
giladdan, yes we got this finally working. By adding the ip-adress and names from the private endpoint to the local hostfile of my laptop(or co workers)
edkreuk72 THAANKSS!!!!!!!!!!!! I was have the same problem and your comment helped me!!
- edkreuk72Sep 25, 2022MVPGreat to hear that Hector
- AlexBoloNov 10, 2022Copper Contributor
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.