Monday, December 29, 2014

Event 3760 – SQL Database on SQL Server Instance not found in Event Log in SharePoint Server


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.

No comments:

Post a Comment

SharePoint 2013 - ADFS - Configuration

The main objective of this post is to provide detailed configuration steps on how to set up SAML Authentication for SharePoint 2013/2016 w...