[Guide] Guide for Dummies/Noobs on server setup

Alright, i've had enough of all this new threads because of problems/questions that have already been solved or answered.

So i am gonna make a guide for dummies on how to set up your server and get it running. If your server doesn't work after you read this,

it means you have not followed carefully.


(This guide does not include IIS and registration page and router help)

Stuff needed


1. MSSQL


2. 0.97 server files


Password: ragezone

- Your Server files MUST be in D:/, if you do not have D:/

use the SUBST command - type SUBST /? into a Command Prompt for help


3. 0.97 client patch


Alright, if you want the 0.96y FULL client, proceed to this link

http://www.muchina.com/download/full.htm


-----

Setting up SQL



Run SQL Setup

Select "SQL Server 2000 Components"


1. Click "Install Database Server"


2. Click Next


3. Click dot in Local Computer and Next


4. Click dot in "Create a new instance of SQL Server,or install Client Tools" and next


5. Put name and company Click Next


6. Click Yes to Agreement


7. Click dot in Server and Client Tools and Next


8. Click tick in Default at top and Click Next


9. Click dot in Typical Click Next


10. Click dot in "Use the same account for each service.Auto start SQL Server Service"


11. Click dot in "Use the Local System account" Click Next


12. Click dot in "Windows Authenticatication Mode." Click Next


13. Click Next and install


When installed reboot so server starts.


-----

Restoring Database


1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager) and go to Databases.


2. Create a new database, name it MuOnline.


3. After that, right click on muonline database then click "Restore Database".


4. Click on "From Device" and then click on "Select Devices".


5. Click Add and then choose the destination of the backups to Restore into muonline.


6. Press OK 3 times to continue, then press the Options tab.


7. Tick "Force restore over existing database", check that the database files point below D:\MuServer\DB\ directory


8. Press OK to import the database.


9. Create another database, name it Ranking and restore the tables from Ranking database files, make sure the database files point below D:\MuServer\DB\ directory.

Do the same for the exdb database.


( IF YOU DON'T HAVE THE EXDB .BAK, THEN DON'T BOTHER DOING THE DATABASE FOR IT. )

-----

Adding Accounts


1. Open SQL Analyzer ( Start-> Programs -> MSSQL -> SQL Analyzer)


2. Choose MuOnline


3. Add this:


INSERT INTO MEMB_INFO (memb_guid,memb___id,memb__pwd,memb_name,sno__numb ,post_code,addr_info,addr_deta,tel__numb,mail_addr ,phon_numb,fpas_ques,fpas_answ,job__code,appl_days ,modi_days,out__days,true_days,mail_chek,bloc_code ,ctl1_code)

VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t est@test.com','question','answer','1','2004-1-1','2004-1-1','2004-1-1','2004-1-1','1','0','1')


INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name ,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_ Hour,Surplus_Point,Surplus_Minute,Increase_Days )

VALUES ('2005','1',1234,'$login','$nick',1,'7','6','3','6 ','6','2004-1-1 10:36:00','0' )


Change the values $login, $nick, $password to your desired one.

(IT IS 4 LINES IN TOTAL IN THE QUERY, 2 LINE FOR EACH)


-----

System DSN


1. Start Data Sources (ODBC) (Start -> Programs -> Administrative Tools -> Data Sources (ODBC)), go to System DSN tab then click Add.


2. Select the SQL Server driver(bottom) and click Finish. Choose MuOnline for Name and your SQL Server for Server.


3. Change the default database to muonline and click Next then Finish and OK.


4. Create also 3 more System DSN links named MuOnlineJoinDB, USELOG, Event that use muonline as the default database.


5. Create 1 System DSN named Ranking that use Ranking as the default database.


-----

Editing IP Address and Setting up Server Files


1. Type ipconfig /all in command prompt to check your ip.


2. Change all the ip addresses (127.0.0.1) found in config files to your ip address.

IP Addresses can be found in the following files:


D:\MuServer\CS\Connectserverlist.dat

D:\MuServer\CS\data\Connectserverlist.dat

D:\MuServer\CS\data\ServerList.dat

D:\MuServer\data\commonserver.cfg

D:\MuServer\data\IpList.dat

*D:\MuServer\data\lang\eng\commonloc.cfg

*D:\MuServer\data\lang\kor\commonloc.cfg

*D:\MuServer\data\lang\tai\commonloc.cfg

*D:\MuServer\data\lang\chi\commonloc.cfg


(*may not apply to all)


3. Change the IP Addresses found in 5.lnk* and 9.lnk* files below D:\MuServer\Links folder(right click on them and select properties) to your own. (*links may defer.)


4. Edit D:\MuServer\MU2003_EVENT_SERVER\DATA\svconfig.ini and change "mu2003_dsn = DEVILSQURE_RANKING" to "mu2003_dsn = Ranking" and edit also D:\MuServer\RankingServer\svconfig.ini changing "odbc_dsn=DEVILSQURE_RANKING" to "odbc_dsn=Ranking"


-----

Connecting to your Server


There are 2 ways as to how you can connect to your Server:


1. Edit your partition in your client files.


2. make a shortcut from your "Main.exe"


right click it and select properties


in "Target:" put all below including the "


and change the 123.456.7.8 for the ip u want to join


and run the shortcut


"C:\Program Files\Webzen\Mu\main.exe" connect /u123.456.7.8 /p44405





Hope this can help anyone new to private servers and it's setup process.


ADD-ON


If anyone is having this error:


Server: Msg 544, Level 16, State 1, Line 1

Cannot insert explicit value for identity column in table 'MEMB_INFO' when IDENTITY_INSERT is set to OFF.

Server: Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PK_VI_CURR_INFO'. Cannot insert duplicate key in object 'VI_CURR_INFO'.

The statement has been terminated.


Do this:


add SET IDENTITY_INSERT MEMB_INFO ON at the top like this:



SET IDENTITY_INSERT MEMB_INFO ON

INSERT INTO MEMB_INFO (memb_guid,memb___id,memb__pwd,memb_name,sno__numb ,post_code,addr_info,addr_deta,tel__numb,mail_addr ,phon_numb,fpas_ques,fpas_answ,job__code,appl_days ,modi_days,out__days,true_days,mail_chek,bloc_code ,ctl1_code)

VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t est@test.com','question','answer','1','2004-1-1','2004-1-1','2004-1-1','2004-1-1','1','0','1')


INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name ,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_ Hour,Surplus_Point,Surplus_Minute,Increase_Days )

VALUES ('2005','1',1234,'$login','$nick',1,'7','6','3','6 ','6','2004-1-1 10:36:00','0' )



for VI_CURR_INFO, go to the table of VI_CURR_INFO, right click, select design table, remove the key sign and everything shall work fine


PS: REMOVE THE "$" FROM THE $LOGIN, $PW, $NICK YOU HAVE EDITED/CHANGED