- SQL SERVER
- The account which is running the app pool of the web application
- Right Click-Properties
- Database role membership
Monday, March 4, 2013
Failed to open a connection to the Nintex Workflow configuration database
Here we go with another new issue and easy resolutions & workarounds
This time, the issue was with Nintex workflows at the time of activating a site collection feature. Let me describe the details in step by step so that it will be easy recognize as well as understand
Problem activating Site Feature. While activating the ‘Nintex workflow 2010’ at the site collection level, we faced the following error message:
An unexpected error has occurred.
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: XXXXX
1) Most imp regarding any exceptions: SharePoint logs (\14\logs)-specifically if we face “unexpected error”
2) Windows event logs
3) If we have a correlation id then it’s very easy to find out the exact error message
After reviewing the SP logs, this is what I found:
Exception was thrown while ensuring dependencies met for feature 'NintexWorkflow' (id: 0561d315-d5db-4736-929e-26da142812c5): Nintex.Workflow.NWFeatureActivatingException: Nintex.Workflow.NW2007DatabaseConnectionException: Failed to open a connection to the Nintex Workflow configuration database. ---> System.Data.SqlClient.SqlException: Cannot open database "NW2007WFDB" requested by the login. The login failed. Login failed for user 'Contoso\Administrator'.
What we need to target first in such conditions:
1. What exactly the app pool identity is used by that web application? Does it have sufficient rights/not?
2. The Nintex database has a role called WSS_Content_Application_Pools. This is the group that we need to add the app pool identity to
I have added this group named as WSS_Content_Application_Pools to the APP POOL identity and that it. It worked and issue has been successfully resolved