Product: ImportOmatic
Description: Error: An exception occurred in the Duplicate Search: Error 5.2: The EXECUTE permission was denied
Environment: All
Version: All
Answer:
## 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!
At the bottom of the page is a series of screenshots that show the default settings for REUSER in SQL Management Sudio.
1. Databases\RE7\Security\Users
-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
-Save.
PLEASE NOTE:
Description: Error: An exception occurred in the Duplicate Search: Error 5.2: The EXECUTE permission was denied
Environment: All
Version: All
Answer:
## 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!
At the bottom of the page is a series of screenshots that show the default settings for REUSER in SQL Management Sudio.
1. Databases\RE7\Security\Users
-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
-Save.
PLEASE NOTE:
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(SQL server and Windows Authentication as show in the picture below) 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
-Save.
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.
-Map RE7 to REUSER and REUSER
-Save.
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.