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
- Run
Get-SPDatabasecommand to confirm that the database connection exists. - Run
Get-SPDatabase | fl name,idto obtain the ID of the NintexForms database. - Run
$db = Get-SPDatabase <ID>. Replace <ID> with the ID number from above. - Run
$db.Delete()to remove the reference from the SQL instance. - Repeat step 1 to verify that it is now removed from the list.
