No ratings

Slow performance when opening some workflow actions


Why does application pool account need execute permissions on the stored procedure proc_MSS_GetSchemaHighLevelInfo in the search database?



Nintex Workflow required this permission to run. During the workflow designing phase, some of the action’s configuration screen is reusing the SharePoint User Lookup feature. This feature will require the permission to run the stored procedure in the search database
During Nintex workflow installation, the process will not add the permissions as installer does not have access to the database directly.
The Database administrator will be required to grant the correct permission to the search database.

Suggested permission level
1. Grant App Pool Account login permissions on Search DB 
2. Grant App Pool Account execute permission on proc_MSS_GetSchemaHighLevelInfo



Additional Information

Sample of error log in ULS
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SP2013_ SearchDatabase'" requested by the login. The login failed.  Login failed for user 'MYDOMAIN\{MyAppPoolAccount}.
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'proc_MSS_GetSchemaHighLevelInfo', database 'SP2013_SearchDatabase', schema 'dbo'.


Version history
Last update:
‎11-14-2020 12:38 AM
Updated by: