Saturday, May 26, 2018

Dragon Raja Setup Complete for MSSQL 2000

Dragon Raja server installation guide by: FiberOptics

First off, you will need to download the files to setup a server located at: ttp://www.mediafire.com/file/azlpcrgc61yf96b/drserver-03-08-2014.rar/file

Next, you will need to download Microsoft SQL Server located at: http://www.microsoft.com/downloads/d...displaylang=en

Once you have downloaded the server files, extract them to your C: drive. (To make it so there is less to do, extract it so that the absolute path to your server is: C:\drserver).

Once you have done that, it is time to install MSSQL. To install the Database (once it is downloaded), extract the downloaded file to anywhere on your computer. It will create a folder called SQLEVAL, go into this folder and open AutoRun.exe.
Next, click "SQL Server 2000 Components." After that, choose "Install Database Server." The first thing it will ask you is if you want it to run from. Keep it at default, Local Computer. The next step, choose "Create a new instance of SQL Server," then click Next. The next step just click Next again. Next step is just the TOS, just click Yes. The next step will ask you what you want to instal, choose the middle option, "Server and Client Tools." The next step will ask you if you want to create a default installation or create a new instance. Keep it at "default," then click Next. The next step asks what type of installation you want, just keep it at typical and click next. The next step, just click "Use the local system account under Service Settings, then click Next. The last step asks you for an authentication mode, keep it at default "Windows authentication mode then click Next. Click Next once again. Now you have your SQL Server setup.

Now once you are done setup, your database should be correctly setup. To make sure it is started, go to Start > All Programs > Microsoft SQL Server > Service Manager. Once Service Manager is opened, click the green arrow. If the arrow is greyed out, then it should already be running. Now you have to setup your database for the Dragon Raja server. To do this, click Start > All Programs > Microsoft SQL Server > Enterprise Manager. 

Once the Enterprice Manager opens, double click Microsoft SQL Servers in the left pane (or just click the plus sign), then click the plus for the SQL Server Group, lastly click the plus once again for the actual database server. Now you are going to have to create your three databases for the Dragon Raja server. To do this, right click Databases and choose "New Database" and type DragonRajaDB then click OK. Do this for the other two databases that are associated with the Dragon Raja server files (the other two are ChrLogDB, and TotalDB). 

Right click the newly created DragonRajaDB, go to All Tasks, then click Restore Database. Once the Restore Database dialogue boxs pops up, click the "From device" radio button. After that is done, click "Select Devices," once that is done click "Add." When the Add box pops up, click the ellipses button (the ... button). Now it will bring up a box to choose the database files, these files are located (if you installed your server to C:\drserver), they are located in C:\drserver\data\DATABASENAME. Now since you are restoring the DragonRajaDB, choose the DragonRajaDB and click OK, then OK once again. Now you will be back at the first dialogue box, click the options tab at the top and make sure "Force restore over existing database" is checked. Then you have to make sure the FIRST "move to physical file name" field, points to your 
C:\Program Files\Microsoft SQL Server\MSSQL\Data\NAME_Data.MDF (Where NAME equals the database you are restoring. For example, since we are currently restoring DragonRajaDB, you need to make sure your physical file name is pointed to C:\Program Files\Microsoft SQL Server\MSSQL\Data\DragonRajaDB_Data.MDF). Next there is a second field under "Move to physical file name." Make this second field point to 
C:\Program Files\Microsoft SQL Server\MSSQL\Data\NAME_Log.LDF (Since we are working with DragonRajaDB, make the name in the path DragonRajaDB_Log.LDF. Once this is done, click OK and it should restore.

Do the previous paragraph again, except substitute anywhere that it says: DragonRajaDB for ChrLogDB. Once that is done do the previous paragraph yet once again, except do it for TotalDB. 

Now we need to set up your ODBC. Click Start > Control Panel > Administrative Tools then double click Data Sources when the box opens, click the tab that says: System DSN, then click "Add," then choose SQL server from the scroll down box then a box will pop up with "Name, Description, and Server." For Name type DragonRajaDB, for description type anything and for server, hit the scroll down and choose your SQL server (you can choose local if you want) then click Next until you hit a box that at the top it says "Default database," when this appears, scroll down to the right database (since we are configuring the DragonRajaDB System DSN, choose DragonRajaDB from the scroll down list as a default database... Click next until your done. Do this for the other Databases (TotalDB and ChrLogDB).

Once this is all done, you have your Databases correctly setup (hopefully). Next we move on to configuring the server files with the correct IP Address information. Open up your C:\drserver folder, then open the folder called PROXY. Once the PROXY folder is opened, open the proxyserver.ini file in notepad. Now you have to change all of the IP Addresses to your own (Open start, then run, then type cmd. Once the CMD prompt opens, type IP Config, it will then give you your IP Address). Once you edit all of the IP addresses then save the file and close it (A fast way to edit the IP's is to click Edit, then Replace, in "Find What, type 192.168.1.4, in the Replace field, type your own IP address, then click replace all). Now once you have closed that file, go to the DBDemon directory located in your main drserver directory. Open DBDemon.ini and do the same thing as previously done with the proxy .ini file; edit all of the IP's to your IP (again, you can use the replace method). Once this file is saved go to the Agent directory in the main directory of your drserver folder. Open the agentserver.ini file in notepad and edit all of the IP's, then save and close it. Now go to the map folder in your main drserver directory and open mapserver.ini, edit all the IP's then save and close it. Now in that same directory you will see folders named as numbers such as: 5000, 5580, 5610, ect. These folders are just other maps. Now once all of the editing of the server is done, go to your main drserver directory and load up in this order; Proxy.exe located in Proxy folder (you will have to wait until the proxy server FULLY loads, it takes about 3 minutes to fully load. You will know when it fully loads because it stops broadcasting stuff on the prompt), DBDemon.exe located in the DBDemon folder, Agent.exe located in the Agent folder, finally, the mapserver.exe located in the map folder or any of those numbered sub folders in the map folder.

Now you should have a fully running server (taken that you didn't get any errors).


I promised I would fix this guide up, sorry, I've been sick the last couple weeks

No comments:

Post a Comment