ISSUEWhen 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 CODESQL Server Alert System: 'Insufficient Permissions' occurred on DESCRIPTION: Login failed for user ''. Reason: Failed to open the explicitly specified database 'NintexForms'.
Get-SPDatabasecommand to confirm that the database connection exists.
Get-SPDatabase | fl name,idto obtain the ID of the NintexForms database.
$db = Get-SPDatabase <ID>. Replace <ID> with the ID number from above.
$db.Delete()to remove the reference from the SQL instance.
- Repeat step 1 to verify that it is now removed from the list.