Table of Contents
| Table of Contents |
|---|
Log In To StudyTRAX
To get started, open the URL to the installation of StudyTRAX from a browser. It is usually easier to perform this from a client with an updated browser rather than through the browser on the server. StudyTRAX will redirect the browser to a special login page if there are any problems with the system configuration.
| Center |
|---|
|
Configuring the Database
Setup Connection String
Whether performing a new installation or upgrading a prior installation, you will need to make sure that the connection string is pointing to the correct database. If you are doing an upgrade, you can copy the OldInstallDir\App_Data\studytrax.config to NewInstallDir\App_Data and that will copy over the connection string. After you copy the file, you will need to restart the application. Alternatively, you can click on the "Update DB Connection" button to type in the correct connection string. If you are doing a new install, you will need to update the connection string via the "Update DB Connection" button.
...
- SQL Server 2005 Connection Strings
- SQL Server 2008 Connection Strings
- SQL Server Connection String Properties
New Install
| Center |
|---|
|
The server box will be green if the 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.
...
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.
|
...
After clicking the "OK" button, a dialog will appear showing the progress of the database patch. 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 |
|---|
|
Configuring the Application
To update the System Configuration, click on the "System Configuration" tab and click the "System Configuration" button (the gear to the right of the screen) and configure the application before granting permissions to the folders and files.
...
On the "Configuration Settings" page, you will need to configure several settings. While there are many settings that can be configured here, only some of them are required:
Application Settings
Log Directory | This is the directory where the StudyTRAX log files will be stored. This directory should not grow very large as most logs are only generated when the application starts/stops or errors are generated. | ||
|---|---|---|---|
External Server Address | This is the address that should be used to access the server by all end users. If this is just being deployed internally, then a public DNS name is not necessary, but if it will be accessed via the Internet, you must provide a valid DNS name.
| ||
Password Sender Address | This is the email address that will be used to send out emails when users request that their password be reset because they forgot it |
SMTP Settings
Server | This is the DNS name or IP address of the SMTP server |
|---|---|
Domain | This is the domain of the user to use for authenticating to the SMTP server. (optional) |
Username | This is the username to use for authenticating to the SMTP server. (optional) |
Password | This is the password to use for authenticating to the SMTP server. (optional) |
Port | This is the port number that the SMTP server is running on |
...
Once you have configured the application, click the "Save And Return" button in the toolbar.
| Center |
|---|
|
Directories
| Center |
|---|
|
There are various files and directories that StudyTRAX needs to write to. These directories and files need to have write permission granted to the StudyTRAX Service Account that the application runs as.
...
If there are any red boxes, a "grant" link will be visible. You can click this to have the application grant the appropriate permissions to the folders and files. Once this is done, all the boxes should be green.
| Center |
|---|
|
SMTP
| Center |
|---|
|
Initially, the SMTP settings will show up in red. If the SMTP settings were configured correctly in the "Configure the System" above, the "Configured" box should be green.
...
| Note |
|---|
It is required that the "Tested" box go green. If for some reason you cannot configure an SMTP server or it will not register as green, you can edit the "studytrax.config" file and add a node (or edit it if it already exists) with a key of "Mail.Settings.Valid" and a value of "True". Once you have done this, click the "Refresh" button in the toolbar. |
External Address
| Center |
|---|
|
The External Address tells StudyTRAX how it is accessed from the public internet. This address is used to generate URL's for resetting passwords as well as sending out notification emails (a URL may be provided to allow the notified user/subject to click and login to StudyTRAX).
The full URL that StudyTRAX is attempting to download will be displayed if it is not accessible.
Configuration Complete
If all steps were followed and completed successfully, StudyTRAX should be setup correctly and all boxes should be green. Click "Restart Application" to restart the application and return to the login page.
| Note |
|---|
If you are doing a new installation, or upgrading from StudyTRAX 2.40, a new account will be created called "admin" with a password of "admin". This account will immediately require a password change. Also, this account is used to create user accounts. |
| Center |
|---|
|
Resolutions to potential problems
- If it is not possible to either create the database or patch (when the version is not current) using the Summary tab, the "Database Tools" tab has instructions on how to manually perform these steps.
- When patching a database that was restored from SQL Server 2000, if you get the following error: "Incorrect syntax near 'ps'", it means your database is running in SQL Server 2000 compatability mode. 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;