Installing the Microsoft SQL Server Resource Adapter

1. To add this resource to the Identity Manager resources list, you must add the following value in the Custom Resources section of the Configure Managed Resources page.

   com.waveset.adapter.MSSQLServerResourceAdapter

2. If you connect to the resource with the Microsoft SQL Server 2005 Driver for JDBC, copy the mssqlserver.jar file to the InstallDir\idm\WEB-INF\lib directory.

   If you connect to the resource with the Microsoft SQL Server 2000 Driver for JDBC, copy the following jar files from the Program Files\2000 Microsoft SQL Server 2000 Driver for JDBC\lib directory to the InstallDir\idm\WEB-INF\lib directory.

   • msbase.jar

     • mssqlserver.jar

     • msutil.jar

     ---

     Note –

     All connections to SQL Server must be performed using the same version of the JDBC driver. This includes the repository as well as all resource adapters that manage or require SQL Server accounts or tables, including the Microsoft SQL adapter, Microsoft Identity Integration Server adapter, Database Table adapter, Scripted JDBC adapter, and any custom adapter based on these adapters. Conflict errors occur if you attempt use different versions of the driver.

     ---