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

  • 26 March 2021
  • 0 replies
  • 75 views

Userlevel 5
Badge +19
ISSUE
After deleting the Nintex Content database, mapping for the content database still remains in Central Administration.
ERROR CODE

Login failed for user 'XXXXXYYYYYY'. Reason: Failed to open the explicitly specified database 'Server NamePath/ Database Name'. [CLIENT: IP Address]

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
NWAdmin.exe -o DetachDatabase command does not work since the database has already been deleted
RELATED LINKS
NWAdmin Guide

0 replies

Be the first to reply!

Reply