Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Slow performance when opening some workflow actions

    Status: Pending Clean Up

    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'.
    RELATED LINKS
    • Was this article helpful?