[Share] Connecting Remotely To RanData on SQL2K5

[rej50n]

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

 

[sunboy]

it would be much better if you included some screenies:thumbsup:

 

[rej50n]

it would be much better if you included some screenies:thumbsup:

sorry no screenies available, ill just add more info below..hope this help.



To enable SQL Server Express to accept remote connections we need to perform
the following steps:

STEP 1: Enabling TCP/IP

First we must tell SQL Server Express to listen on TCP/IP, to do this
perform the following steps:

1. Launch the SQL Server Configuration Manager from the "Microsoft SQL
Server 2005 CTP" Program menu
2. Click on the "Protocols for SQLEXPRESS" node,
3. Right click on "TCP/IP" in the list of Protocols and choose, "Enable"

STEP 2: To Browse or not to Browse

Next, we have to determine if we want the SQL Browser service to be running
or not. The benefit of having this service run is that users connecting
remotely do not have to specify the port in the connection string. Note: It
is a security best practice to not run the SQLBrowser service as it reduces
the attack surface area by eliminating the need to listen on an udp port.

OPTION A: If you want to always specify a TCP port when connecting (Not
using SQL Browser service) perform the following steps else skip these
steps:

1. Launch the SQL Server Configuration Manager from the "Microsoft SQL
Server 2005 CTP" Program menu

2. Click on the "Protocols for SQLEXPRESS" node

3. Click on the "TCP/IP" child node

4. You will notice an entry on the right panel for "IPAll", right click
on this and select, "Properties"

5. Clear out the value for "TCP Dynamic Ports"

6. Give a TcpPort number to use when making remote connections, for
purposes of this example lets choose, "2301"


At this point you should restart the SQL Server Express service. At this
point you will be able to connect remotely to SQL Express. A way I like to
check the connection is my using SQLCMD from a remote machine and connecting
like this:

SQLCMD -E -S YourServer\SQLEXPRESS,2301

The "," in the server name tells SQCMD it's a port.

So you've tried this and still get an error. Take a look at Step 3, this
should address the remaining issue.

OPTION B: If you want to use SQL Browser service perform these steps:

Note:
You will need to make this registry key change if you are using the April
CTP or earlier versions:

To enable sqlbrowser service to listen on the port 1434, the following
registry key must be set to 1

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL
Browser\Ssrplistener

Next, restart the sqlbrowser service.

1. Start the SQL Browser Service

STEP 3: Firewall..?

At this point you should be able to remotely connect. If you still
can't chances are you have a firewall configured on the computer where SQL
Express is running. The instructions below are for Windows XP SP2's
firewall settings.

To enable the firewall to allow SQL Server Express traffic:

1. Launch the Windows Firewall configuration tool from the control
panel.

2. Click the Exceptions Tab

3. Click the "Add Programs." button and select "sqlservr.exe" from the
location where you install SQL Server Express


You should be able to remotely connect. Note, you can get more restrictive
by just specifying the port number that will be allowed (used best when
configured with Option A).

Note: If you chose to use the SQL Browser service, you must also add
sqlbrowser service executable to the exception list as it listens on udp
port 1434.

 

[smarkies]

If this guide is working 100% then I will add this to sticky section.

 

[nimrad]

wow nice guide!!!!!!! now other gm can connect to the main server even if they are away from the server and can use gm char edit and we can see inside the sql database of the server. this guide works 100% in me. now i can connect to the main server. i think this is the first step to make more server in just 1 database like in ran ph. u can enter in differrent server like strife or havoc in just same account.btw im a gm in rej50n`s server. we test this guide and 100% working.

credit to rej50n tnx man!!!!!!!!!

 

[Jolin88]

that doesn't work to remote over WAN
to remote over WAN you need SQL enterprise edition cos it even says in the descripiton of SQL express that wan remote is disabled

 

[rej50n]

that doesn't work to remote over WAN
to remote over WAN you need SQL enterprise edition cos it even says in the descripiton of SQL express that wan remote is disabled

it is working fine with my server.. now i can access my sql2k5 server over the internet..i only use hamachi coz i dont have a fix ip address..dynamic ip is also ok but its hassle to change ip address evrytime i .. . Those who want to try can access my test SQL2K5 server over the internet. Now im testing a 3 ranserver setup accessing a single sql2k5 server..ill post it later when im satiisfied with the result.

 

[manmig]

nice guide. but really risky. very easy to launch an attack.

 

[rej50n]

nice guide. but really risky. very easy to launch an attack.

we may take some precaution to lessen the attack... we can change the default login name and password..and we can create a custom list of allowed ip address that can access the server.

 

[bl4kjak]

its working...but it need a good pc and a real fast connection... i dont hav problem in lan mode where the ping is 1ms only...but in wan mode i think the ping should not be more than 80ms....mychainfo loaded in less than 30 secs on 2.5mbps connection. tnx.

 

[alsyundawy]

wiw nice tutz sir ..... :thumbsup:

 

[NetXP3]

i hope this guide go to the sticky thread.

 

[R.U.S.H]

i agree....

that doesn't work to remote over WAN
to remote over WAN you need SQL enterprise edition cos it even says in the descripiton of SQL express that wan remote is disabled

..and disagree with this

it is working fine with my server.. now i can access my sql2k5 server over the internet..i only use hamachi coz i dont have a fix ip address..dynamic ip is also ok but its hassle to change ip address evrytime i .. . Those who want to try can access my test SQL2K5 server over the internet. Now im testing a 3 ranserver setup accessing a single sql2k5 server..ill post it later when im satiisfied with the result.

you are using a VPN software that's why you can access the server but you will definitely not going to access it directly when using WAN.

 

[YuriShibuya1993]

i dont understand!!

 

[SeraphiPod]

You know what Yuri
you can't understand because you always say, I don't Understand
Try to understand it at yourself too...

i don't understand!!

hmm?

 

[jampang]

: GREETING to all RZ memeber
i'm new guyz n i have so many question in my head, so pliss help me out.
1. i have done build a ranonline server client so i can play in LAN
2. i have done with GMC n RANCP
the question is :
how i can other people not on LAN can play my ranonline, please tell me in detail what should i do?
please guys help me out?

 

[Nilolabid25]

Ahaha sana naman abry ol mo na speedran mo

 

[nomairyali]

how about a tutz in remote connection using hostgator hosting?
cpanelx