Create an ODBC Data Source Name (DSN), used for connections to an MS SQL Server database system.
Install or verify the presence of the proper version of the MS SQL server ODBC drivers matching the version of the SQL Server database to which the Agentry Server will connect.
DSN Name: Determine and record the name for the DSN before the DSN is created. This is the name by which the ODBC connection for the SQL Server database is identified on the host system. It is needed when the Agentry Server is configured.
Server Network Name: The network name of the host system for the SQL server database.
Login Authentication Method: When creating the DSN, the option is provided to validate a database client’s login and password using either Windows NT authentication, or by using SQL server authentication. Determine the proper method before creating the DSN.
Login and Password: If the login authentication method will be SQL server authentication, obtain the login and password of a valid database user. If the chosen login and password are not valid, it is not possible to create the DSN.
Default Database: A DSN connection is made to a SQL server database server. It is likely this server has multiple database instances. Therefore, determine the proper database instance as it will be the default instance to which a database client connects when using the DSN created in this procedure.
Additional Options: There are several options available within the Add System DSN wizard that do not usually need to be modified for Agentry. However, if special circumstances in an implementation require changes to these options, make such determinations prior to creating the new DSN for the Agentry Server.
A DSN is created using the Add System DSN wizard provided in the Data Sources (ODBC) utility in Windows. This information is provided for reference purposes only. Those who are not familiar with this procedure or the concepts of ODBC should review documentation provided by Microsoft before proceeding.
A new ODBC Data Source Name is created. This DSN will be used by the Agentry Server to connect with the MS SQL Server database.
Make note of the Data Source Name value entered when creating the DSN. This value is needed when configuring the Agentry Server after it is installed. Also note the login and password information for SQL authentication (if selected) as this is needed by the Agentry Server.