2 hosts and a LAN connection between them for CS+MS

[katsumi]

I have 2 vps
with lan connection

so is there a way to connect to the gunz database from the 2nd server and run clan server ?

Here's my error's

my match server log

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[02/15/09 07:13:43] Can't Connect To DBMS

ODBC test

Microsoft SQL Server ODBC Driver Version 03.86.3959

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

ODBC config

Microsoft SQL Server ODBC Driver Version 03.86.3959

Data Source Name: GunzDB
Data Source Description: Gunz
Server: XXXXXX\SQLEXPRESS [ Connected to the 1st VPS which has the original gunzDB]
Database: GunzDB
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

 

[Linear88]

Allow remote connections to your DB.

 

[katsumi]

yes i allowed all and obdc is also connected
now wat i have to do to run match server ?

 

[00niels00]

How to make allow remote?

 

[Demantor]

How to make allow remote?

From "Sql Surface area Configuration". ( restart the service after allowing it )..

yes i allowed all and obdc is also connected
now wat i have to do to run match server ?

Run MatchServer normally.

 

[katsumi]

it shows some error like u get while connecting to ODBC

but i have odbc connected

 

[katsumi]

bump help please

 

[dacharles]

mmmm maybe the odbc is not correctly configured :/ give more info pls

 

[katsumi]

wat do i need to put in the host name ?
i dint put XXX/SQLSERVER
i put only the IP

and i did get tests completed sucessgully

also theres no MSSQ and MSSQLSMMSE in the second server

EDIT :_
Heres wat i get

 

[eele]

You need to portforward 1433 or 1434 Tought so. I don't know exacly what port you need to portforward so do both , and try to connect with your IP and Port. And google is a good friend for using remote SQL connections.

 

[katsumi]

already port forwarded

 

[katsumi]

my match server log

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[02/15/09 07:13:43] Can't Connect To DBMS

ODBC test

Microsoft SQL Server ODBC Driver Version 03.86.3959

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

ODBC config

Microsoft SQL Server ODBC Driver Version 03.86.3959

Data Source Name: GunzDB
Data Source Description: Gunz
Server: XXXXXX\SQLEXPRESS [ Connected to the 1st VPS which has the original gunzDB]
Database: GunzDB
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

 

[katsumi]

helppp please ?