Forum Discussion
edkreuk72
May 06, 2020MVP
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...
edkreuk72
Sep 16, 2020MVP
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)
Hector Muñoz
Jul 21, 2022Copper Contributor
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.