Versions Compared

Version Old Version 18 New Version 19
Changes made by

Leslie

Leslie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

StudyTRAX will redirect the browser to a special login page if there are any problems with the database.

Center

Image RemovedImage Added

Configuring the Database

...

New Install

Center

Image Removed Image Added

The server box will be green if database server in the "Connection String" is accessible and all the permissions are correct. If not, EXPAND ON THISyou should be presented with options to perform the necessary actions to correct the problems.

Assuming that the "Server" box is green, there should be a "create" link in the red "Exist" box. Clicking this box will create the StudyTRAX database pointed to by the connection string. After clicking the link, a dialog will be presented to obtain the credentials of an account that has "DBO" permission to the master database.

Note

Using the StudyTRAX application to create the database will use all the standard defaults in SQL server. If you need to control where to place the database, the initial size, or any other attributes about the database, you will need to follow the manual process for creating the database.

Also, if "DBO" credentials are not available, the manual database creation process must be used

Center

Image RemovedImage Added

After AFter clicking the "Continue" button, a loading indicator dialog will appear . The page will refresh and update the "Output" window with what is going on with the creation process every 1 second. Once the process is complete, you should see showing the progress of the database creation. When the word "Finished" at " appears in the dialog, an "X" will appear in the top right of the output window. If this message is not displayed in the output window, check for any errors that may have ocurreddialog that can be used to close it.

Due to a bug in 3.0.0103, when creating a new database, the database version will only be set to 3.0.0102 and you must follow the instructions in the patch process described below
Center

Image Modified

Note

After closing the dialog, a status page will be presented explaining the state of the configuration.

Upgrading An Existing Version

Note

StudyTrax requires SQL Server 2005 or later. If you backup a database and then restore it on a newer version of SQL Server, the compatability level of the earlier version is retained. Thus, the compatability level needs to be updated.

  • Check the compatability level by executing the following in SQL Server Managment Studio: sp_dbcmptlevel 'StudyTrax'
  • A return value of 90 means SQL Server 2005 and 100 means SQL Server 2008.
  • To set the compatability to SQL Server 2008: alter database StudyTrax set compatibility_level = 100
  • To set the compatability to SQL Server 2005: EXEC sp_dbcmptlevel StudyTrax, 90;
Center

Image Added

Center

If an installation of StudyTRAX is already installed an option to patch the database will be shown. It should display the "DB Version" and the "Current" version that the application expects.

...