SQL Server Alert "Failed to open the explicitly specified database 'NintexForms'"

Document created by butlerj Support on Nov 30, 2018
Version 1Show Document
  • View in full screen mode
ISSUE
When viewing SQL server logs report, the following login failure is repeatedly logged:

Login failed for user '<username>'. Reason: Failed to open the explicitly specified database 'NintexForms'.
ERROR CODE
SQL Server Alert System: 'Insufficient Permissions' occurred on DESCRIPTION: Login failed for user ''. Reason: Failed to open the explicitly specified database 'NintexForms'.
RESOLUTION
  1. Run Get-SPDatabase command to confirm that the database connection exists.
  2. Run Get-SPDatabase | fl name,id to obtain the ID of the NintexForms database.
  3. Run $db = Get-SPDatabase <ID>. Replace <ID> with the ID number from above.
  4. Run $db.Delete() to remove the reference from the SQL instance. 
  5. Repeat step 1 to verify that it is now removed from the list.
ADDITIONAL INFORMATION
RELATED LINKS

Attachments

    Outcomes