Sentinel: Modifying an Agent to use File DSN for Windows Authentication.

Modify an agent to use File DSN to allow Windows Authentication.

This functionality is available in Sentinel 5.1.x

To use file DSN:
1) Specify the FILEDSN parameter in the ODBC_DSN agent parameter. Example (assuming created a File DSN named test.dsn at C:\):
FILEDSN=C:/\test.dsn
2) Change the DB_OPEN command in the agent to use the "odbc2" type db connector. Example:
DBOPEN("odbc2", s_ODBC_DSN, s_ODBC_DSN_Username , s_ODBC_DSN_Password , i_DB_Handle)
3) Make sure the Agent Manager Service is setup to run as the user that has permissions to connect to the DB.

1) Open Start->Programs->Administrative Tools->Data Sources (ODBC)
2) Click on the File DSN tab.
3) Click the "Add..." button.
4) Select "SQL Server" as the driver.
5) Specified filename "C:\test.dsn"

From that point on, the order of the screen shots are as follows:

1) SpecifyDBServer.pdf
2) SpecifyWinAuth.pdf
3) SpecifyDBName.pdf
4) SetupSummary.pdf
5) TestSuccess.pdf

After performing these steps, the contents of the C:\test.dsn file are:

[ODBC]
DRIVER=SQL Server
UID=jgassner
Trusted_Connection=Yes
DATABASE=ESEC50P4
WSID=TCDEV03
APP=Microsoft Data Access Components
SERVER=DEVINTW09