Udostępnij za pośrednictwem

Event ID 3760 is logged on the server as the timer job is trying to locate a non-existent database

  • Artykuł

Symptoms

While we access the SharePoint application server, we receive these event ID
error messages in the event viewer

Log Name : Application
Source :        
Microsoft-SharePoint Products-SharePoint Foundation
Date : <Date and Time>
Event ID : 3760
Task Category : Database
Level : Critical
Keywords :     
User : domain\farmaccount
Computer : <Servername>
Description :
SQL Database 'database_name' on SQL
Server instance 'sql_instance' not found. Additional error information from SQL
Server is included below.
Cannot open database "database_name" requested by the login. The login failed.
Login failed for user 'domain\farmaccount'.

 

Cause

The service application was not removed in the proper format, leaving behind orphan entries for databases.

 

Resolution

Deleted the Orphan Entries using PowerShell
Commands:

Get-SPDatabase | where {$_.name -match "<Name of the Service Database>"} | fl
$db = get-spdatabase | where {$_.id -match "<ID enumerated of the Database from above command>"}
$db.Delete()

Comments

  • Anonymous
    December 08, 2014
    Excellent and to the point help Allen, Thanks.

  • Anonymous
    December 31, 2015
    Nice.. one thanks

  • Anonymous
    February 22, 2016
    Thanks. This worked great. Our errors were from a poorly removed SQL Reporting Services. So, I had to search for the service name, ReportingService, instead of the database names that were causing the error. Then I got the old databases and new ones returned by the first command. I was then able to repeat the second and third commands for each of the three Reporting Services databases. Now they are all gone and the errors are gone.