Auditor Help: Advanced Database Setup
Using Microsoft's ODBC Data Source Administrator
Note: The following instructions provide a GENERAL guideline for establishing an Ecora Configuration Data Repository using the advanced methods. However, these steps have many variations based on your environment and choices. Consult the database administrator at your site and follow the standard Microsoft data source identification procedure.
For instructions, consult the OBDC Help files (click on the Help button in one of the setup dialog boxes or locate Odbcjet.hlp and Odbcinst.hlp on your local drive - default c:/winnt/system32).
Manage Data Sources with Microsoft's ODBC Data Source Administrator
| Choose to Manage Data Sources. | Click the Manage Data Sources button to define a new database. This launches the MS ODBC administrator interface. Click New....  |
Select the appropriate driver. |
Select the SQL Server driver from the list and click Finish. |
Configure the basics for the DSN. |
Enter the appropriate information into the following fields:
Click the Next > button to continue. |
Enter authentication information. |
Click the radio button to use SQL Server authentication. Verify the Port Number.  Click OK to return to the previous panel if these fields aren't set properly, otherwise, click the Cancel button. Click the Next > button to continue to the next step. |
Finish configuration. |
There are no settings which need to be adjusted on this screen. Click the Next > button to continue to the next step.
Click the Finish button. |
Test the connection. |
Click the Test Data Source button to test the connection to the database server. If no errors are reported, click OK. |
Create a new data source. |
If prompted to confirm creation of a new Configuration Database, click Yes. |
Finish. |
A progress dialog shows successful creation. Begin using the database! |
