Your problems are:
1.Bad server + script files
2.Defender firewall ports need open TCP/UDP
You can find which ports you need to open with these 2 files easily:
ndregEditor.exe just open your NDreg and see login and status ports which are 50001 and 48300 TCP
Server.env files located inside your C:/9Dragons/env.ini OR server.env edit with notepad
Add all those ports you see there to firewall, use chatgpt to help you do it easily !
3.Server.env FILES must have your public IP address + port ( 80 ) NOT THE OLD IP ADRESSES AND PORTS THAT PREVIOUS OWNER HAD !
4. Apache (c:/httpd/conf/http.conf) Must point towards your public IP and port ( 80 )
(I use apache 2.0 and its the best JUST for HOSTING server gameguard/patch files [not good for website] )
5. C:/Scripts/svrctl/log_server shortcut.exe -> right click -> properties -> in Target box copy this: C:\9Dragons\LogSVR\LOG_SVR_us.exe idc0 192.169.0.1 <---- replace with your ip and press ok .
6. Your SQL Client protocols should indicate your public VPS IP and enable TCP/IP inside manager SQL
What I can help you with would be giving you this small idea but with very BIG rewards:
Buy chatgpt premium, thats how I fixed all server errors, that mfker helpful if your brain not big enough haha
Good luck fellow developer , READ very well what i said here because not many people will take their time to teach you how to open online server, those are literally the only problems you face from 1 to 6 !
If i just make tutorial for you from scratch you will never learn how to edit files or open sv on your own (which ports u need etc) , that is why it is a crucial process to understand before you become a server owner
If you know how to read, i just gave you a basic minimalist guide on how to open sv on vps
