Task 1.4(c): Set up Databases, E-Mail, and Proxy Server Connections, SQL Server Alternative

...

Secure the TraCS databases created in step 2.
1. Set up a user id and password in SQL Server that will be used for all TraCS generated SQL commands. The user ID needs the following permissions for SQL Server databases:
  1. Select, insert, delete, and update permissions for all tables in the TraCS databases
  2. Create table, alter table, create column,and alter column (for successful pack installation and migration of users)
  3. Alter database (for successful pack installation)
  4. They simplest way would be to give the TraCS user ID owner permissions
Create the needed tables in the tracs_log database using the “log” SQL script. The script will be located in c:\programdata\tracs\Baseline Files\Scripts\ Baseline Log Total SQLServer.sql

...

Open the TraCS Configuration Manager,
Sign in with account 00001, password tracs.
Click Setup tab
Click the Database Connections button.
Select Database Connection Strings.
Click Import DB Connections.
Expand the database connection string item.
Select the Support, Data, Users, and Log entries. (Use the <Ctrl> key to select multiple entries at the same time.)
Click OK.
Edit the database connection for the Support database.
1. Expand the Database Connection Strings item.
Image RemovedImage Added
Select Support.
Change the Database to SQL Server.
Choose Application User ID and Password.
In the Server Name field, enter the name of the server hosting the SQL server databases. This is the same as the Data Source in the connection string.
In the Database Name field, enter tracs_support. This will populate the Catalog portion of the connection string.
Enter the user ID and password needed to access the database.
Click Test to verify the connection string.
Edit the database connection for the data database.
1. Select Data under the Database Connection Strings item.
  Image RemovedImage Added
2. Change the Database to SQL Server.
3. Choose Application User ID and Password.
4. In the Server Name field, enter the name of the server hosting the SQL server databases. This is the same as the Data Source in the connection string.
5. In the Database Name field, enter tracs_data. This will populate the Catalog portion of the connection string.
6. Enter the user ID and password needed to access the database.
7. Click Test to verify the connection string.

Info

Note: The database connection configuration editor also contains an option for trusted security, also known as “Windows Authentication.” We do not recommend this setting. Using trusted security implies that each user may also interact with the TraCS databases outside of the TraCS program because SQL Server permissions have been granted on the individual user’s account. Application User ID and Password is more secure.

Edit the database connection for the Users database.
1. Select Users under the Database Connection Strings item.
  Image RemovedImage Added
2. Change the Database to SQL Server.
3. Choose Application User ID and Password.
4. In the Server Name field, enter the name of the server hosting the SQL server databases. This should be the same as what you would enter for the Data Source portion of the connection string.
5. In the Database Name field, enter tracs_users. This will populate the Catalog portion of the connection string.
6. Enter the user ID and password needed to access the database.
7. Click Test to verify the connection string.
8. Click Apply to save your work. (Important: If missed, next step will fail.)
Run a batch file to create the tables for tracs_users database:
C:\Program Files (x86)\TraCS\Baseline Files\Distribution\Total\TraCS Baseline Total Users.bat
Edit the database connection for the Log database.
1. Select Log under the Database Connection Strings item.
  Image RemovedImage Added
2. Change the Database to SQL Server.
3. Choose Application User ID and Password.
4. In the Server Name field, enter the name of the server hosting the SQL server databases. This should be the same as what you would enter for the Data Source portion of the connection string.
5. In the Database Name field, enter tracs_log. This will populate the Catalog portion of the connection string.
6. Enter the user ID and password needed to access the database.
7. Click Test to verify the connection string.
Edit the database connection for the Custom database.
1. Select Custom under the Database Connection Strings item.
2. Change the Database to SQL Server.
3. Choose Application User ID and Password.
4. In the Server Name field, enter the name of the server hosting the SQL server databases. This should be the same as what you would enter for the Data Source portion of the connection string.
5. In the Database Name field, enter tracs_custom. This will populate the Catalog portion of the connection string.
6. Enter the user ID and password needed to access the database.
7. Click Test to verify the connection string.
Edit the SMTP connection to enable e-mail message delivery. (Optional)
1. Select the SMTP entry.
  Image RemovedImage Added
2. Click the add button.
3. Enter e-mail in the Name field.
4. Click OK.
5. Expand the SMTP item.
  Image RemovedImage Added
6. Select e-mail.
7. Complete the panel on the right:
  Image RemovedImage Added
  In the Description field, enter e-mail.
  In the Server field, enter the address of your e-mail server. (For example: mail.myserver.com)
  In the port field, enter the port number, typically 25.
  In the timeout field, enter 240.
  In the UserID and Password fields enter the login credentials to be used when connecting to the e-mail server.
  In the From Address field, enter the “from” e-mail address to be used with messages coming from TraCS.
  In the Display Name field, enter the display name to be associated with the “from” e-mail address.
Configure the web proxy server if your agency uses a proxy server to reach the Internet.
1. Expand the Proxy item.
2. Select Defined Proxy.
  Image RemovedImage Added
3. Complete the panel on the right:
  1. Note: consult your proxy server administrator if you need help completing this panel.
  2. Complete the URL and Port fields as recommended by your proxy server administrator.
  3. If a user id and password are required to connect to the Internet through the proxy server, enter the required information in the Domain, UserID and Password fields.
Click OK.
Close the configuration manager.