question

AndyK-3935 avatar image
0 Votes"
AndyK-3935 asked AmeliaGu-msft answered

sql server on vpn

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

yagmoth555 avatar image
0 Votes"
yagmoth555 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndyK-3935 avatar image
0 Votes"
AndyK-3935 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndyK-3935 avatar image
0 Votes"
AndyK-3935 answered AndyK-3935 commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi AndyK-3935,
Thanks for your reply.
What OS does your PCs and SQL Server use?
Best Regards,
Amelia

0 Votes 0 ·

Hi Amelia,
2 pc with W10 and SQL SERVER 2012

thanks

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.