Noob guide for setting up ko server

[serak]

Read this before setting this thing up!!!!

http://forum.ragezone.com/showthread.php?t=26559





Here it is my noob guide for setting up ko server


Setting up SQL


Run SQL Setup
Select "SQL Server 2000 Components"

1. Click "Install Database Server"

2. Click Next

3. Click dot in Local Computer and Next

4. Click dot in "Create a new instance of SQL Server,or install Client Tools" and
next

5. Put name and company Click Next

6. Click Yes to Agreement

7. Click dot in Server and Client Tools and Next

8. Click dot in Default at top and Click Next

9. Click dot in Typical Click Next

10. Click dot in "Use the same account for each service.Auto start SQL Server
Service"

11. Click dot in "Use the Local System account" Click Next

12. Click dot in "Mixed Mode." and enter a password Click Next

13. Click Next and install

14. When installed reboot so server starts.

-----

Restoring Database


1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

2. Console Root -> Microsoft SQL Servers -> SQL server Group ->

3. Right click (local)(windows) -> Edit SQL server Registration properties

4. Click dot in Use SQL Server authentication -> Login name sa -> leave
password blank -> click dot in Always prompt for login name and password


***LOGIN WITH THE USER/PASS sa/yourpasshere***

and go to Databases.

5. Create a new database, name it KN_online

6. After that, right click on KN_online database then click all tasks and
then "Restore Database".

7. Click on "From Device" and then click on "Select Devices".

8. Click Add and then choose the destination of the backups to Restore into
KN_online.

9. Press OK 3 times to continue, then press the Options tab.

10. Click dot in "Force restore over existing database",

11. Make sure the path of the MDF and LDF files is the same of your server files
(KNonline_data and KN_online_log)

12. Press OK to import the database.

13. Console Root -> Microsoft SQL Servers -> SQL server Group ->
(local) (windows)

14. Go to Security -> Login -> Right click -> New Login

15. Put name knight -> Click dot in sql server authentication

16. use knight as password -> Choose KN_online as database

17. Go to tab Database access -> click on database KN_online

18. In permit in database role click on db_owner -> ok

19. Go to database KN_online -> Right Click -> Properties -> Permission
Click all of them on user knight

20. Disconect from sql server and relog using the user knight in enterprise
manager.

-----

Adding Accounts


1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager) and go to Databases

2. Choose KN_online

3. Choose Tables

4. Edit ACCOUNT_CHAR and WHAREHOUSE and USERDATA ( by right click -> Open
table -> Return all rows)
They must be empty (Only for the first time)

5. Edit KNIGHT_USER ( by right click -> Open table -> Return all rows)
For adding accounts

-----

System DSN


1. Start Data Sources (ODBC) (Start -> Programs -> Administrative Tools -> Data
Sources (ODBC)), go to System DSN tab then click Add.

2. Select the SQL Server driver(bottom) and click Finish. Choose KN_online for
Name and your SQL Server for Server.

3. Choose sql server authentication -> connect to sql server to obtain settings
Use knight/knight as user

4. Change the default database to KN_online and click Next then Finish and OK.

5. Do the same for Knight_Account, knight, GameDB, AccountDB1, AccountDB.

-----

Edit the ini files


1. Open Aujard.ini -> should look like this

[ODBC]
ACCOUNT_DSN=KN_Online
ACCOUNT_UID=knight
ACCOUNT_PWD=knight
GAME_DSN=KN_Online
GAME_UID=knight
GAME_PWD=knight
LOG_DSN=KN_Online
LOG_UID=knight
LOG_PWD=knight

2. Open Version.ini -> should look like this

[DOWNLOAD]
URL=wizgate.nefficient.co.kr
PATH=pub/wizgate2/knight/upgrade

[ODBC]
DSN=KN_Online
UID=knight
PWD=knight
TABLE=VERSION

[CONFIGURATION]
DEFAULT_PATH=c:\Program Files\KnightOnline
[SERVER_LIST]
COUNT=1
SERVER_00=PUTYOURIPHERE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
NAME_00=BEGINNER

3. Open Server.ini -> should look like this

[TIMER]
YEAR=1
MONTH=2
DATE=5
HOUR=10
WEATHER=1
[LOGIN SERVER]
IP=PUTYOUIPHERE!!!!!!!!!!!!!!!!!!!!!!!!!
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=PUTYOUIPHERE!!!!!!!!!!!!!!!!!!!!!!!!!!
SERVER_NUM=0
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
[AI_SERVER]
IP=PUTYOURIPHERE!!!!!!!!!!!!!!!!!!!!!!!!!!!

4. Open Server2.ini -> should look like this

[LOGIN SERVER]
IP=PUTYOURIPHERE!!!!!!!!!!!!!!!!!!!!!!
[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=PUTYOURIPHERE!!!!!!!!!!!!!!!!!!!!!!!!!!!

-----

Starting the servers

1. Put the map files in \aiserver\map and ebenezer\map

2. Start Loginserver -> VersionManager.exe

3. Start Aiserver -> Server.exe

4. Start Ebenezer -> Ebenezer.exe
(if you get a notice.txt error just make one)

5. Start Aujard -> Aujard.exe

------

Connecting with client


1. Remove any version of ko client you have installed

2. Install KnightOnline_cn_1097.exe

3. Extract the patch1089.zip in the same folder of your knightonline client

4. Edit the Server.ini in your client folder, and it should look like this

[Server]
Count=2
IP0=PUTYOURIPHERE OR PUTIPOFREMOTESERVER!!!!!!!!!!!!!!!!!!
IP1=PUTYOURIPHERE OR PUTIPORREMOTESERVER!!!!!!!!!!!!!!!!!!

5. Start the game using KnightOnLine.exe

6. HAVE FUN!!!!

(Check phonomania his sticky post about the skill bug!!!!)
http://forum.ragezone.com/showthread.php?t=25471

(Uninstall all clients that are installed before installing ko_ch_1097.exe
or you wont be able to create a char)

************
NEW!!!!!!!!!!!!!!
if after above you still got problems creating char, (the chair stays empty)
then you need to download and install SP3 for MSSQL!!!!!!!!!!
(Credit goes to stinger357 who found out the problem)
************

Credit goes to akit and phonomania for helping me out

(serak aka as MoMo aka as MoMoTaTa)

 

[someone_kk]

oh lol gj I think

 

[mehow]

Thanks a lot m8 ))))))))))))))))))))))
Im of to go try it

 

[mehow]

Everything is ok untill :

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quote:
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

***LOGIN WITH THE USER/PASS sa/yourpasshere***

and go to Databases.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Where do we log in for this ???

***LOGIN WITH THE USER/PASS sa/yourpasshere***

 

[Akaruz]

Everything is ok untill :

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quote:
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

***LOGIN WITH THE USER/PASS sa/yourpasshere***

and go to Databases.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Where do we log in for this ???

***LOGIN WITH THE USER/PASS sa/yourpasshere***

depends on your settings , some sqls automaticly run without asking for the sa and password , Others for security reason .. have to insert the login details

 

[mehow]

ok, but where does the "sa" login name belong please ?
should I have used it during the SQL Install ?
The noob guide made no mention of it.

Any reference to login names and passwords, I have used "knight"

On start up of "VersionManager.exe" i get error message:

LoadVersionListFail !

 

[cainwong]

You are right, mehow.
You have to set the password for 'sa' during SQL installation.

The recent SQL SP3 need this for security (Akaruz is right) and stability purpose.
Service Pack 3:

You must be registered to see links

The username for sa will stay as 'sa' without quote.
Later, you can find 'sa' user appears in the Enterprise Manager -> Microsoft SQL Servers -> SQL Server Group -> PC-Name -> Security -> Logins

I use this for my server:
knight (Username) and knight (Password) -> Server
kn_online (Username) and knight (Password) -> DBSaver & DBWorker (Modified)

 

[serak]

Everything is ok untill :

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quote:
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

***LOGIN WITH THE USER/PASS sa/yourpasshere***

and go to Databases.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Where do we log in for this ???

***LOGIN WITH THE USER/PASS sa/yourpasshere***

Aaaarrggh i forgot that really sry

1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

2. Console Root -> Microsoft SQL Servers -> SQL server Group ->

3. Right click (local)(windows) -> Edit SQL server Registration properties

4. Click dot in Use SQL Server authentication -> Login name sa -> leave
password blank -> click dot in Always prompt for login name and password

Hope this help if have problems just post i ll reply asap
thx btw

 

[phonomania]

i dont intall sp3 , and dont have password for sa , and it still ok. a problem here is he check checkbox that allow him to enter w/o entering username/password. i m mssql noob too ( not only client noob). wut i do - i just deleted all root in enterprse manager , and create it again without checking this checkbox , lol. so now i really know with wich user i entered , he he

 

[Akaruz]

i dont intall sp3 , and dont have password for sa , and it still ok. a problem here is he check checkbox that allow him to enter w/o entering username/password. i m mssql noob too ( not only client noob). wut i do - i just deleted all root in enterprse manager , and create it again without checking this checkbox , lol. so now i really know with wich user i entered , he he

sp3 is just to put sql safe from certain attacks

 

[serak]

Ok i ve edited the guide, now it should work fine

 

[A3-World]

im missing some maps stuff or something when i run server.exe

 

[serak]

Yep you need map files
i got them here but the link is dead
try to ask someone to upload them

http://forum.ragezone.com/showthread.php?t=24262

You need to put them in folder /aiserver/map and /ebenezer/map

 

[A3-World]

ok darn i bum[ped topic and said link dead lets hope somone see it thanks

 

[DOT-_-]

Everything is ok untill :

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quote:
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)

***LOGIN WITH THE USER/PASS sa/yourpasshere***

and go to Databases.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Where do we log in for this ???

***LOGIN WITH THE USER/PASS sa/yourpasshere***

you have to set the pass when you setup mssql, or at the Security/Logins in Enterprise manager

 

[A3-World]

hey great guide works nice

 

[mehow]

Well I`m very impressed with all the replies THX
I will start afresh, remove sql and re-install
I will let you know how I get on.

 

[DOT-_-]

if you have done this yourself then good for you because i saw a copy of this on another forum, check this out

You must be registered to see links

 

[serak]

AFRRGGGGGGGGGG they stole it from me
ask akit and phonomania they saw my progress
i even got my old files and also
check the date of the post lol
i dun have a time travel machine
i dun mind they steal but leave the credit!!!!!!!!

anyway thx for showing that post

 

[DOT-_-]

AFRRGGGGGGGGGG they stole it from me
ask akit and phonomania they saw my progress
i even got my old files and also
check the date of the post lol
i dun have a time travel machine
i dun mind they steal but leave the credit!!!!!!!!

anyway thx for showing that post

it's alright, when we're doing such a thing as private server, everybody should share whatever they have, then we can advance faster