20,212 questions
Setting up Windows server 2022 to VPN server
![](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(160, 26%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Safee Ur Rehman
1
Reputation point
I'm trying to set up application and VPN connection on new Win Server 2022 like it's currently set up on old Win Server 2008 and I'm stuck...Basically I'm trying to mirror everything on Win Server 2022.
The guy who did that few years ago for a client is unreachable so I-m stuck with this problem...
Current test and production environment is (Servers are VMs on Azure, and I have access to everything):
- VPN Linux server on Azure (it uses OpenVPN)
- Win server 2008 (on Azure) and MSSQL database are connected to VPN server
- To connect to MSSQL locally or to connect to Win server via RD I have to be connected to VPN over OpenVPN
The things I did:
- Created new win server 2022 on Azure, set up IIS, users and stuff like that
- Made a backup of database and restored it on Win 2022 server
- Deployed application on IIS on new server (it works but it wont connect to database, I suppose because of VPN).
- Application works though when I run frontend and backend locally and database is on new server, also only when I'm connected to VPN
This is the result and problems:
- I can connect to Win 2022 server via RemoteDesktop without connecting to OpenVPN
- I can connect to MSSQL database on new server from my computer only when connected to OpenVPN (why? I mean, It's supposed to be like that but I don't know why and how it did this automatically after i restored db on new server)
- I didn't find anything on VPN server that would tell me it allows access for old Win 2008 server (no IP address, or anything helpful)
- I didn't find anything on old Win 2008 server that would tell me that it can be only accessed through VPN server and that all traffic goes throug it.
- Application works though when I run frontend and backend locally and database is on new server, also only when I'm connected to VPN
All of the servers are in the same resource group in Azure if that matters (VPN, Win server 2008, Win server 2022)
I hope someone can point me in the right direction.
Thanks
Windows for business Windows Server User experience Other
SQL Server Other
14,494 questions
{count} votes
-
JimmySalian-2011 42,486 Reputation points2023-08-27T09:50:32.31+00:00 Hi,
Can you check if the NSG rules are allowed for the connection to the backend server ie: Win2022 server and Windows Firewall ports are open? Also check the deployment guide and this can assist you in setting up the VPN on Windows server 2022. Remote Access Server is the role and this is base configuration for VPN check this article - https://learn.microsoft.com/en-us/windows-server/remote/remote-access/get-started-install-ras-as-vpn?tabs=powershell
==
Please accept as answer and do a Thumbs-up to upvote this response if you are satisfied with the community help. Your upvote will be beneficial for the community users facing similar issues.
-
GitaraniSharma-MSFT 50,021 Reputation points Microsoft Employee Moderator2023-08-29T08:31:41.26+00:00 Hello @Safee Ur Rehman ,
Welcome to Microsoft Q&A Platform. Thank you for reaching out & hope you are doing well.
I'm not sure I understand the question and your exact requirement here. Could you please provide some more details?
Could you please share your network diagram, if possible?
So far, I understood that the below is your setup:
- VPN Linux server on Azure (it uses OpenVPN).
- Win server 2008 (on Azure) and MSSQL database are connected to VPN server.
- You created a new Win server 2022 on Azure, set up IIS, and made a backup of database and restored it on this server.
- VPN, Win server 2008, Win server 2022 are deployed in Azure.
But you mentioned "Application works though when I run frontend and backend locally and database is on new server" - when you say database is on new server, is it on the same Win server 2022 on Azure?
Are all the VMs in the same Virtual network?
If yes, how are you connecting/doing RDP into the Win server 2022? Using its Public IP?
And how are you connecting to the MSSQL database? Are you using SQL Server Management Studio? And when you say MSSQL Database, what is it exactly? Is it an Azure SQL Database or a SQL Server on a Windows virtual machine?
From your post, I can see that you are able to RDP into the new Win 2022 server, are able to connect to MSSQL database and the application also works for you.
So, what is the issue that you are facing here?
Regards,
Gita
-
GitaraniSharma-MSFT 50,021 Reputation points Microsoft Employee Moderator
2023-08-30T14:38:16.3933333+00:00 @Safee Ur Rehman , could you please provide an update on this post and share the requested details for further discussion on the issue?
Sign in to comment
Sign in to answer