Running IQSuite 4.2 with SQL Server 2008 R2

Root Folder
With the release of 4.2 application base, we have moved from SQL 2008 R2 to SQL 2014. This was done to accommodate Windows 8 and 8.1 users: Installing SQL 2008 R2 yielded a message indicating that there were known compatibility issues. While we’ve had no trouble with SQL 2008 R2 on Windows 8, we moved to SQL 2014 in case some clients had concerns about the message.


If you’re running SQL Server 2008 R2 on site, products in the IQSuite 4.2 range won’t really know how to store data in the database. This will lead to cases where the software (IdentityIQ, especially) reports that a person was added successfully but, when checking under Edit Person, the person doesn’t show up.
Similarly, in the IQService, changing a setting, saving it and then pressing the Load button again doesn’t seem to have applied your changes.
To remedy this situation, you need to install the SQL 2014 prerequisites:
  • SQLSysClrTypes
  • Msodbcsql
  • SharedManagementObjects
The components for 64-bit machines are found in \Prerequisite Installation Files\x64 on your installation disc.
The components for 32-bit machines are found in \Prerequisite Installation Files\x86 on your installation disc.
With these installed, your system should run as expected.

Add Feedback