Event 3760 – SQL Database on SQL Server Instance not found

Problem

The event log on my WFE is filled with errors every hour complaining that a database on my SharePoint SQL instance is not found.

Cause

This was caused by me creating and deleting a service application, and then going into SQL Management Studio and manually deleting the associated service application database. SharePoint still had a record of the database in its config database.

Solution

Delete the record of the orphaned database using PowerShell

  1. Open SharePoint Management Shell
  2. Type: Get-SPDatabase | fl name, id
  3. Find the database you wish to remove and select its ID.
  4. Type: $pp = get-spdatabase <id>
  5. Type: $pp.delete()

SharePoint’s record of the database is now deleted and it should no longer complain that the database is not found.

Tags: ,

3 Responses to “Event 3760 – SQL Database on SQL Server Instance not found”

  1. Levente Rög March 19, 2013 at 1:14 am #

    that worked with SharePoint 2013, thanks!

  2. entropy2go May 14, 2013 at 10:27 pm #

    Just what I was looking for! I was getting these errors every hour in my event logs. I had uninstalled and reinstalled Reporting services in SharePoint integrated mode and had the old database entries for reporting in the DB. Thanks!

  3. Nick June 6, 2013 at 9:22 pm #

    Perfect, Andrew! Thanks for sharing :O)

Leave a Reply

%d bloggers like this: