WBT Manager™ Installation Procedure for Microsoft SQLServer ™
May 18, 2005
WBT Manager has been tested with the following versions of Microsoft SQLServer and ODBC Drivers.
SQLServer 8.00.194, MDAC 2.7, SQLServer ODBC driver (sqlsrv32.dll) 3.70.0820
Installation procedures
I. Database setup.
1. Use SQLServer management tools to create a database for WBT Manager.
2. Create a user to own the WBT Manager database objects. This user must have permissions to create tables, indexes, and constraints. User must also be able to grant access to owned objects. This procedure will use "wbtmanadmin". This login must be a dbo alias - SQLServer7 and SQLServer 2000 users may need to execute the "sp_changedbowner" procedure:
Launch SQLServer Enterprise Manager
From the "Tools" menu, select "SQL Query Analyzer"
From the dropdown list of databases, select the new WBT Manager database.
Enter the following command in the "Query" window.
exec sp_changedbowner 'wbtmanadmin'
From the "Query" menu, select "Execute".3. Create a user or group of users to be used by the WBT Manager modules to access the database. The supplied script for granting table access uses "wbtmanuser" as will the remainder of this procedure.
4. Connect to the database as "wbtmanadmin" and execute the sql scripts found in \utilities\database\scripts on the WBT Manager CD to create and initialize the WBT Manager Tables (use the WBT Manager runsql utility NOT the SQL Query Analyzer). The scripts are (in order of execution):
sqlserv.sql - contains table, index, and constraint definitions.
initdb.sql - contains initial data for the tables.
report_views_sqlserver.sql - creates views for certain reports
grantdb.sql - grants access to all WBT Manager tables to user "wbtmanuser". Copy and edit this script for other user ids.
These scripts are intended to be executed through an ODBC DSN using the runsql utility. The syntax differs slightly from that of T-SQL. Using the SQLServer utilities to execute the scripts may result in incorrect column types and missing RI constraints. Runsql.exe may be found in \utilites\database on the WBT Manager CD.
There is an additional scripts which may be of interest:
cleandb.sql - drops all WBT Manager Tables.
The WBT Manager Database is now ready for use.
II. Install WBT Manager Web Server Module
1 . Install SQLServer client software on the Web Server.
Use a TCP/IP connector, not Named Pipes.
2. If not already installed, install version 3 of the Microsoft XML Parser (Windows XP and systems with IE6 installed do not require this step).
There is a copy of the installation file msxml3sp1.exe for version 3 sp1 in \utilites\msxml on the WBT Manager CD, or the most current version can be downloaded from http://www.microsoft.com/xml . Execute msxml3sp1.exe to install the parser.
NT and Windows 98 users may need to install Windows Installer 1.2 before the MSXML installation can succeed. There are copies of the installation sets in \utilities\windows_installer\ver12_9x_me and \utilities\windows_installer\ver12_nt4.
3. If not already installed, install the latest version of Microsoft Data Access Components.
There is a copy of the installation file mdac_typ.exe for version 2.5 in \utilites\database\mda2 on the WBT Manager CD, or the most current version can be downloaded from http://www.microsoft.com/data. Execute mdac_typ.exe to install the upgrade.
7. Insert the WBT Manager CD (or run wbtman_setup.exe from a downloaded installation set). Select "Install WBT Manager Web Server Module" from the menu and follow the installation instructions with the following exception:
When prompted for the "Database Type", select "SQLServer database" and click "Next".
Enter the Server Name and Database Name for the database and click "Next".
Enter the user id ("wbtmanuser") and password for the web module to use to connect to the database and click "Next".
Complete the installation as directed by the instructions.
The WBT Manager Web Module is now ready for use. A student and an administrator are predefined for demonstration and test purposes. The student ID/Password is "demo"/"demo". The administrator ID/Password is "admin"/"admin".
III. Install WBT Manager Administrator Module
On each workstation which is to run the WBT Manager System Administrator module repeat the following:
1. Install SQLServer client software on the workstation.
Use a TCP/IP connector, not Named Pipes.
2. Create a DSN for WBT Manager.
Use the ODBC Administrator to create a new Data Source. Select "SQLServer" as the driver. Set the name as desired (this procedure will use "WBT Manager SQLServer DB", enter the server name of the server containing the database. Set authentication to "With SQLServer authentication using a login ID and password entered by the user". Change the "default database" to the database created above. Set all other settings as desired by your database administrator.
3. Test the DSN with the user name and password from the database creation procedure ("wbtmanuser"). Resolve any connection problems before proceding.
4. Insert the WBT Manager CD (or run wbtman_setup.exe from a downloaded installation set). Select "Install WBT Manager System Administrator Module" from the menu and follow the installation instructions with the following exception:
When prompted for the "Data Source", select "Pre-existing data source" and click "Next".
Select the data source defined in step 2 above ("WBT Manager SQLServer DB") and click "Next".
Enter the user id ("wbtmanuser") and password for the administrator module to use to connect to the database and click "Next".
The WBT Manager System Administrator Module is now ready for use. On initial startup connecting to a new database you will be prompted to enter your license key before you can log onto WBT Manager. The initial administrator account ID is "admin" and it's password is "admin". You should change this password to secure the system.