Directions for hosting a v.1299 KO Server using MSSQL 2005

OMEGAbuffer · Jun 14, 2008

Directions on how to host a Knight OnLine v.1299 Private Server on Microsoft SQL 2005.

1)Download all of the files here:

a. SQL Installers[Jonny helped me host my server, so I put the installers in a folder named Jonny's SQL. Disregard the name. Creditz to Jonny for giving me the knowledge to make this guide]

SQL Installers(FILEFRONT) =
You must be registered to see links

SQL Installers(MEGAUPLOAD) =
You must be registered to see links

b. Server Files complete with Yeni Klasor Database[I use Heavenskhan's files, so I'll post it here. Creditz to him for Server Files]

Server Files with a 1299 DB =
You must be registered to see links

c. 1299 Client[Optional

Client v.1299 =
You must be registered to see links

NOTE: When you run SQLEXPR32.exe, when you get to the tab where you can tick Windows Authen or Mixed Mode, tick Mixed Mode.[Creditz to Aixu for finding this out.]

2)In the SQL Installers Files, there are for executables: "dotnetfx.exe" "msxml6_x86.exe" "SQLEXPR32.exe" and "SQLServer2005_SSMSEE.exe". Launch them and install them in this order:
dotnetfx.exe
msxml6_x86.exe
SQLServer2005_SSMSEE.exe
SQLEXPR32.exe

3)Run Microsoft SQL Server Management Studio Express. Located at: Start->All Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express

4)Studio Express should open up. A pop-up will occur with 3 things there: Server Type=Database Engine, Server Name=Blank, and Authentification=Windows Authentification. For Server Name, type your computer name, then back-slash it with SQLEXPRESS. For example, ImGay\SQLEXPRESS if ImGay is your computer name.
To find your computer name, right-click "My Computer" and press Properties. A pop-up should occur with System Restore, Automatic Updates, Remote, General, Computer Name, Hardware, and Advanced. Click the Computer Name tab, and your computer name should be posted in that Window.

5)Right-click the databases folder. Press "New Database..." Name it KN_online, then press ok. Located at <ComputerName>\SQLEXPRESS->Databases in your Server Management Studio.

6)KN_online folder should appear now at <ComputerName>\SQLEXPRESS->Databases->KN_online. Right-click it, go to tasks, go to restore, then press database[Tasks->Restore->Database].

7)Whatever database you have, make sure it is extracted to "C:\", without the quotations. If not, do that now. If yeah, disregard this step.

8)Go back to your Server Management Studio. In the Restore Database Window, tick "From Device". Then click the "..." button next to "From Device". Press "Add". On "Files of Type:", put "All Files*". Then, look for your database. It should be under "C:\". When you've found it, click on it, and press "OK". You should be back to Restore Database Window. Tick the "Restore" check next to "kn_online backup" dadadada stuff. Now, on the top left, there should be 2 tabs: General and Options. Go to Options. Tick the check next to "Overwrite the existing database". Then click "OK".

9)Go to Schemas under KN_online security. The only schemas you should have are the following. Located at: <ComputerName>\SQLEXPRESS->Databases->KN_online->Security->Schemas

db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
dbo
guest
INFORMATION_SCHEMA
sys

Delete all other schemas.

10)Go to Users under KN_online security. The only users you should have are the following. Located at: <ComputerName>\SQLEXPRESS->Databases->KN_online->Security->Users

dbo
guest
INFORMATION_SCHEMA
sys

11)Now, you gotta make two users. Go to the Logins folder in the security folder, not the KN_online security. It is located at <ComputerName>\SQLEXPRESS->Security->Logins. Right-click Logins, and press "New Login..." For login name, enter knight. Tick SQL Server Authentification. Enter your password as knight, and in the confirm password as well. For default database, put KN_online. OK, do you see 5 tabs on the top left? Click on Server Roles. Tick all of the roles so that they all have a check next to them. Go back to the tabs, and press User Mapping. Tick the box in Map next to KN_online. In database role membership, tick all of the roles. Press ok.

NOTE: When you make the logins, knight and sknight, in the General Tab, there's 3 tabs regarding password policy under the password fields. Untick them all. [Creditz to Aixu for finding this out.]

12)Do the same for user sknight. However, for the password, put qlfjajrmf6. Your password will be different if you use a different EXE in your Server Files folder. You can change that via hex editting[I think].

13)OK, you can close Server Management Studio if you want. If not, minimize it.

14)Go to your Server Start Files, aka Login Server, AiServer, Ebenezer, and Aujard folders.

15)Go to your Login Server. Edit your Version.ini in there so that it looks like the following:

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

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

[CONFIGURATION]
DEFAULT_PATH=D:\

[SERVER_LIST]
COUNT=1
SERVER_00=YourIP
NAME_00=ServerName

Keep in mind if it says YourIP, put your IP address of your computer; don't leave that there. You can obtain it by going to Start->Run...->cmd->ipconfig.

Now, go back, and go to your AiServer folder. Edit your Server.ini in there so that it looks like the following:

[SERVER]
ZONE=1
PARTYEXP=0
GROUP=0
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
[SERVER]
ZONE=1
PARTYEXP=0
GROUP=0

Now, go back, and go to your Aujard folder. Edit your Aujard.ini in there so that it looks like the following:

[ODBC]
ACCOUNT_DSN=KN_online
ACCOUNT_UID=knight
ACCOUNT_PWD=knight
LOG_DSN=KN_online
LOG_UID=knight
LOG_PWD=knight
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN2=KN_online
GAME_UID2=knight
GAME_PWD2=knight

[ZONE_INFO]
GROUP_INFO=1
ZONE_INFO=1

[SESSION]
IP1=YourIP
IP2=YourIP
[BILLING]
IP=YourIP
PORT=15100
NUM=1

[PREMIUM_ITEM]
ITEM_NUM1=16000
ITEM_NUM2=16001

Now, go back, and go to your Ebenezer folder. Edit your GameServer.ini in there so that it looks like the following:

[TIMER]
YEAR=2008
MONTH=3
DATE=14
HOUR=6
WEATHER=1
[LOGIN SERVER]
IP=YourIP
[CASTLE]
NATION=1

[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=YourIP
SERVER_01=2
SERVER_IP_01=YourIP
SERVER_02=3
SERVER_IP_02=YourIP
SERVER_03=4
SERVER_IP_03=YourIP
SERVER_NUM=1
MAX_USER=2000
[BATTLE]
WEEK=6
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[AI_SERVER]
IP=YourIP
[DB_SERVER]
IP=YourIP
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=KN_online
Account_UID=knight
Account_PWD=knight
[VERSION]
VER=1299
[SG_INFO]
GMY_INFO=1
GSERVER_COUNT=1
GSERVER_00=1
GSERVER_IP_00=YourIP
SERVER_INDEX=1
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=1000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0

Staying in the ebenezer folder, scroll down to Server.ini and edit it so it looks like the following:

[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[VERSION]
VER=1299
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=YourIp
MAX_USER=2000
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=5000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0
[SG_INFO]
SERVER_INDEX=0
[MEMBER]
MEMBER=0
[GO]
THROUGH=0
[WXDZ]
WXDZ=0
[BATTLE2]
WEEK=5
START_TIME=20
END_TIME=0

NOTE: If you want to run your server internally, put 127.0.0.1 into all of the YourIPs.

16)Now, you must forward a couple ports. Find more information about how to forward ports with your router here:

You must be registered to see links

You must forward the following ports:

Name - TCP/UDP - Port#

Battlefield Connections - TCP/UDP - 10040
Elmorad Connections - TCP/UDP - 10030
Game Server - TCP/UDP - 15100
Karus Connections - TCP/UDP - 10020
Login Server - TCP/UDP - 15001
UDP Backport - TCP/TCP - 8888
Web Server - TCP/TCP - 80
Listening Port - TCP/UDP - 15000

NOTE: If it says TCP/TCP, that means you only have to forward a TCP port.

17)Now, go to your ODBC. Located at Start->Administrative Tools->Data Sources(ODBC). There's 7 tabs on the top of the window that pops-up. Click on the System DSN one. Press "Add..." Scroll down to SQL Server and press Finish. For the name, put KN_online. For server, put "<ComputerName>\SQLEXPRESS". Press "Next". Tick SQL Server Identification. Login ID, put knight. Password, put knight. Press "Next". Tick change default database. Adjust it to KN_online. Press "Next". Press "Finish". Press "OK".

18)Do the same for KN_Data, knight, and Knight_Account

19)Make sknight ODBC System DSN, same directions as Step#18. However, for Login ID//Password, put sknight//qlfjajrmf6.

20)Your server is ready! To launch your server, run the following executables in order:

Login Server//VersionManager.exe
AiServer//AiServer.exe
Ebenezer//1298.exe
Aujard//Aujard.exe

To make accounts, go back to the Server Management Studio. Go to <ComputerName>\SQLEXPRESS->Databases->KN_online->Tables->dbo.TB_User . Right-click it, press Open Table. Put your ID//PW in the approppriate column. The column next to PW should be 1, and the column next to that should be 6.

[IMG]https://forum.ragezone.com/ima...recent database should appear on the desktop.

passie · Jun 15, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

nice guide but what is database name ?
the sql file i mean how's it called ?

unch:

OMEGAbuffer · Jun 15, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

passie said:
nice guide but what is database name ?
the sql file i mean how's it called ? unch:

The Database is inside that Yeni Klasor .RAR archive inside the Server Files folder, not the Server Files1 folder. It's also called Yeni Klasor, I believe. I'll try to upload a client for you guys to use, if you want.

Off-Topic

ang, my topic got pinned hecka fast x]

P.S. Client Added

DaRkAnGeL · Jun 16, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

OMEGAbuffer said:
Off-Topicang, my topic got pinned hecka fast x]

all guides must be in the first slot to help the community

2136342 · Jun 16, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

greate job! really nice GUIDE!

pega88 · Jun 16, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

any chance on linux server files?

Aixu · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Hmm for some reason my ODBC doesn't think 'knight' or 'sknight' are associated with a trusted SQL Server connection, what did I do wrong?

2136342 · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

ODBC i think should be for pass qlfjajrmf6 for one of them.

Aixu · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

I did it with SQL2000 now and ODBC works, just don't know how to insert accounts now but will do that later.
First, I get this when I start AI Server.

You must be registered to see links

What is wrong? O_O

OMEGAbuffer · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

pega88 said:
any chance on linux server files?

I think you can use any server files.

Hmm for some reason my ODBC doesn't think 'knight' or 'sknight' are associated with a trusted SQL Server connection, what did I do wrong?

A friend of mine had this problem, and I'm still trying to figure out how to fix it. I'm pretty sure that you guys did something wrong in <ComputerName>\SQLEXPRESS\Security\Logins, or your ODBC was altered in someway, but I'm not sure yet.

RiverWalk · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

I got this error when I'm trying to create the login "knight" :S

OMEGAbuffer - Directions for hosting a v.1299 KO Server using MSSQL 2005 - RaGEZONE Forums

Aixu · Jun 17, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Where you create logins, you see 3 options under the field where you add passwords, uncheck all and it should be working.

RiverWalk · Jun 18, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Aixu said:
Where you create logins, you see 3 options under the field where you add passwords, uncheck all and it should be working.

Working. Thanks

OMEGAbuffer · Jun 18, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Aixu said:
Where you create logins, you see 3 options under the field where you add passwords, uncheck all and it should be working.

I added your "fixes" to my Guide, giving creditz to each one you gave me

ty again

Maikeru · Jun 18, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

I'm good up until the point of running 1298.exe, I get an error
"QUEST INFO READ FAIL(102)(24)", I hit OK, another error:
"AI Server Connect Fail!", but yet, AI Server is up and without error.

Recommendations?

OMEGAbuffer · Jun 18, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Maikeru said:
I'm good up until the point of running 1298.exe, I get an error
"QUEST INFO READ FAIL(102)(24)", I hit OK, another error:
"AI Server Connect Fail!", but yet, AI Server is up and without error.

Recommendations?

There is an error in either your Ebenezer//GameServer.ini, or your Ebenezer//Server.ini

Try revising it.

And the QUEST INFO READ FAIL error, just disregard it.

Maikeru · Jun 18, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

I can't see anything wrong in either file, here's GameServer.ini:

Code:

[TIMER]
YEAR=2008
MONTH=6
DATE=18
HOUR=7
WEATHER=1
[LOGIN SERVER]
IP=midnighter.ath.cx
[CASTLE]
NATION=1

[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=midnighter.ath.cx
SERVER_01=2
SERVER_IP_01=midnighter.ath.cx
SERVER_02=3
SERVER_IP_02=midnighter.ath.cx
SERVER_03=4
SERVER_IP_03=midnighter.ath.cx
SERVER_NUM=1
MAX_USER=2000
[BATTLE]
WEEK=6
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[AI_SERVER]
IP=midnighter.ath.cx
[DB_SERVER]
IP=midnighter.ath.cx
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=KN_online
Account_UID=knight
Account_PWD=knight
[VERSION]
VER=1299
[SG_INFO]
GMY_INFO=1
GSERVER_COUNT=1
GSERVER_00=1
GSERVER_IP_00=midnighter.ath.cx
SERVER_INDEX=1
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=1000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0

and Server.ini:

Code:

[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[VERSION]
VER=1299
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=midnighter.ath.cx
MAX_USER=2000
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=5000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0
[SG_INFO]
SERVER_INDEX=0
[MEMBER]
MEMBER=0
[GO]
THROUGH=0
[WXDZ]
WXDZ=0
[BATTLE2]
WEEK=5
START_TIME=20
END_TIME=0

OMEGAbuffer · Jun 19, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Maikeru said:

I can't see anything wrong in either file, here's GameServer.ini:

Code:

[TIMER]
YEAR=2008
MONTH=6
DATE=18
HOUR=7
WEATHER=1
[LOGIN SERVER]
IP=midnighter.ath.cx
[CASTLE]
NATION=1

[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=midnighter.ath.cx
SERVER_01=2
SERVER_IP_01=midnighter.ath.cx
SERVER_02=3
SERVER_IP_02=midnighter.ath.cx
SERVER_03=4
SERVER_IP_03=midnighter.ath.cx
SERVER_NUM=1
MAX_USER=2000
[BATTLE]
WEEK=6
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[AI_SERVER]
IP=midnighter.ath.cx
[DB_SERVER]
IP=midnighter.ath.cx
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=KN_online
Account_UID=knight
Account_PWD=knight
[VERSION]
VER=1299
[SG_INFO]
GMY_INFO=1
GSERVER_COUNT=1
GSERVER_00=1
GSERVER_IP_00=midnighter.ath.cx
SERVER_INDEX=1
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=1000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0

and Server.ini:

Code:

[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[VERSION]
VER=1299
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=midnighter.ath.cx
MAX_USER=2000
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=5000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0
[SG_INFO]
SERVER_INDEX=0
[MEMBER]
MEMBER=0
[GO]
THROUGH=0
[WXDZ]
WXDZ=0
[BATTLE2]
WEEK=5
START_TIME=20
END_TIME=0

Try using your computer IP. For the Login Server//Version.ini, put the IP you get from "whatsmyip.org". For the Ebenezer//GameServer.ini, look near the top section for the Login Server IP, and put that as the "whatsmyip.org" IP. Then, go through each other IP in your INIs and change them into the IP you get from going to "Run->cmd->ipconfig".

That's what I did to get mines local.

hehefu · Jun 19, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Name - TCP/UDP - Port#

Battlefield Connections - TCP/UDP - 10040
Elmorad Connections - TCP/UDP - 10030
Game Server - TCP/UDP - 15100
Karus Connections - TCP/UDP - 10020
Login Server - TCP/UDP - 15001
UDP Backport - TCP/TCP - 8888
Web Server - TCP/TCP - 80
Listening Port - TCP/UDP - 15000

....sometimes need to ues tcp/udp 8080///

melo717171 · Jun 19, 2008

Re: [Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

Hi im from Tr and a file from filefront couldnt be downloaded at TR could you upload that jonnyssql up another share site :s ???

Welcome!

Directions for hosting a v.1299 KO Server using MSSQL 2005

Experienced Elementalist

Skilled Illusionist

Experienced Elementalist

~ksemer~

Initiate Mage

Newbie Spellweaver

Newbie Spellweaver

Initiate Mage

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Junior Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor