cancel
Showing results for 
Search instead for 
Did you mean: 

Error "Login failed for user" in SQL After Deleting Content Database

ISSUE
After deleting the Nintex Content database, mapping for the content database still remains in Central Administration and errors similar to the following occur in SQL:

Login failed for user 'XXXXX\YYYYYY'. Reason: Failed to open the explicitly specified database 'Server Name\Path/ Database Name'. [CLIENT: IP Address]
ERROR CODE
RESOLUTION
Before performing the below actions create a backup of the SQL database
  1. In the SQL instance that contains the content database, expand the Databases folder.
  2. Expand the Nintex config database (Often Called NW20XXDB).
  3. Right-click on dbo.databases and click "Edit Top 200 Rows".
  4. Delete the entry for the deleted Nintex content database.
  5. Log on to a SharePoint Web Font End server and perform an IIS reset.
ADDITIONAL INFORMATION
This method can be used for 2010 and 2013.

NWAdmin.exe -o DetachDatabase command does not work since the database has already been deleted
RELATED LINKS
To correctly delete Nintex content databases use the NWAmin tool. Below are links to documents on how to use the tool:
NWAdmin Operations - Nintex Workflow 2013
NWAdmin Operations - Nintex Workflow 2010
Version history
Revision #:
1 of 1
Last update:
‎12-18-2018 02:27 PM
Updated by: