WN Help Desk Microsoft SQL Setup Script
WNHelpDeskSQLSetupScript_9.1.zip (1/26/2007) - Click to download the Microsoft SQL script for WN Help Desk 8x and WN Help Desk Web 8x.
WNHelpDeskSQLSetupScript.zip - Click to download the Microsoft SQL script for WN Help Desk 7.x, and WN Help Desk Web 3.x.
NOTE: WN Help Desk and WN Help Desk Web have been tested with a backend SQL database using Microsoft SQL 7.0, SQL 2000, SQL 2005, and the MSDE. Although previous versions of Microsoft SQL may function with the WN Help Desk products, they have not been tested and are not guaranteed to work with the software. 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 the MSDE (Microsoft Data Engine), 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:
- 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