...
StudyTRAX will redirect the browser to a special login page if there are any problems with the database.
| Center |
|---|
|
Configuring the Database
Setup Connection String
Default | data source=(local);integrated security=sspi;persist security info=True;packet size=4096;initial catalog=StudyTrax |
|---|
New Install
| Center |
|---|
|
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 THIS.
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 |
|---|
|
After clicking the "Continue" button, a loading indicator 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 the word "Finished" at the top of the output window. If this message is not displayed in the output window, check for any errors that may have ocurred.
| Center |
|---|
|
| Note |
|---|
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 |
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.
|
| 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.
To upgrade the database to the latest version, click the "patch" link. 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 |
|---|
If these credentials are not available, the manual database patch process must be used |
| Center |
|---|
|
After clicking the "Continue" button, a loading indicator will appear. The page will refresh and update the "Output" window with what is going on with the patch process every 1 second. Once the process is complete, you should see the word "Finished" at the top of the output window. If this message is not displayed in the output window, check for any errors that may have ocurred.
| Center |
|---|
|
Configuring the Application
...
The full URL that StudyTRAX is attempting to download will be displayed if it is not accessible.
Database
Up until this point, most of the installation process is the same for both new installs and upgrades. At this point, the steps will be slightly different depending on which is being done.
New Install
| Center |
|---|
|
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 THIS.
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 |
|---|
|
After clicking the "Continue" button, a loading indicator 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 the word "Finished" at the top of the output window. If this message is not displayed in the output window, check for any errors that may have ocurred.
| Center |
|---|
|
| Note |
|---|
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 |
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.
|
| 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.
To upgrade the database to the latest version, click the "patch" link. 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 |
|---|
If these credentials are not available, the manual database patch process must be used |
| Center |
|---|
|
After clicking the "Continue" button, a loading indicator will appear. The page will refresh and update the "Output" window with what is going on with the patch process every 1 second. Once the process is complete, you should see the word "Finished" at the top of the output window. If this message is not displayed in the output window, check for any errors that may have ocurred.
...
Installation Complete
If all steps were followed and completed successfully, StudyTRAX should be setup correctly and all boxes should be green. Click "Return To Login Page" to return to the login page.
...