Wickett.NET Mobile

SQL Setup Script

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

NOTE: WN Help Desk Web 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