This is a six-part process that must be followed to properly configure a remote SQL Server to work with WhatsUp Professional. While the process is not complicated, the steps require careful attention. Failure to follow these directions results in application failure, and could cause corruption or failure of the SQL Server instance.

Steps 1 through 4 are for the computer running SQL Server 2000, and Steps 5 and 6 are for the computer running WhatsUp Professional.

Step 1 – Copy the files over

Before you begin the configuration of the SQL Server, you must copy the DB Scripts directory (and all files therein) from the computer that WhatsUp Professional is installed on, to a directory on the computer running SQL Server.

You can find the DB Scripts directory in the directory where WhatsUp Professional is installed. An example install directory is:
C:\Program Files\Ipswitch\WhatsUp Professional 2005.

Step 2 - Configure SQL Server 2000

1. Make sure the correct SQL Server is running in the Service Control Manager.
2. Access the SQL Server Enterprise Manager at Start > Programs > Microsoft SQL Server > Enterprise Manager.
3. In the Microsoft SQL Servers tree, select the server you want to use to house the WhatsUp Professional database.
   Click to view screen capture.
4. Access the SQL Query Analyzer from the menu bar at, Tools > SQL Query Analyzer.
5. In the Query Analyzer, select File > Open and navigate to the directory you copied over from the WhatsUp Professional 2005 installation directory.
6. Select the file create_database.sql. The file opens in the SQL Query Analyzer.
7. In the create_database.sql file, there are 2 occurrences of the <MSDE_DATA_PATH> token string, both appearing in the same line. Replace both occurrences of <MSDE_DATA_PATH> with the full data path for the server you are installing the database on.
   Click to view screen capture.
8. Once both token strings are replaced, execute the script. The results of the script appear in the Analyzer window. Verify that no errors occurred.
9. Select the new WhatsUp database from the pull-down menu on the SQL Query Analyzer toolbar. If you do not select the correct database, the tables will be inserted in the wrong database, causing the configuration to fail.
   Click to view screen capture.
10. After selecting the WhatsUp database, open the create_table_all.sql script from the same directory as before.
11. Execute the script. The results of the script appear in the Analyzer window.
12. Open the insert_table_all.sql script from the script directory.
13. In the insert_table_all.sql file, find and replace all occurrences of the <DATAFILESPATH> token with the full path to the script directory you opened the other scripts from.
14. Execute the script.

After completing these tasks, the database is fully configured. Verify this on the Enterprise Manager by expanding the tree under the WhatsUp Database and selecting Tables. There are 64 tables if the configuration was done properly.

If the WhatsUp database is not in the tree view, you may need to refresh the view by pressing F5.

Continue to Step 3 >>