This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 21%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Hi all,
I configured a pc with sql server to be able to access remotely (always internal lan) from the other pc on the network. And works.
I would like to try now to configure to be able to access it remotely (not lan). These two locations have fixed IPs .
Does anyone have a guide on how to create a VPN and be able to configure my connection string of my application to be able to access the pc where there is sql server?
Of course it must be a safe way.
thanks for support
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi AndyK-3935,
Thanks for your reply.
Please check:
Connect to a VPN in Windows 10
Windows 10 VPN technical guide
For more questions about VPN, it is better to open a thread in the tag windows-10-network, so that people there can help you more efficiently.
Best Regards,
Amelia
thanks,
but I don't have a server, I have two PCs..
and one of them has to enter in to read sql server..
tks
Hi AndyK-3935,
Thanks for your reply.
What OS does your PCs and SQL Server use?
Best Regards,
Amelia
Hi Amelia,
2 pc with W10 and SQL SERVER 2012
thanks
Hi AndyK-3935,
Is there a guide to open a VPN safely between two PCs (not in the same building)?
Please check the following articles which might be helpful:
Step by Step How to Install and Configure VPN in Windows Server
Virtual Private Networking (VPN)
Set up L2TP/IPSec VPN on Windows Server
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi,
Thanks for the reply.
Regarding the router, that's one of the things I know how to do.
I go to configuration and do a port forwarding on the affected pc.
But on a practical level, how should everything else be done?
Is there a guide to open a VPN safely between two PCs (not in the same building)?
Thanks
Hi
We miss detail as we will need the router model to be able to give some example if you want to do it the best way possible.
In big it's a site to site vpn you should look at.
That way when the client try to speak to the SQL server, which is on another LAN, the router route correctly the packet fort and back to that site without user intervention.
In example if your LAN where your PC are is 192.168.0.X, you could add the other LAN as 192.168.1.X, which the router will route correctly between the two site.
The public IP you have will make it easier to keep the tunnel up.