How to connect remotely to a randata base on sql2k5 server
Warning!! This procedure may expose your sql2k5 data to the net..
i have use hamachi network to connect the sql2k5 server to the sql2k5 native
client. ( you can use your own IPaddress setup if you dont like to use hamachi)
Procedure1: SQL2k5 SERVER Side [PC1]
1) enable TCP/IP..go to config tools of sql2k5,config manager,server network
config,select protocols,Rclik TCP/IP,Properties.
2) enable local/remote connections....go to config tools of sql2k5,surface area
config,clik config for services and connection,click remote connection,choose
local and remote connection,select using TCP/IP only.
Select server browser,choose automatic for start up type, clik ok to the prompt
and click start button.
3) make an exception to the fire wall rules....add sqlservr.exe and sqlbrowser.exe
to the firewall exception. this two files is located in your sql2k5 installation
folder. (use custom list in allowing traffic to minimize unwanted entry.)
4) enable file and printer sharing for microsoft network.
5) Un check the block vulnerable windows services of Hamachi.
************************************************************************END
Procedure2: SQL2K5 Native Client Side [PC2]
1) install sql2k5 on pc2...set up windows ODBC using sql native client for
rangame1,ranuser,ranshop and ranlog (Note: there should be no database attached to
sql2k5 installation in PC2, the data base will be taken from PC1 by remote
connection.) use the hamachi ip address of PC1 sql2k5 server to setup odbc of pC2
example: PC1.hamachi.address\SQLEXPRESS
2) enable file and printer sharing for microsoft network.
3) Un check the block vulnerable windows services of Hamachi.
4) Connect to SQL server in PC1...Launch SQL Studio EXpress and login using the
Hamachi IP address of PC1 with this format... PC1.hamachi.address\SQLEXPRESS
If evrything is set up correctly then the database of PC1 will be attached to PC2,
and this can be done even if PC1 and Pc2 are connected by internet only.in effect u
can host 2 different ran server using the same data base.
5) If you want to set up a ran server in PC2 then just use the hamachi ip address
of PC2 for the session,login,agent and field server ini files. u connect to pc2 server to
play the game..pc2 server connect to pc1 to retrieve randata. now we have two ran
server running and sharing the same database that is always syncrhonize.
i need more trial ..ill see if i can use 3 server or more in different location to host
ran with the same data base.
****************************************************************************END
Warning!! This procedure may expose your sql2k5 data to the net..
i have use hamachi network to connect the sql2k5 server to the sql2k5 native
client. ( you can use your own IPaddress setup if you dont like to use hamachi)
Procedure1: SQL2k5 SERVER Side [PC1]
1) enable TCP/IP..go to config tools of sql2k5,config manager,server network
config,select protocols,Rclik TCP/IP,Properties.
2) enable local/remote connections....go to config tools of sql2k5,surface area
config,clik config for services and connection,click remote connection,choose
local and remote connection,select using TCP/IP only.
Select server browser,choose automatic for start up type, clik ok to the prompt
and click start button.
3) make an exception to the fire wall rules....add sqlservr.exe and sqlbrowser.exe
to the firewall exception. this two files is located in your sql2k5 installation
folder. (use custom list in allowing traffic to minimize unwanted entry.)
4) enable file and printer sharing for microsoft network.
5) Un check the block vulnerable windows services of Hamachi.
************************************************************************END
Procedure2: SQL2K5 Native Client Side [PC2]
1) install sql2k5 on pc2...set up windows ODBC using sql native client for
rangame1,ranuser,ranshop and ranlog (Note: there should be no database attached to
sql2k5 installation in PC2, the data base will be taken from PC1 by remote
connection.) use the hamachi ip address of PC1 sql2k5 server to setup odbc of pC2
example: PC1.hamachi.address\SQLEXPRESS
2) enable file and printer sharing for microsoft network.
3) Un check the block vulnerable windows services of Hamachi.
4) Connect to SQL server in PC1...Launch SQL Studio EXpress and login using the
Hamachi IP address of PC1 with this format... PC1.hamachi.address\SQLEXPRESS
If evrything is set up correctly then the database of PC1 will be attached to PC2,
and this can be done even if PC1 and Pc2 are connected by internet only.in effect u
can host 2 different ran server using the same data base.
5) If you want to set up a ran server in PC2 then just use the hamachi ip address
of PC2 for the session,login,agent and field server ini files. u connect to pc2 server to
play the game..pc2 server connect to pc1 to retrieve randata. now we have two ran
server running and sharing the same database that is always syncrhonize.
i need more trial ..ill see if i can use 3 server or more in different location to host
ran with the same data base.
****************************************************************************END
Last edited: