Start your FREE Trial of NetHelpDesk!

Manual Installation of NetHelpDesk SQL Server Database

If you are looking at this guide, without looking at the Installing NetHelpDesk using the Installer guide first, we recommend you do so now, before proceeding. In that guide, you will see that NetHelpDesk has three components, all of which can be installed automatically using the installer. Here, we will look at the manual installation of the SQL Server environment, known in that guide as "Component 2".

However, if you have chosen to look at alternatives for the SQL Server Database, this guide will take you through the necessary steps. When Component 1 has completed, it places files ready for the manual setup that it also uses as part of the installer. All the installer does is automatically do what we will now show you manually how to do.

If you are looking to install the web interfaces manually, these are in a separate guide.

SQL Server Database Options

As per the instructions in the installer guide, there are two options if not using the installer for the database:

OPTION SQL 1 is detailed in the guide Installing NetHelpDesk using the Installer, and option that installs NHD's very own SQL Server Instance, and the one we recommend.

Whichever option you choose:

OPTION SQL 2 - Using a Pre-Existing SQL Server Instance

If there is a SQL Server Instance pre-existing, it will need some configuration checks before restoring the NetHelpDesk pre-configured database to it.

PLEASE NOTE: If you make any changes in the SQL Server Management or SQL Server Configuration Manager for an existing instance, any existing databases inside the Instance will be affected as well. Please take this into consideration before proceeding. NetHelpDesk may not be able to support any changes you make that affect another program.

If you are unsure of the best option for you, or have any queries, contact our Support Team at NetHelpDesk, and we're happy to go through your options with you.

SQL Server Management Studio

Launch SQL Server Management Studio, and login using a high level access login to the instance. If the “sa” account exists, you’ll need to be able to log into the instance with it. When logged in:

SQL Server Configuration Manager

Launch SQL Server Configuration Manager. When opened:

Install SQL 1
Install SQL 2
Install SQL 3

OPTION SQL 3 - Installing a New SQL Server Instance Manually

The SQL Server instance will be new, and it will need some configuration checks before restoring the NetHelpDesk pre-configured database to it.

You have several options available to you:

Whichever one you choose, NetHelpDesk will work with either, and the support team will be able to assist with these environments, should you experience any difficulty. If you are unsure of the best option for you, or have any queries, contact our Support Team at NetHelpDesk, and we're happy to go through your options with you.

To install SQL Server manually:

Install SQL 4
Install SQL 5

SQL Server Configuration Manager

As before, in the OPTION SQL2 steps, you will need to make some changes in the SQL Server Configuration Manager.

Install SQL 1
Install SQL 2
Install SQL 3

PLEASE NOTE: If you have Firewall software (Windows or 3rd Party software) running on the Server, add an exception/incoming rule to allow TCP Port 14331.

Manually Restoring Database into SQL Server Instance

Whether selecting Option SQL2 or Option SQL3, a database for NetHelpDesk to use will need to be added to the instance of SQL Server. NetHelpDesk uses this database to store and retrieve data and configuration to the main NetHelpDesk interfaces.

In the \\…NetHelpDesk\SQL folder, we have included a pre-configured blank NetHelpDesk database file for you to use, called NetHelpDesk.bak. This file is suitable for use in SQL Server 2008 R2 onwards.

However, if this is missing, or the folder not present, please speak with the support team.

PLEASE NOTE: At this point, you will need to have SQL Server Management Studio installed to be able restore the database .bak file into the SQL Server instance.

You can use any version of SQL Server Management Studio to access the instance, as long as the version is the same or newer as the SQL Server version that is installed.

If at any time you get stuck, or you’re unsure how to proceed, please speak with a member of the NetHelpDesk Support Team.

To Restore the .bak Database:

Install SQL 6
Install SQL 7
Install SQL 8

Configuring a new UDL file for use with SQL Server

With Option SQL2 or Option SQL3, the data link file, which links the NetHelpDesk interfaces to the SQL Server database, will need to be updated. The data link file is called NetHelpDesk.udl, and one is automatically created and configured for you if following the installer.

If not, you will have to do this manually. To achieve this:

Install SQL 9
Install SQL 10

Creating New Shortcuts Manually

To use the NetHelpDesk Windows Interface, a shortcut is needed, and manually created if using the installer. If setting NetHelpDesk up manually, you will need to configure this manually.

If there is a NetHelpDesk shortcut in the root of your …\NetHelpDesk folder, these can be amended as necessary.

PLEASE NOTE: The NetHDClient.exe, the web interfaces, and the database can all be situated in three different places, two different places, or altogether in one. As long as the shortcut, and the NetHelpDesk.udl files point to right locations, NetHelpDesk will launch without issue.

Also make sure the NHServer has a shortcut configured similar to the main client one.

Should you have any questions regarding any steps in this guide, please speak with the NetHelpDesk Support Team.

Our software is available on multiple platforms...

NetHelpDesk is available on a range of devices with industry-leading functionality available throughout.

  • Windows Phone

    Windows Phone

  • Android


  • iPhone


  • BlackBerry


  • Tablets


  • Windows



Cookie Policy

We use cookies to enhance your experience on our web site. By using our website or closing this message, you are agreeing to our Cookie Policy.