[RELEASE] Setting UP SOF Server (With pictures)

[Liselotte]

This will guide you through setting up your first SOF Server.

Things you got to have before setting up SOF Server:

• Server Files
• Client
• Launcher
• SQL Server 2000 or 2005 (i recommend 2000)

Download Links:

Server Files:

To view the content, you need to sign in or register

Client:

To view the content, you need to sign in or register

NOTE: use any Download Manager to download the client faster than browser.

SQL 2000:

To view the content, you need to sign in or register

next time no warez

Now, lets start by Restoring the Database.

Hit "Start>All Programs>Microsoft SQL Server>Enterprise Manager" then expand the + sign (see pic below for result)

PIC:

To view the content, you need to sign in or register

Now we need to restore the database.

Database Name:

rxjhaccount
rxjhgame
rxjhweb

Right Click "Database>New Database" (see pic below)

Pic:

To view the content, you need to sign in or register

A new window will pop-up. Now put "rxjhaccount" for database name and hit "OK".
repeat this step till you have 3 database.

Now we need to restore the database.

Right Click any of the database you just create, and hit "All Task>Restore Database" (see pic below)

Pic:

To view the content, you need to sign in or register

Now follow the pic below:

To view the content, you need to sign in or register

Now hit "OK" 3 times. Then Click Options Tab and change the path where the database log gonna be restored. Make sure the patch exist on your computer. See pic below

Pic:

To view the content, you need to sign in or register

Then hit "OK".
Repeat the same step till you restore all the databases(3).

Now expand the databases that you just created. click "Users" and make Right CLick and select "New Database User" and follow the PIC below

To view the content, you need to sign in or register

and see another one below:

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

Hit "OK" 2 times and repeat the step on other database.

Now we are done. make sure you remember the info that you have just configure.

Open GameServer.ini:

[ODBC]
;Account Database DSN and SQL Pass settings
ACCOUNT_DSN = rxjhaccount
ACCOUNT_UID = 51rxjh
ACCOUNT_PWD = [COLOR=Red][B]SQL Password[/B][/COLOR]
;Character Database DSN and SQL Pass settings
CHAR_DSN = rxjhgame
CHAR_UID = 51rxjh
CHAR_PWD = [B][COLOR=Red]SQL Password[/COLOR][/B]
;Web DSN and SQL Pass settings
WEB_DSN  = rxjhweb
WEB_UID  = 51rxjh
WEB_PWD  = [B][COLOR=Red]SQL Password[/COLOR][/B]

change SQL Password to your settings.

Open ServerLogin.ini:

[ODBC]
ACCOUNT_DSN = rxjhaccount
ACCOUNT_UID = 51rxjh
ACCOUNT_PWD = [B][COLOR=Red]SQL Password[/COLOR][/B]

change SQL Password to your settings.

Open LoginData\server.inf:

 

[Guerreiro]

Re: [Guide]Setting UP SOF Server

Thanks stupid question will navicat work for the database stuff

 

[thejaguar1]

Re: [Guide]Setting UP SOF Server

OMG. I thought your only in MuOnline Section. lolz
Your are magnificient.

Tnx for the guide and english servergame.ini

Respect

 

[vitormaskara]

Re: [Guide]Setting UP SOF Server

Good Job...
Delete my topic ^.^

 

[thejaguar1]

Re: [Guide]Setting UP SOF Server

Need help here.
When I tried to restore the files, it says:
File 'rxjhaccount_Data' cannot be restored to 'D:\Scion of Fate\data'. Use WITH MOVE to identify a valid location for the file.
File 'rxjhaaccount_Log' cannot be restored to 'D:\Scion of Fate\Scion DB', Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.

Tnx.

Respect

 

[Liselotte]

Re: [Guide]Setting UP SOF Server

Thanks stupid question will navicat work for the database stuff

nope

 

[kawasumi.hong]

Re: [Guide]Setting UP SOF Server

And the requeriments do run and play on your server?

 

[thejaguar1]

Re: [Guide]Setting UP SOF Server

Ok. I made it run.
Tnx.
Btw, how to make an account here?

Respect

 

[Magenik]

Re: [Guide]Setting UP SOF Server

OMG an other server i go test woot thx for this ^^

I setup Server on a dedi temp so ppl can test
It will be a temp server for testing waaa hope it's work ^^

 

[Xsword]

Re: [Guide]Setting UP SOF Server

Thanks, good setup help

 

[Zaruna]

Re: [Guide]Setting UP SOF Server

Um i did this already but when i try to login it always say "account doesnt exist" ( And yes i made a account)

 

[BoneDragoN]

Re: [Guide]Setting UP SOF Server

if u know how to make a mu server then u know to make and that^^ Nice liselotte Thnx!

P.S can anyone post some pics of the game? xD

 

[Zaruna]

Re: [Guide]Setting UP SOF Server

Wow what a good answer not everyone like's that sucky game.

 

[BoneDragoN]

Re: [Guide]Setting UP SOF Server

Wow what a good answer not everyone like's that sucky game.

Mu is a sucky game? omg^^ sucky is ur head!

 

[BoneDragoN]

Re: [Guide]Setting UP SOF Server

Wich ports i must free from my router to open the server? thnx

 

[Zaruna]

Re: [Guide]Setting UP SOF Server

Sorry..

 

[evill33t]

Re: [Guide]Setting UP SOF Server

a sql express edition works fine so no need for a full mssql warezed version

 

[bazthy]

Re: [Guide]Setting UP SOF Server

@evill33t
can u share how u setup SOF in sql express. coz im having problem in entering in realm world i can login and i can see realm but nothing happen when i ckick the realm address.
buy the way im downloading rxjh 17100 version coz i use english version and patched with chinese version whisch is posted here maybe this is my last hope to make it work im not sure if this one gonnna work

And of course my OBDC are set up properly ive try both in native client version = failed
and also i tried it in SQL server mode failed = same problem cant connect r realm
last resort client change

 

[Faizan]

Re: [Guide]Setting UP SOF Server

Have to say, an impressive guide liselotte. I got some staggering results

 

[Taishiro]

Re: [Guide]Setting UP SOF Server

Offtopic:
BoneDragoN please dont double post.


Bazthy - Make sure you have your ODBC's setted up.