1) How To Make Private Server With Detail.
For Making New Private Server You Must Need Under All Files
SQL Server 2000 And Above
NOTE :- Easy To Make In Server 2000 So Keep Try On
SQL 2000 First New Comer
SQL Service Pack 3
A3 Server Files ( Episode 5)
A3 Client Files ( Episode 5)
Some A3 Tools
Follow Below STEP : First Of All Install SQL 2000
Then Install SQL Service Pack 3.
NOTE: - How To Install SQL 2000 & It’s Service Pack 4 Check
The Given Guide File (SQL INSTALL.docx)
Then Take Restart
Then Extract A3 Server Epi-5 At D:\a3server\
Your All Files Must At This Given Directory
Now Copy Drive C From D:\a3server\Drive C Folder Files And Paste At C:\
Start Microsoft SQL Server
Start -> Program Files -> Microsoft SQL Server ->
Service Manager
Now Go To
Start -> Program Files -> Microsoft SQL Server ->
Enterprise Manager
Enterprise Manager
Make New Database
Select The Database Option On Enterprise Manager Then...
Make Give Seven Named New Data Base…
Right Click -> New Database… -> Type Name As Given -> Ok
Names :1) A3ItemEvent
2) ASD
3) Character
4) Clan
5) FriendDB
6) HSDB
7) ItemStorage
Restore Database : Follow Process In Given Photos
Right Click On Each Database Then…
After Press Restore Database…
Follow Under Photo’s Green Color Words Process
Process For Restore
Right Click On Database ->
All Tasks ->
Restore Database… ->
Select From Device ->
Add ->
Select Path As Given In Photo ->
Ok Ok Ok Ok Ok.
Make This Restore Process For Five Database Only
1) A3ItemEvent
2) ASD
3) Clan
4) FriendDB
5) HSDB
Now Go To…
Security -> Logins
Right Click -> New Login…
Name: = a3serial
Select SQL Server Authentication
Password: =
dkdlxpawprhdnpc
Then Tab To…
Database Access
Select…
A3ItemEvent
And
db_owner
Note : Some Times It Gives An Error "Login Serial
Already Exists”…
If You Got This Error Message Then Go To…
Databases -> A3itemEvent -> Users
Delete the a3serial there in users…
Then Again Do the Process Mentioned Above
To Make New a3serial…
Make Data Sources (ODBC)
Start -> Control Panel -> Administrative Tools -> Data
Sources (ODBC) -> System DSN -> Add
Add And Select “ SQL Server “ Then…
Press Finish Then…
For Path Of SQL Server Service Manger
Start -> program files ->
Microsoft SQL server ->
Service Manager.
Press Next Then…
Select Second Option
With SQL Server Authentication Using A
Login Id & Password Entered By The User
Press Next Then…
Select Option Change The Default Database To
And Select “ A3ItemEvent “
Then Press Next…
Then Finish.
You Need To Make This Process To Other Data
Too…
Name
A3Friend
A3RcvResult
A3SerialList
ASD
EventA3
FriendDB
HSDB
LETTERDB
LocalServer
Login202
NEWASD
=
Change Database
=
FriendDB
=
A3ItemEvent
=
A3ItemEvent
=
ASD
=
ASD
=
FriendDB
=
HSDB
=
ASD
=
ASD
=
ASD
=
ASD
Now Go To
o D:\a3 server
And Select ODBC Registry Setup…
Double Click -> Yes -> Ok.
Now For Make Game GM Username & Password
Note:- Remember It This Is Use For In Game Login
This
Line For Make Id & Password
INSERT INTO account (c_id, c_sheadera,
c_sheaderb, c_sheaderc, c_headera, c_headerb,
c_headerc, d_cdate, c_status, m_body) VALUES
('Divyesh','*','*','*','*','*','*','1/1/2003
12:00:00','A','*')
Now At In Line You See “
*
“ Replace With Your Any
Password.
For Example My password = 111 Then My Lines Are :
INSERT INTO account (c_id, c_sheadera, c_sheaderb,
c_sheaderc, c_headera, c_headerb, c_headerc, d_cdate,
c_status, m_body) VALUES
('Divyesh','111','111','111','111','111','111','1/1/200
3 12:00:00','A','111')
Then Copy That New Line…
Now Open…
Start -> Program Files -> Microsoft SQL Server ->
Query Analyzer -> Login As Saw In Photo
Press Ok
After Press F5 You Can See ( 1 Row(S) Affected )
Now Your GM Account Made Successful
Now For Make Episode 5 Client Private…
o D:\a3 server\Z OTHER Z\CLIRNT FOR EPI 5
PERSONAL SERVER
And Select A3Client And Copy…
Then Paste That In Any Episode 5 Client Direct
And Replace With Old File…
“ NOW YOUR SERVER READY TO RUN
YOUR OWN COMPUTER ”
To Start Server Open…
o D:\a3 server\ZZ SHORT CUT ZZ\
Double Click On 01
Click -> Click -> Start
Double Click On 02
Click -> Click -> Start
Double Click On 03
Click -> Click -> Start
Double Click On 04
Double Click On 05
Double Click On 06
Double Click On 07
Double Click On 08
Double Click On 09 (W8 Till Response Take
More Time To Run )
Double Click On 10
Double Click On 11
Double Click On 12.1
Double Click On 12.2
Double Click On 13
After Above All File Run…
Run Client Server And Login With
Created ID & Password.
Enjoy The Own Dream Server
All Guide Crated By
Divyesh Patel
Sagar ladva
© Copyright 2025