IM InfoSphere Identity Insight, Version 8.0

Configuring client authentication for Microsoft SQL Server databases

Set up Microsoft SQL Server to use client authentication.

  1. Ensure that the system DSN uses Windows NT authentication and not SQL Server authentication. Or, create a new system DSN using Windows NT authentication.
  2. Ensure that the database administrator user exists in the Microsoft SQL Server Enterprise Manager. Grant at least public and db_owner database access to the administrator for each product database. Set the default database to the entity database.
  3. Ensure you have the Type-1 ODBC Bridge JDBC driver.
  4. Create a database user (non-operating system) who has access to the entity database.
  5. Enable trusted authentication when installing the product. Use the database user (non-operating system) when asked for database credentials in the product installer.


Feedback

Last updated: 2009