- Joined
- Jul 19, 2006
- Messages
- 1,178
- Reaction score
- 40
A3 202/205 Server Guide
Thanks to Legendary and Akaruz for their Initial Guides
Akaruz Guide
http://forum.ragezone.com/showthread.php?t=97099
Legendary Guide
http://forum.ragezone.com/showthread.php?t=150577
Things that you need:
Server Files
Recommended Server Files:
Filefront:
Rapidshare
Additional Server Files can be found at:
http://forum.ragezone.com/showthread.php?t=244175
Client
Client is uploaded into 5 parts:
Microsoft SQL Server 2000
Microsoft SQL Server Service Pack 4 Update
*****All Links are Updated and working fine! (29th May 2008 10:20:44 PM)*****
Setting Up server:
I have writen the Guide in accordance with the Recommended server files keeping in mind the
default configs. If you use any other server files, you need to edit some basic stuff first!
First of all, we must install the SQL Server 2000.
SQL Server is Structured Query Language, which is a database software which stores the data
pertaining to our A3 Server. Hence we need to configure it to store our Server's data!
The Installation of SQL Server is depicted in the following Screenshots!
![cvrdheeraj - [GUIDE] A3 Server 202/205 Guide - RaGEZONE Forums](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7 "cvrdheeraj - [GUIDE] A3 Server 202/205 Guide - RaGEZONE Forums")
Select Local Computer if you are installing databases on the same computer.
Select Create a new instance
Provide your Personal Information
Accept the License Agreement
Select Server and Client Tools
Check the Default Instance and Click Next
Select the Installation type
Check the "Use Local System Account button"
Now this is the Important Step! Select Mixed Authentication Mode and now Enter User ID as
"sa" and password is your wish.
Once you have finished installing SQL Server, you need to start the SQL Server Service. To
Start this,
Start -> Programs -> Microsoft SQL Server -> Service Manger
Service Manager will look like this:
Under Services, select SQL Server and then click on the Play(Start) button to start the
service. Once the service is started, a Play button is indication near the server figure!
Now, you need to Create and Restore databases! To do this,
Start -> Programs -> Microsoft SQL Server -> Enterprise Manager
Now in the Enterprise Manager, on the left hand side of Hirarichal window, Expand the Local
System key, and then expand the Databases Key
Now right click on the Right hand side of the Enterprise Manager and select "New Database"
The following window will Pop up!
In the Database Name, just enter ASD and click OK. A new Database is now created.
In the same way, you need to create a total of
ASD (already created)
Character
A3ItemEvent
Itemstorage
FriendDB
HSDB
Once you have finished creating the databases, you need to restore the databases!
To restore the databases, follow the following steps!
Right Click on the ASD Database. Select "All tasks" and then select "Restore Database"
A Window Pops up! Now Select "From Device". Click on "Select Devices" and then click on
"Add". The following window pops up!
Now You need to select the ASD.bak file which is present in the Database Backup folder of
the A3Server files.
In the same way, you need to restore all the databases
ASD - ASD.bak (already restored)
Character - Character.bak
A3ItemEvent - A3Itemevent.bak
Itemstorage - Itemstorage.bak
FriendDB - FriendDB.bak
HSDB - HSDB.bak
After finishing the database restore, you need to create a new user login!
On the Left pane of the Enterprise Manager, Expand Security Key and then click on Logins.
Right click in the right pane and click on New Login. The procedure is depicted in the
screenshot
In the Name, type "a3serial". Select SQL Authentication and in the Password box, type the
following password "dkdlxpawprhdnpc". The procedure is depiced in the Screenshot
Once done, click on the Database Access Tab.
Tick Pemit Check Box for the A3ItemEvent Database. In the bottom window check mark
"db_owner". The procedure is depicted in the screenshot.
Now, You need to create ODBC for your SQL Server Databases. This can be done either by
adding values directly to Registry or by adding them manually. Inorder to Make it easy, I
have included a ODBCSetup.reg file in A3Server folder of the Server Files. Just execute it
and all the ODBC are created automatically.
You need to install Borland Database Engine, which is needed by the server to connect to the
SQL Database. This Library is present in the Server Files (BDESetup)
Open the Drive C folder in the A3 Server Files that you have downloaded. Copy all those
directories and paste them in C:\ root directory.
Starting The server.
Inorder to start a server, you need to run different servers in a particular order!
Setting Up 7770, 8880, 9990
In the Server Files, you will find 3 folders named 7770, 8880 and 9990. They have 2 files in
them!
Now, Open the tbd.ini present in the 7770 folder
It contains the following;
Here, you need to replace the second "sa" with the sa password that you have provided during
your SQL Server Installation. Suppose you have provided the password "mania", then the
config file should look like this!
Save the File and then run the asd_mw_v1.1.19a.exe which is present in the same folder.
Click on the first "Click" button. Then click on second "Click" button and then click on
"Start". If you have followed the guide fine, it will look as follows
Similarly you need to edit tbd.ini files in both 8880 as well as 9990.
7770 - Account
8880 - Character
9990 - Itemstorage
These servers are responsible to connect the Mainservers to the Database!
Open the Loginagent folder and then open the Loginagent.ini
It will be as follows
Thanks to Legendary and Akaruz for their Initial Guides
Akaruz Guide
http://forum.ragezone.com/showthread.php?t=97099
Legendary Guide
http://forum.ragezone.com/showthread.php?t=150577
Things that you need:
Server Files
Recommended Server Files:
Filefront:
You must be registered to see links
Rapidshare
You must be registered to see links
Additional Server Files can be found at:
http://forum.ragezone.com/showthread.php?t=244175
Client
Client is uploaded into 5 parts:
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
Microsoft SQL Server 2000
You must be registered to see links
Microsoft SQL Server Service Pack 4 Update
You must be registered to see links
*****All Links are Updated and working fine! (29th May 2008 10:20:44 PM)*****
Setting Up server:
I have writen the Guide in accordance with the Recommended server files keeping in mind the
default configs. If you use any other server files, you need to edit some basic stuff first!
First of all, we must install the SQL Server 2000.
SQL Server is Structured Query Language, which is a database software which stores the data
pertaining to our A3 Server. Hence we need to configure it to store our Server's data!
The Installation of SQL Server is depicted in the following Screenshots!
![cvrdheeraj - [GUIDE] A3 Server 202/205 Guide - RaGEZONE Forums](https://forum.ragezone.com/images/404_image.png "cvrdheeraj - [GUIDE] A3 Server 202/205 Guide - RaGEZONE Forums")
Select Local Computer if you are installing databases on the same computer.
Select Create a new instance
Provide your Personal Information
Accept the License Agreement
Select Server and Client Tools
Check the Default Instance and Click Next
Select the Installation type
Check the "Use Local System Account button"
Now this is the Important Step! Select Mixed Authentication Mode and now Enter User ID as
"sa" and password is your wish.
Once you have finished installing SQL Server, you need to start the SQL Server Service. To
Start this,
Start -> Programs -> Microsoft SQL Server -> Service Manger
Service Manager will look like this:
Under Services, select SQL Server and then click on the Play(Start) button to start the
service. Once the service is started, a Play button is indication near the server figure!
Now, you need to Create and Restore databases! To do this,
Start -> Programs -> Microsoft SQL Server -> Enterprise Manager
Now in the Enterprise Manager, on the left hand side of Hirarichal window, Expand the Local
System key, and then expand the Databases Key
Now right click on the Right hand side of the Enterprise Manager and select "New Database"
The following window will Pop up!
In the Database Name, just enter ASD and click OK. A new Database is now created.
In the same way, you need to create a total of
ASD (already created)
Character
A3ItemEvent
Itemstorage
FriendDB
HSDB
Once you have finished creating the databases, you need to restore the databases!
To restore the databases, follow the following steps!
Right Click on the ASD Database. Select "All tasks" and then select "Restore Database"
A Window Pops up! Now Select "From Device". Click on "Select Devices" and then click on
"Add". The following window pops up!
Now You need to select the ASD.bak file which is present in the Database Backup folder of
the A3Server files.
In the same way, you need to restore all the databases
ASD - ASD.bak (already restored)
Character - Character.bak
A3ItemEvent - A3Itemevent.bak
Itemstorage - Itemstorage.bak
FriendDB - FriendDB.bak
HSDB - HSDB.bak
After finishing the database restore, you need to create a new user login!
On the Left pane of the Enterprise Manager, Expand Security Key and then click on Logins.
Right click in the right pane and click on New Login. The procedure is depicted in the
screenshot
In the Name, type "a3serial". Select SQL Authentication and in the Password box, type the
following password "dkdlxpawprhdnpc". The procedure is depiced in the Screenshot
Once done, click on the Database Access Tab.
Tick Pemit Check Box for the A3ItemEvent Database. In the bottom window check mark
"db_owner". The procedure is depicted in the screenshot.
Now, You need to create ODBC for your SQL Server Databases. This can be done either by
adding values directly to Registry or by adding them manually. Inorder to Make it easy, I
have included a ODBCSetup.reg file in A3Server folder of the Server Files. Just execute it
and all the ODBC are created automatically.
You need to install Borland Database Engine, which is needed by the server to connect to the
SQL Database. This Library is present in the Server Files (BDESetup)
Open the Drive C folder in the A3 Server Files that you have downloaded. Copy all those
directories and paste them in C:\ root directory.
Starting The server.
Inorder to start a server, you need to run different servers in a particular order!
Setting Up 7770, 8880, 9990
In the Server Files, you will find 3 folders named 7770, 8880 and 9990. They have 2 files in
them!
Now, Open the tbd.ini present in the 7770 folder
It contains the following;
Here, you need to replace the second "sa" with the sa password that you have provided during
your SQL Server Installation. Suppose you have provided the password "mania", then the
config file should look like this!
Save the File and then run the asd_mw_v1.1.19a.exe which is present in the same folder.
Click on the first "Click" button. Then click on second "Click" button and then click on
"Start". If you have followed the guide fine, it will look as follows
Similarly you need to edit tbd.ini files in both 8880 as well as 9990.
7770 - Account
8880 - Character
9990 - Itemstorage
These servers are responsible to connect the Mainservers to the Database!
Open the Loginagent folder and then open the Loginagent.ini
It will be as follows
Last edited:
