cancel
Showing results for 
Search instead for 
Did you mean: 

Slow performance when opening some workflow actions

Question

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

Answer

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'.

Labels: (2)
Version history
Revision #:
62 of 62
Last update:
‎03-12-2019 08:07 PM
Updated by: