May 06 2020 02:53 AM
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 this subscription I've a VM configured which you only get connected to when you have P2S connection enabled
Client makes Point to Site VPN to Azure with AAD Authentication.
When you connect with RDP to this VM with a private IP it is working fine. Connecting from this VM with SSMS to the Logical Server is working fine. Also the connection server.privatelink.databases.windows.net is working.
When customers opens SSMS on his own laptop from home, he cannot make the connection to this Private Endpoint link.
The only way to solve this issue is to allow allow Public Network Access
And to add the home ip-adress of the customer, but this is something we don't want, because then I've to add for everyone his home IP
Is there another way to achieve the situation below. Did I missed something in the documentation.
My End Goal what I want to achieve is. Connect to my sql server through a P2S without adding home ip-address from customers.
I've been reading the following link https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture#connectio... but then still my situation is not working.
Who can help me out. Thank in advance
Sep 16 2020 12:17 AM
hi, have you managed to solve the issue ?
Sep 16 2020 02:26 AM
@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)
Jul 20 2022 07:12 PM
@edkreuk72 THAANKSS!!!!!!!!!!!! I was have the same problem and your comment helped me!!
Sep 25 2022 06:06 AM
Nov 10 2022 10:50 AM - edited Nov 10 2022 10:53 AM
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.
Jan 24 2023 04:14 AM
Feb 28 2023 05:17 AM
@edkreuk72 Have you encountered problem connecting from your visual studio/azure data studio via connection string to the database? i am having a problem connecting to it with point to site VPN enabled but with SSMS i have no problem at all, your solution helped me a lot. Only this connection string is bugging me off a lot right now,
Feb 28 2023 05:35 AM
Feb 28 2023 10:15 AM - edited Feb 28 2023 10:16 AM
Hi Sir, do you mean like this sir?
Server=companydb.privatelink.database.windows.net;Initial Catalog=CompanyDB;User ID=fakeuser @ companydb.privatelink.database.windows.net;Password=faketesttest;TrustServerCertificate=True;
Apr 06 2023 07:42 PM - edited Apr 06 2023 07:42 PM
Apr 06 2023 08:50 PM
Jul 17 2023 06:48 AM