Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide] Howto: Install RAN Online With Pictures.

Status
Not open for further replies.
Joined
Dec 21, 2005
Messages
833
Reaction score
20
Well...
For all the noobs out there...
And if you want to set up RAN Server...
Hope this guide helped you out...
Anyway...
First...
The things you need...
  • Server Files
  • .Net Framework 2.0
  • MSSQL2005 EXPRESS
  • SSMSE
  • Common Sense (as nhed57 specified before)

----------

Here's The link to the programs needed:

Server Files
This is where common sense will take place...
You have to use this to improve yoiur common sense skills...
Anyway...
Refer from stickies for server files...

.Net Framework 2.0 (dotnetfx.exe[filename])


MSSQL 2005 Express


SSMSE


Common Sense

http://forum.ragezone.com/search/

----------

Now...
After downloading the needed files...
Lets install first the MSSQL 2005 Express Edition...
I have here step by step pic...

MSSQL 2005 EXPRESS EDITION SETUP

austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click install...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then choose mixed mode...
Then input the password for your sa login in the two box below...
You should remember this password very well...
For this is a very important component of the setup...
Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click install...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click finish...

----------

Now after installing MSSQL 2005 EXPRESS EDITION
We are going to install SSMSE
Here's a step by step guide for installing SSMSE...


SSMSE INSTALLATION SETUP


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then choose I accept the terms in license agreement...
Then click next...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click next again...


austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click install...
After installation is complete...
Click finish...

----------

I'll continue this guide on the next post...
 
Last edited:
Joined
Dec 21, 2005
Messages
833
Reaction score
20
2nd part of guide...

Now we are going to connect to MSSQL...
Click Start>>All programs>>Microsoft SQL Server 2005>>SQL Server Management Studio Express...
Then you should see something like this:

austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now you have to remember the server name...
We're going to use that later...
Now login using the "sa" username and the password you input on the installation...

Now... If you're already connected....
You should see this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

If you see this...
Well Successful...
If not...
Remember the password you input before...
Now right click database and click attach...
Once done you should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Click add...
Once you have clicked add button...
You should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now attach the databases...
Rangame1P_data.mdf
RanLog_Data.mdf
RanUser_Data.mdf
Don't attach RanShop...
I'll explain later why not...
Now after you attached those 3 databases...
You should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click ok...
After clicking ok...
Right click database again and click New Database...
It should look something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now you should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now name the database as "RanShop"
Now you should have by now the database RanShop...
Now right click RanShop database...
And click Tasks>>Restore>>Database...
Like This...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now download the backup file from this site...

Taken from CiMeD...
Credits to CiMeD...
After you download that file...
Extract it to any location you like...
After extracting it...
Let's get back to MSSQL...
Now you should have something like this if you followed the earlier step...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Choose "From Device"...
Then click the button on the right with the 3 dots...
Now if you click the button with 3 dots...
You should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click add...
Then you should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Now browse for the RanShop Backup I told you to download earlier...
Now after you locate the backup file...
Click ok...
Then you should have something like this...
austhistikated - [Guide] Howto: Install RAN Online With Pictures. - RaGEZONE Forums

Then click Options...
Below General...
On the left panel of the window...
And chosse "Overwrite the existing database" and click ok...
Now we are finish setting up the MSSQL...
Setting ODBC is next...
 
Last edited:
Experienced Elementalist
Joined
Apr 3, 2006
Messages
223
Reaction score
13
Uh...what's wrong with using the original RanShop.mdf that came with the first 3 databses? Why the need for this special one?
 
Experienced Elementalist
Joined
Jul 30, 2004
Messages
209
Reaction score
2
Manipulator said:
Uh...what's wrong with using the original RanShop.mdf that came with the first 3 databses? Why the need for this special one?


READ CAREFULLY the Guides bro...(Guide by: austhistikated) U miss the RanShop.MDF part read carefully...Im doing my client side now.!GOod LuCk
 
Initiate Mage
Joined
Jun 1, 2006
Messages
2
Reaction score
0
i can't connect to the "SQL Server" - that's my server name. do i need to have an internet connection to be able to connect using SQL Server Management Studio Express?
 
Joined
Dec 21, 2005
Messages
833
Reaction score
20
I used CiMeD's RanShop...
For you guyz not to edit it when you're going to put webserver...
It's more likely a preparation for it...
^_^
Cause if your going to put up a webserver...
You're going to insert a lot of items in old database...
But using CiMeD's backup...
No need to input all the items in RAN Shop...
^_^
 
Experienced Elementalist
Joined
Apr 3, 2006
Messages
223
Reaction score
13
livewirecebu said:
READ CAREFULLY the Guides bro...(Guide by: austhistikated) U miss the RanShop.MDF part read carefully...Im doing my client side now.!GOod LuCk
LOL... I did read the guide.
But that's NOT the reason for my post . Perhaps you should READ my question carefully yourself. :D

Anyway... austhistikated answered my inquiry to my satisfaction. That's the reply I was expecting. ;)
 
Initiate Mage
Joined
Aug 13, 2005
Messages
3
Reaction score
0
bro can u help me with this problem
i followed your guide but i have this problem on my sql database

my attachments seems to be read only... like this RanGame1 (Read Only)
as well as the other database attachments
i cannot edit any of it on the database tables coz it's read only..
i used personified server-repack

i also tried the data from original sodou.com download..
but it cannot be attached coz it says that "the db is read only or some files are read only"
what should i do with this?

thanks in advance....
 
Initiate Mage
Joined
May 22, 2006
Messages
2
Reaction score
0
Hi, i have this error when i run field_0 and the error is "period file open fail"

can someone help me to fix this? i already download the data.rar in some other threads but still got these error. thanks in advance.
 
Initiate Mage
Joined
Aug 13, 2005
Messages
3
Reaction score
0
@ Topic Starter

bro didn't you installed sql 2000+analysis then sp 4 then sql 2005
before you attached your database? just curious.. coz i think that is
the way to fix the "read only" thing if you installed sql 2005 + SSMSE alone
 
Initiate Mage
Joined
Aug 13, 2005
Messages
3
Reaction score
0
austhistikated said:
I installed MSSQL 2000 EVAL first...
Then MSSQL 2000 sp4...
Then MSSQL 2005...
Then SSMSE...
^_^

i suggest you include that on your guide that you have installed sql 2000 and sp4 first
before sql 2005 express... coz readers might have problems on the "read only" thing...
as for me i only installed msql 2000 then used the data files from sodou and the
ranshop.bak from the other threads here :D my server is working smoothly and i havent
found bugs yet except for the last 2 skills of each character.. i guess it will work on
EP2 as i am already working on it :D
 
Joined
Dec 21, 2005
Messages
833
Reaction score
20
@trixxx12
You can also use MSSQL 2005 EXPRESS & SSMSE w/o MSSQL 2000...
I already tried it and have'nt encounter the problem with read-only thingies...
I only encounter problem in webserver...
That's why I installed MMSQL 2000...
Anyway...
That's what I thought that's why I have'nt include MSSQL2000 as a part of your installation...
Am sorry...
My bad...
^_^
 
Status
Not open for further replies.
Back
Top