[Tutorial] Making Kal Server in MSSQL 2005

[PostOfTheYear]

Making Kal Online in MSSQL 2005 for noobs​

__________________________________________________
1.)Downloads

• Microsoft .NET Framework 2.0 (dotnetfx.exe)
• MSSQL 2005 Express Edition
• MSSQL Management Studio Express
• Kal Client mirror by Dopestar
• Server Files by Exitium
• Client Files by Exitium
• Databases
• Server and Client Tools by Dopestar

__________________________________________________
2.)Database

• Open MSSQL Managemen Studio Express
• Right click the database folder.
• Click New Database.
• Put in the name "kal_db".
• Right click again database folder.
• Click Restore Database.
• Type in the column named "To database", put kal_db.
• Click the circle named "From Device".
• Locate kal_db - MSSQL 2005.bak.
• Go to Options tab.
• Click the box named "Overwrite the existing database".
• Click ok.
• Note:Same procedure with kal_auth database.

__________________________________________________
3.)Data Sources (ODBC)

• Go to control panel.
• Click "Switch to Classic View" (Unless your already in it).
• Double Click "Administrative Tools".
• Open "Data Sources (ODBC)".
• Go to User DSN tab.
• Click Add.
• Select SQL Server
• Put in the Columns

Name:kal_db
Description:Anything
ServerC name​

• Click Next double times.
• Check the box "Change the default database to".
• Select kal_db.
• Click next after its finished and click ok on the pop-up.
• Note:Same procedure with kal_auth.

__________________________________________________
4.)Going back to the kal_db

• Expand Tables Folder.
• Right click "dbo.Item".
• Click Design.
• Check the box in Info column.
• Click the arrow on the left side.
• Then go exit.

__________________________________________________
5.)Client Setup

• Install Old Kal Client.
• Overwrite it with the Client Files.
• Change the IP of the client or something.

__________________________________________________
6.)Starting the Server

• Extract the Server Files (Password is kalzone.de).
• go to the server folder and start login(first) ,database(Second), mainserver(Last).

__________________________________________________
7.)Creating an Account manually

• Open the Server and Client Tools folder.
• Open the folder named "KOAM (account maker)".
• Open the Application.
• Follow the instructions then your done!

__________________________________________________

Please post an information of whats wrong on my guide

 

[Dopestar]

Re: [Guide]Making Kal Server in MSSQL 2005

you cant make an account manually in the database

 

[PostOfTheYear]

Re: [Guide]Making Kal Server in MSSQL 2005

I'll try to unlock the secret to create it manually.
Because I can't open the tool to create an account in the repack you shared because my antivirus blocks it .

 

[Boarderkoen]

Re: [Guide]Making Kal Server in MSSQL 2005

You can always use my Kal Online Admin Panel's SQL Part...

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

 

[Shortor]

Re: [Guide]Making Kal Server in MSSQL 2005

Should i make a guide on how to install MSSQL 2008? It's all the same ffs. After i installed MSSQL 2000 i could install 2005 and 2008 without any guide or what so ever.

 

[PostOfTheYear]

Re: [Guide]Making Kal Server in MSSQL 2005

You can always use my Kal Online Admin Panel's SQL Part...

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

@offtopic
Can you mirror it for me in MediaFire
because Rapidshare won't let me download it.

 

[Dopestar]

Re: [Guide]Making Kal Server in MSSQL 2005

http://www.mediafire.com/?sharekey=e6336b01abb21ed7d2db6fb9a8902bda

 

[PostOfTheYear]

Re: [Guide]Making Kal Server in MSSQL 2005

Thanks, please close this thread to prevent unnecessary spam.

 

[Desi84]

can someone upload kal client the old one please

 

[KFredje]

can someone upload kal client the old one please

http://forum.ragezone.com/f315/list-client-server-files-385377/

 

[dietaah]

hi i heve a error who cane help me
in need SQL Server Database Services 10.0.1600.22

 

[MaximumSatan]

hi i heve a error who cane help me
in need SQL Server Database Services 10.0.1600.22

Goggle it.. you will find it then.

 

[ricow]

The sql2005 64bit version where can i find that ?

 

[Boarderkoen]

Use the ole friend google

 

[originaldo]

Hey, I have problem with MSSQL 2005,

First I installed Management Studio Express, then MSSQL 2005 and everytime I double click Management Studio, my pc freeze and reboot. Same happens when I want to uninstall everything.

Second time, after reinstalling windows, I was installing MSSQL 2005 and on the end of installation process my pc rebooted, after reboot when windows loaded, it rebooted again, and again, I needed to reinstall windows again to get rid of MSSQL...

I created server 2 years ago but with older MSSQL, with another guide here on ragezone.
Can I use any other version of MSSQL with this guide?

 

[Fleetaks]

Hey, I have problem with MSSQL 2005,

First I installed Management Studio Express, then MSSQL 2005 and everytime I double click Management Studio, my pc freeze and reboot. Same happens when I want to uninstall everything.

Second time, after reinstalling windows, I was installing MSSQL 2005 and on the end of installation process my pc rebooted, after reboot when windows loaded, it rebooted again, and again, I needed to reinstall windows again to get rid of MSSQL...

I created server 2 years ago but with older MSSQL, with another guide here on ragezone.
Can I use any other version of MSSQL with this guide?

Just use MSSQL 2000

 

[originaldo]

Thanks Fleetaks, Im just working on my server while Im writing this post.
I had problem in "Restore database" with databases from starting post, but databases in server tools 2.1 are working for me.
Anyone knows what is the difference between those two databases? I just want the newest G65 dragon items in my game.

 

[originaldo]

Now when I start game, I have there list of official servers, but if I start Hanin for example, a message appears:

http://www.mypicx.com/07082009/server/

How to connect to my server? I typed my IP in server.ini but didnt help.

 

[pijanc1]

Now when I start game, I have there list of official servers, but if I start Hanin for example, a message appears:

http://www.mypicx.com/07082009/server/

How to connect to my server? I typed my IP in server.ini but didnt help.

did u change ip in config.pk and kalonline.cfg and hex kalonline.exe?

 

[originaldo]

Im trying to change IP and server name in config.pk but it dont let me do it, I found topic How to connect own server, but there isnt all info needed.