open server with 2 vps

[vsroking]

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?

[iGamerFD]

I think, you have to setup the SQL server to allow remote connections using a static IP and change it in your certification.

[Andi_xBrainwash]

Originally Posted by vsroking

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