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)
Herald_Go_Sison
Feb 28, 2023Copper Contributor
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,
- MayankGaur1985Feb 28, 2023Copper ContributorIn the connection string also you have to use privatelink in server name and TrustCertificate = true. Make sure that you are connected to correct VPN
- Herald_Go_SisonFeb 28, 2023Copper Contributor
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;