SQL Setup Script

NOTE: The latest version of WN Help Desk can create all the necessary database structure for you. Simply create a new empty database on the SQL Server and use the setup wizard in WN Help Desk to configure that database. You only need to download the SQL Setup Script if you run into a problem using the new built-in setup tools.

WNHelpDeskSQLSetupScript12.0.zip (9/15/2015) - Click to download the Microsoft SQL script for WN Help Desk 12.

NOTE: WN Help Desk has been tested with all versions of Microsoft SQL Server that are supported by Microsoft. The following installation instructions assume that you are using Microsoft SQL 7.0 or higher and the management tools that come with Microsoft SQL Server. The software has also been tested using Express and Community versions of SQL Server, using the Microsoft SQL Server tools to perform the database creation and maintenance.

Creating a New SQL Database (Pre 2005):

  • Open the SQL Server Enterprise Manager
  • Right-click on the Databases folder and select New Database
  • In the Name field type a name for the database, such as WNHelpDesk
  • The defaults are acceptable, but can be changed by your SQL administrator if necessary
  • Click OK to create the database
  • Click on the database you just created to bring up the options page
  • From the Tools menu select SQL Server Query Analyzer
  • Select File, Open from the menu
  • Browse to the location of the setup script titled WNHelpDeskSQLSetupScript.sql, highlight the file, then click Open
  • In the DB drop-down list change the database to the newly-created help desk database from the previous steps
  • Select Query, Execute from the menu
  • Once the query has completed close the SQL Server Query Analyzer
  • The new SQL database is now ready for use, you can import your data using the DataConverter application

Creating a New SQL Database in SQL Server 2005 or later:

  • Open the Microsoft SQL Server Management Studio
  • Right-click on the Databases folder and select New Database
  • In the Database testName field type a name for the database, such as WNHelpDesk
  • The defaults are acceptable, but can be changed by your SQL administrator if necessary
  • Click OK to create the database
  • Expand the database you just created and select the Tables folder
  • Click the Open File icon (or select File, Open, File from the menu) and open the SQL Setup Script file
  • Make sure the "database" in the drop down list next to the Execute icon is set to the database you previously created for WN Help Desk then click Execute
  • Once the query has completed close the query window and refresh the Tables folder
  • The new SQL database is now ready for use, you can import your data using the DataConverter application