[Guide] 2.02/2.05 Server Guide UPDATED

Legendary · Jul 9, 2006

2.02 Server Guide (UPDATED July 2006)

Ok.. Alot of people in ragezone are having problems setting up their servers or just can't seem to understand what the SEARCH button is for... Well this guide is for those who want to set up a A3 2.02 Server... credit goes to Akaruz for the first guide so read his before you come and ask questions

http://forum.ragezone.com/a3/a3-202-205-guide-97099.html <<Akaruz Guide

First, you need the SERVER FILES : GO LOOK FOR THEM

Still can't get your server up? READ THIS GUIDE again...

First, you need Microsoft SQL 2000.. you can get it at the following links:

Microsoft SQL 2000 =

You must be registered to see links

Microsoft SQL update =

You must be registered to see links

A Hex editor =

You must be registered to see links

Note: This server is meant to work on D drive not on C:/.. if you do not have a second HDD or drive, simply create a "virtual" drive by downloading this tool :

You must be registered to see links

Install SQL... Go read the other threads on how to install if you don't know.. your server WILL NOT WORK if you screw the MSSQL 2000 installation..

Install SP3 for MS SQL 2000 (IMPORTANT)

Download the Server file and then unzip the file to D:/ (Make sure it is D:/A3server NOT D:/A3server/A3server..)

IMPORTANT: YOU NEED BDE.. either LOOK for it using google or use it from the 1.20 files.
If you FOLLOW all the steps I have mentioned, it should work...

First click start and go to Microsoft SQL server > Service Manager
Click START server

Go to D:/A3server.. There should be 17 Folders there...

Creating the Databases

Open the SQL server Enterprise manager.. >click start and go to Microsoft SQL server > Enterprise Manager
Go and add databases, A3ItemEvent, ASD, FriendDB, HSDB, character, itemstorage and clan

Restoring the Databases

You got to restore the DBs.. BUT, instead of looking endlessly for the BAK files in the A3server dir (cos you'll never find it), SQL scripts are PROVIDED instead..

In D:/A3server/Part3SQL
There should be some .SQL and .TXT files inside..

you might need certain files to restore the character itemstorage and clan DBs.. use the 1.20 ones..

click start and go to Microsoft SQL server > Query Analyser
Connect to your SQL server.. use your username and password..
After that, Click file and open; go to D:/A3server/Part3SQL and select ASD.sql
A whole list of commands should appear in the box.. RIGHT CLICK the box and click EXECUTE... Restoration of ASD DB is complete..

Now do the same method for the 3 other DBs using the table below.. you click new/Blank query for each time..

DATABASE : FILE
ASD : ASD.sql (DONE)
HSDB : A3HSDB.txt
FriendDB : Friend24.txt
A3ItemEvent : A3itemEvent.txt

for the other 3 DBs, use the 1.20 BAK files (I hope you know how to restore DBs)

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt (MAKE SURE the DBowner is A3itemevent!!)

its all on 新数据库配置说明.txt file...

(NOW THIS IS VERY IMPORTANT, screw this and you will 100% get a DB CONNECT ERROR)

This is the ODBC reg file that Akuraz posted in his guide:

YOU DON'T GO AND JUST RUN IT!! YOU MUST MANUALLY CREATE THE ODBC ENTRIES!!

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvResult ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Seriallist]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"="(Local)"

After that, change every single IP address to your IP address (192.168.X.X for LAN or your IP address for WAN) in all the .ini and .cfg files..

After that, LOOK at all the ini/cfg for your username and password and replace them respectively..

Create:

C:\A3log
C:\Clan
C:\Zonelog
C:\A3LogBackup
C:\A3_ClanMarkData

If all goes well, you can start your server;
do in the following order:

1- 01Account = 7770 dir
2- 02Character = 8880 dir
3- 03ItemStorage = 9990 dir
4- 04LoginServer = Loginserver dir
5- 05LoginAgent = Loginagent dir
6- 06Zoneagent = Zoneagent dir
7- 07MainServer= Mainserver dir
8- 08Accountserver= Accountserver dir
9- 09Zoneserver = Zoneserver dir (If it has Game init Error, LOOK the Guide again)
10- 10Battleserver = Battleserver dir

If all goes well, your server should be running.. next you must find a suitable client to run with your server.. you can try to find the ara3 client (which I think is impossible to find) or the A3 SG's client ;

You must be registered to see links

or look for Toxic's clients... the Korean client is also possible
Like what I mention in my other guide, Hex the A3client.exe to change your IPs to your server's....

Another thing I would like to point out, run the server slowly one by one.. DON'T RUN ALL AT ONCE!! YOUR ZONESERVER WILL NOT WORK PROPERLY!!

dastorm · Jul 9, 2006

but wht to do with the xtra Dbs????? dont we have to create entries in ODBC for those????

Legendary · Jul 9, 2006

you check the 8880 and 9990.. check the TDB.ini... 8880 is for character so LOOK INSIDE THE TDB.ini and the ODBC NAME IS REPEATED MANY TIMES.. 9990 is for itemstorage..

suruchi_sogano1 · Jul 26, 2006

What re u posted entire guide for server 2.02 except the link to server file.
Post the missing one

Legendary · Jul 26, 2006

READ THIS:

First, you need the SERVER FILES : GO LOOK FOR THEM

Wassbr · Sep 29, 2006

Hey Legendary, can you tell me what i have to write in tdb.ini's?

is it like this? (example for 7770)

[main]
title=database_name 7770
keepalive=10

[dbconnection]
00=h3db00 database_name sa sa_pwd account 0 1
01=h3db01 database_name sa sa_pwd account 1 1
02=h3db02 database_name sa sa_pwd account 2 1
03=h3db03 database_name sa sa_pwd account 3 1
...

[socket]
port=7770

because i wrote like that and it says "[ERR] Cannot connect"

Thanks.

Legendary · Sep 30, 2006

03=h3db03 database_name sa sa_pwd account 3 1

firstly, 7770 is the ASD database.. so you link the ASD DB with the A3ASD ODBC point. Let's say your sa username is sa and password is 123456

03=h3db03 A3ASD sa 123456 account 3 1

David10790 · Jan 7, 2007

Well i got every thing working after following ur guide except Zone Server but then in the end u said to re-check the guide "if ur getting an inf error)
After re-checking i was just missing one step or rather was not able to follow it >>

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt (MAKE SURE the DBowner is A3itemevent!!)

its all on 新数据库配置说明.txt file...

Now the DB owner in ????????.txt is already A3Itemevent
n does this mean we have to create another Windows user account ,an A3 account or sm other account.....plz elaborate n help on this if u cn
Or could the reason for Zoneserver error be ODBC entries,but i checked n re-checked all entries according to 2 guides (urs n Akaruz's) but diddn't find ne mistakes (btw r the name's of ODBC entry "Local Ser ver" n "A3RcvRes ult" correct ?)

RudyMartin · Jan 7, 2007

David10790 said:
Well i got every thing working after following ur guide except Zone Server but then in the end u said to re-check the guide "if ur getting an inf error)
After re-checking i was just missing one step or rather was not able to follow it >>

Now the DB owner in ????????.txt is already A3Itemevent
n does this mean we have to create another Windows user account ,an A3 account or sm other account.....plz elaborate n help on this if u cn
Or could the reason for Zoneserver error be ODBC entries,but i checked n re-checked all entries according to 2 guides (urs n Akaruz's) but diddn't find ne mistakes (btw r the name's of ODBC entry "Local Ser ver" n "A3RcvRes ult" correct ?)

franlky, I have never seen the "?????.txt" file, nor it doesnt care to me.

you need a user for the SQL and another for the game. both are created on the SQL server using the appropiate tools. as for the ODBC entries, white spaces are *wrong*. most of the errors in the server and connection problems are ODBC related. double check them each time you have a problem.

rudy.

David10790 · Jan 7, 2007

RudyMartin said:
franlky, I have never seen the "?????.txt" file, nor it doesnt care to me.

you need a user for the SQL and another for the game. both are created on the SQL server using the appropiate tools. as for the ODBC entries, white spaces are *wrong*. most of the errors in the server and connection problems are ODBC related. double check them each time you have a problem.

rudy.

Well these ??? are basically empty squares made by using alt + key pad no comibination but these boxes appear as "?" in RaGEZONE forums
N i have check all my SQL entries many times n they r exactly same as the ones in this guide (except those *wrong* gaps),they r in the same order n have string values n same orders too......dunno what seems to be the prob,having probs with Zoneserver only rest all is working fine :turned:

trixter · Jan 7, 2007

ya zoneserver creates prblms when odbc has prblms most of time !!!

iNs@nE · Jan 8, 2007

You never clearly stated your problem. But from the broken setences, I think your problem is the A3SERIAL Login. This is how you fix it.

First, go to SQL Enterprise Manager and go to Security>Logins
There make a new id called "a3serial" by the password you mentioned above. And set your master database as A3ItemEvent.
Go to the third tab and tick the A3ItemEvent as its DB Owner and click OK. This will make the login a3serial is owner. This should fix your problem.

David10790 · Jan 8, 2007

iNs@nE said:
You never clearly stated your problem. But from the broken setences, I think your problem is the A3SERIAL Login. This is how you fix it.

First, go to SQL Enterprise Manager and go to Security>Logins
There make a new id called "a3serial" by the password you mentioned above. And set your master database as A3ItemEvent.
Go to the third tab and tick the A3ItemEvent as its DB Owner and click OK. This will make the login a3serial is owner. This should fix your problem.

In Security>Logins there already existed a a3serial but with a diffrent 8-character password n when i tried to replace this pas with the one provided in the guide it reverted to the before one (8-char).....n yes this pass matches the sa pass (in characters only,so dunno if its the same)

iNs@nE · Jan 8, 2007

No. Delete the Login and make another one with this password. You SA can be the same as this one, but this one has to be the one mentioned in the guide.

rohit_jo890 · Jan 14, 2007

i stucked in Bde process can any 1 guide where can i get it .. 1 downloaded 1 but its not installing error message occure Need C++ 5.0 smthing ...can any 1 guide me or where can i get the right one plzplz

iNs@nE · Jan 14, 2007

Search Google for Borland's Database Engine...you will get it..!!
Try try or die..! Simple..!!

Zarz · Feb 15, 2007

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial list]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

WHERE HAVE I TIO WRITE THIS text?????

iNs@nE · Feb 15, 2007

OMG! Sincere opinion. Do not make the server.

But I am here to help. So I will tell you what.
Copy them into a word pad and save the file as ODBC.reg
Then double click it and register them.
Once that is done, go verify the ODBC's in Control Panel>Administrative Tools>Data Sources>ODBC

iNs@nE · Feb 15, 2007

@ Legendary

Dude, This is one of the simplest and perfect guides possible. Maybe you just make this a sticky. Think about it.

Yag4mi2k · Feb 15, 2007

errrrrrrrrrrr

you InS@ne could answer to that it sees this image, that error would be this?

Welcome!

[Guide] 2.02/2.05 Server Guide UPDATED

Master Summoner

Skilled Illusionist

Master Summoner

Newbie Spellweaver

Master Summoner

Newbie Spellweaver

Master Summoner

Newbie Spellweaver

Master Summoner

Newbie Spellweaver

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Custom Title Activated

My LanHouse in Brazil!!!!

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor