Versions Compared

Key

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

...

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, you should be presented with options to perform the necessary actions to correct the problems.

...

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 Removed Image Added

AFter clicking the "Continue" button, a dialog will appear showing the progress of the database creation. When the word "Finished" appears in the dialog, an "X" will appear in the top right of the dialog that can be used to close it.

Center

Image Removed Image Added

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

...

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 Removed 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.

...