Skip to main content
Nintex Community Menu Bar

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

  • March 26, 2021
  • 0 replies
  • 87 views
  • Translate
butlerj
Nintex Employee
Forum|alt.badge.img+20
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
    Did this topic help you find an answer to your question?

    0 replies

    Be the first to reply!

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings