[Guide] Howto: Install RAN Online With Pictures.

[austhistikated]

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])
http://www.microsoft.com/downloads/d...displaylang=en

MSSQL 2005 Express
http://go.microsoft.com/fwlink/?LinkId=65212

SSMSE
http://go.microsoft.com/fwlink/?LinkId=65110

Common Sense
www.google.com
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


Then click next...



Then click install...



Then click next again...



Then click next again...



Then click next again...



Then click next again...



Then click next again...



Then click next again...



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...



Then click next again...



Then click install...



Then click next again...



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



Then click next...



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



Then click next again...



Then click next again...



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

----------

I'll continue this guide on the next post...

[MentaL]

[austhistikated]

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:


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...

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...

Click add...
Once you have clicked add button...
You should have something like this...

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...

Then click ok...
After clicking ok...
Right click database again and click New Database...
It should look something like this...

Now you should have something like this...

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...

Now download the backup file from this site...
http://files.filefront.com/RanShopra.../fileinfo.html
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...

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...

Then click add...
Then you should have something like this...

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...

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...

[livewirecebu]

Thanks I'll try this guide now!

[Manipulator]

Uh...what's wrong with using the original RanShop.mdf that came with the first 3 databses? Why the need for this special one?

[livewirecebu]

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

[borgborg]

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?

[austhistikated]

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...
^_^

[Manipulator]

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. ;)

[livewirecebu]

me always noob...I admit my fault..as a result to stupidity...nah sorry dude!

[trixxx12]

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....

[austhistikated]

Hmm...
I also used personified's repacked files...
But I haven't encoutntered that kind of problem...
Hmmm...

[cheriray02]

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.

[austhistikated]

Well about that error...
Try using the data I have uploaded...
It was posted on personified's Playing Episode 2 topic...
Just try that...
Maybe that will help...

[shakarl14]

Hi how do i fix d problem wid a pop up that say m_buffer........ and appears so many times thanx =) in advance

[Keith]

nice guide, sticked for now.

[trixxx12]

@ 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

[austhistikated]

I installed MSSQL 2000 EVAL first...
Then MSSQL 2000 sp4...
Then MSSQL 2005...
Then SSMSE...
^_^

[trixxx12]

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

[livewirecebu]

Use the MSSQL 2000 to restore/Attach ur database...

[austhistikated]

@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...
^_^

[jiacheng1991]

austhistikated
in nhed guide it says need to instal mssql2000 and mssql remote desktop....
and ur guide there izzit complete or wad i do next?

[livewirecebu]

just install the the SQL driver...and I suggest to use mssql2000 much more easy..

[austhistikated]

@jiacheng1991

I haven't installed remote desktop...
But it's running fine for me...
Remote desktop I think is only for GM's...
To have access to server even they are afar from it...

[livewirecebu]

Remote Desktop is for the GM that are not the Owner of the Server...austhistikated is right...

[dopperB]

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 got the same situation..is it the file problem or the database problem?

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 got the same situation..is it the file problem or the database problem?

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 got the same situation..is it the file problem or the database problem?