1) How To Make Private Server With Detail.

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