Description: Error: An exception occurred in the Duplicate Search: Error 5.2: The SELECT permission was denied on the object
***The following items need to be done by the SQL Server Administrator.***
***It is independent of the RE logins/users.***
Please check all of the following, and add anything that is missing. DO NOT turn off/revoke anything that is already granted!
If REUSER exists, edit its permissions (in the properties); if it does not exist, add it.
Grant the following permissions:
REUSER = DBOwner or RE_ReadOnly
Default Schema = REUSER
If you have your SQL server set to only use Windows Authentication, then the permissions above must be set for each SQL user accessing the RE database, not just for REUSER. If you are not using Windows Authentication, or are or are using mixed mode, for your SQL server, then setting the permissions just for REUSER should suffice.
2. Security\Logins\REUSER\Properties\User Mapping
Map RE7 to REUSER and REUSER
3. If the above settings don't correct the error, then set up the custom connection in IOM
Database = RE7 DB Name
Server = Server Name in the SQL Server instance
Username = REUSER
Password = REUSER SQL Password
*Note: The SQL Administrator can set up another User and Password for this custom connection. It does not have to be REUSER, though that's the default one RE installs and uses.
**If you are choosing another User Name, that User will also need the DBOwner or RE_ReadOnly permissions, as above.