HowTo: Setup Polar HelpDesk manually

Polar HelpDesk is a web application that runs on Internet Information Services (IIS) ASP.NET 3.5 and Microsoft SQL 2008 database. 

To install the Polar HelpDesk, you will require at least:
	1. Microsoft SQL 2008 Express	
	3. Internet Information Services 5.1 (IIS)
	4. ASP.NET 3.5


Installation of the Polar HelpDesk has two parts. First part is setting up the web application, and the second part is setting up the database.

Steps to install HelpDesk web application:
	1. Copy HelpDesk files into an empty folder called HelpDesk. If you don't already have the files, Polar HelpDesk installation will produce them for you, regardless of its ability to successfully complete the installation.
	2. Open IIS Console and create a virtual folder. Location of the folder is of no consequence. Connect this virtual folder to the folder where you copied the HelpDesk files.
	3. Open the properties of the HelpDesk virtual folder in IIS.
	4. On ASP.NET tab, make sure ASP.NET 2.0 is selected.
	5. On the Virtual Directory tab, under Application Settings, make sure that this folder is marked as a Web Application. Press the Create button if virtual folder was not already turned into Web Application.
	6. Make sure that Application Protection is set to Low.
	7. Once Web Application has been created, click the Configuration button.
	8. On Application Configuration popup, we will add a new mapping. This differers between IIS versions:
		1.  For IIS 6:
			1. click Insert... button and on the popup that opens.
			2. Select C:\WINDOWS_FOLDER\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll as Executable (depending on how your ASP.NET 2.0 is installed) .* as Extension.
			3. Make sure that "Verify that file exists" checkboxes are *unchecked*.
			4. Click OK and OK again.
		2. For IIS 5.1:
			1. click Add button and on the popup that opens.
			2. Select C:\WINDOWS_FOLDER\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll as Executable (depending on how your ASP.NET 2.0 is installed) .* as Extension.
			3. Check All Verbs and make sure that "Script engine" and "Check that file exists" checkboxes are *unchecked*.
			4. Click OK and Apply.
	9. Click Apply and then Apply again.

Steps to install the database:
	1. Make sure that your SQL Server supports logging in using Windows Authentication. This is not mutually exclusive with SQL Server Authentication.
	2. Open the SQL Server Management Studio and create a new database called HelpDesk.
	3. In HelpDesk fodler, there should be Scripts subfolder. Here are located all scrips required to setup the Polar HelpDesk.
	4. In SQL Server Management Studio, open the Scripts/CreateDatabaseObjects.sql script, and execute it on the HelpDesk database to create the basic database structure.
	5. In SQL Server Management Studio, open the Scripts/InitializeDatabase.sql script, and execute it on the HelpDesk database to populate the database with HelpDesk data.
	6. Configuring the database permissions can be tricky because these differ between versions of the Windows. ASP.NET 2.0 has a worker process under which web applications are executed. This worker process is the one who will be accessing our newly created database in the name of the Polar HelpDesk web application. In order for the wroker process to connect to our database, it will need to have permissions to do so.

		There are two types of users, created for ASP.NET web applications to run under. These are dependant on the Windows version you are running:
			1. MACHINENAME\ASPNET user on Windows XP/2000
			2. NT AUTHORITY\NETWORK SERVICE user on Windows 2003
			
		You will need to add these users to the database you have created and give them full read/write/create database permissions.
	
	7. When the web application starts, it will search all the SQL servers for valid Polar HelpDesk databases and read the InstanceConfiguration table from these databases. Our next step is to let Polar HelpDesk web application know what database it will use for our HelpDesk. 
	
		Open the database table called InstanceConfiguration. In InstanceConfiguration table, under column Url write the url of your HelpDesk. Example of this url is "http://localhost/helpdesk/". 
		Make note that the url you enter is the url you use to access the HelpDesk through your browser. Also, note that the url you enter needs to end with "/". 
		
		In case there are any issues, heres a description of why the above step is required:
		When user enters our url ("http://localhost/helpdesk/") into his internet browser, a request will be sent to the Polar HelpDesk web application we have installed at that location. Polar HelpDesk web application will then match this url with the one we have entered in our database InstanceConfiguration table. Once a matching url is found, database that contained the url will be used to process the request.

Now you are ready to start the HelpDesk by opening it in the web browser. If for some reason, database cannot be found, please confirm that the url you have entered is correct and then execute "iisreset" command in Start->Run. This should restart the HelpDesk web application and give you a fresh start.
