open server with 2 vps

08/30/2017 23:25 vsroking#1
hey . i want to know to open server on 2 vps..

1 for sql .. 1 for server files only..

how i suppose to do this? :)
08/31/2017 05:07 iGamerFD#2
I think, you have to setup the SQL server to allow remote connections using a static IP and change it in your certification.
08/31/2017 10:16 Andi_xBrainwash#3
Quote:
Originally Posted by vsroking View Post
hey . i want to know to open server on 2 vps..

1 for sql .. 1 for server files only..

how i suppose to do this? :)
setup 1 with SQLServer allow remote connections port 1433 ( add in firewall sqlservr.exe ) add connect IP only from your Server and Done
( dont forget to add in cert SQL IP also from first server and port like so 127.0.0.1,1433