Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

SQL Server with ODBC connection

SQL Server with ODBC connection

To create an ODBC connection (System DSN) follow the general procedure for SQL Server 2008/2012/2014 and then proceed as follows:

  1. Open the window ODBC Data Source Administrator and select the System DSN tab.
  2. Click Add and select the SQL Server driver from the list, then click Next .
  3. In the window that opens enter the name for the data source (for example, bcmdb ), select the SQL Server to which to connect and click Next .
  4. Select the authentication type Windows or SQL Server and click Next .
  5. Select the previously created database (for example, bcmdb ), click Next and then Finish .
  6. In the window that appears click Test Data Source to verify the connection.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Client Management 12.2