[Guide] Installing Thor Server with MSSQL [V9]

[Dimii15]

Hello RaGEZONERS,

Welcome to my guide on how to use Thor Server by Adus aka Joeh, one the most stable Habbo V9 servers ever.

Before you begin
Make sure WinRAR, XAMPP, Framework 4 and the MySQL ODBC driver have been installed and you know how to use them.

Framework 4: dotNetFx40_Full_setup.exe
XAMPP 1.7.4: Download XAMPP from SourceForge.net - Make sure the three boxes of the three services are unchecked.

Search, download and install WinRAR and the MySQL ODBC driver yourself via Google since they're available in both 32-bit and 64-bit. I know Thor uses MSSQL but just install the MySQL ODBC driver for assurance.

Download the following applications too (without installing):

MSSQL 2008 R2 Express (select 32-bit or 64-bit): SQL Server 2008 R2 Express - Overview
Thor Server: thorserver.rar
V9 client: v9_client.rar

Installing Microsoft SQL Server 2008 R2 Express
1. Open the installer and select New installation or add features to an existing installation.
2. Accept the license terms.
3. Install all features.
4. Choose Default Instance.
5. During Server Configuration choose Use the same account for all SQL Server services.
7. Fill in the username and password of your Windows user account, click OK and click Next.

Note: This username doesn't always have to be the same username you're currently using, go to C:\Users (or C:\Documents and Settings in Windows XP) to find out what's your real username.

8. Choose Mixed Mode, setup a password for the SQL Server admin account and click Next.
9. After a few minutes MSSQL 2008 R2 should be installed.

Creating the database
1. Go to Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
2.

Server name: (local)
Authentication: SQL Server Authentication
Login: sa
Password: <the password you've setup at step 8 from installing SQL Server>

Click Connect.

3. Right-click on Databases and click New Database...
4. Fill at Database name in: thor and click OK.

Registering Thor as a Windows service
1. Open thorserver.rar and drag the folder thor to C:\
2. Go to Start > All programs > Accesoires > Command Prompt

Note: When using Windows 7, always use right-click > Run as administrator when opening the Command Prompt.

3. Copy/paste when using 32-bit: cd C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319 OR 64-bit: cd C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319
4. Copy/paste: InstallUtil C:\thor\ThorServer\bin\release\ThorServer.exe
5. A window should pop up, fill at username your computername and windows user account in so for example: ASUS\Dimii15 and at password the password of your windows user account of course.
6. After a few seconds you should get a message like "The Commit phase completed successfully" and "The transacted install has completed."

Finishing
1. Open SQL Server Management Studio again and connect.
2. Right-click on the created database "thor" and click New Query...
3. Open Schema.sql with Notepad which is located in: C:\thor\ThorServer\Data
4. Copy everything into the new query in SQL Server Management Studio, press F5, wait till it's executed and go to File > Save All.
5. Go to C:\thor\ThorServer\bin\Release and open Settings.conf with Notepad.
6. Change #Database Settings to the following:

DatabaseName=thor
DatabasePassword=<the password you've setup at step 8 from installing SQL Server>
DatabaseServer=.
DatabaseUser=sa

Save.

7. Open v9_client.rar and drag the folder client to C:\xampp\htdocs
8. Open the Command Prompt again and enter: net start "Thor Server"

Thor should be running now.

9. Start XAMPP Control Panel and start Apache.
10. Go to http://127.0.0.1/client and Thor Server should be working!

Managing database
1. Open SQL Server Management Studio and connect.
2. Expand the database thor.
3. Expand Tables.

Here you see the items, if you want to edit an item just right-click and choose Edit Top 200 Rows.

Thanks for reading and credits to Adus aka Joeh for his included tutorial.

[Subway]

Omg Thor server 1st server made nice tutorial ;]

[Hejula]

Looks awesome, however the housekeeping for this is coded in ASP which requires IIS, so the housekeeping wont work on XAMPP.

[Dimii15]

Looks awesome, however the housekeeping for this is coded in ASP which requires IIS, so the housekeeping wont work on XAMPP.

I couldn't even debug Housekeeping, but I'll a take look on that later. ;)

[Putako]

Thanks Bra, I figured this out myself already >.> but thanks..

[Dimii15]

Does anyone know what Visual Studio version is needed to run ThorHousekeeping? Tried Visual C# 2005, 2008 and 2010 so far. It says that it was made with an older version...

[ntl200]

it was made in c#...

listen to hejula...


add iis into this tutorial then it will be 100%

[Dimii15]

Ok I'm using IIS and I'm getting this error when trying to access Housekeeping (translated with Google Translate):

=====================================================
Server Error in Application /.

Parser Error

Description: An error occurred while parsing a resource required to comply with this request. See the following details of the parsing error and only the source file where necessary.

Parser Error Message: Could not load type ThorHousekeeping.Global.

Source Error:


Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="ThorHousekeeping.Global" Language="C#" %>

Source File: / global.asax Line: 1

Version Information: Microsoft. NET Framework Version: 2.0.50727.5444; ASP.NET Version: 2.0.50727.5420
==========================================================

I haven't setup anything myself so far, what should I edit?

[Hejula]

The housekeeping works fine for me... you must remember when you are on the IIS Manager, right click on the directory in the wwwroot (in the iis manager) and press create application. As ASP is an application the folder must be defined as a directory.

[Dimii15]

The housekeeping works fine for me... you must remember when you are on the IIS Manager, right click on the directory in the wwwroot (in the iis manager) and press create application. As ASP is an application the folder must be defined as a directory.

I haven't got many experience with IIS and ASP so I could use some help. :)

Ok so I moved the content of "ThorHousekeeping" to "wwwroot". When saying "create application" you mean this one right?



Is there also anything else that I must setup or have running to get housekeeping to work?

Here's once again the error that I'm getting:



Thanks in advance.

[Mithex]

See, I just don't get it. Why would you make a server called Thor! I know why! Its so difficult to use!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Its old school. Great tutorial, I just don't get why someone would use Thor.

[Hejula]

See, I just don't get it. Why would you make a server called Thor! I know why! Its so difficult to use!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Its old school. Great tutorial, I just don't get why someone would use Thor.

Difficult for total noobs, yes. Difficult for someone who understands the concept of MSSQL, no. I say MSSQL as that is where most people fall when setting this up. Why would you use this? Maybe because it has the best pathfinding ever made. Maybe you just want a nice *unique* V9 retro.

[Mithex]

Okay.

[Dimii15]

Does anyone of you know how to solve this? Help please!

[Putako]

Does anyone of you know how to solve this? Help please!

Asking for help on your own tutorial thread? Suspicious..