1.   Open the Database Connection Manager from the Optitask Tools Menu.

2.   Click on Add.

3.   Select MS-SQL from the Connection Type dropdown.

4.   Enter a descriptive name or alias for your database connection in Optitask.

5.   Enter the Connection String to your Database. Some Common properties are:
* Data Source = Name of the database server
* Initial Catalog = Name of the database
* Integrated Security = SSPI (if you are using Windows Authentication)
* User ID = User name if you are using SQL Authentication
* Password = Password for SQL Authentication

An example connection string would be:
Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI

6.   Click on OK to save your connection.

Click on the Test button to ensure that your database connection is setup properly.