While trying to patch this SP 2010 farm I came across this (take a look at the picture). Is there any way to fix this? enter image description here

The DB is there alive and well on the SQL

enter image description here

1 Answer 1


There are couple of reasons for this

  • Make Sure Search Database exist on the SQL server
  • Make sure SharePoint accounts have the permission on the that database( account which is running the app pool of search service app).
  • Also check if Database is offline at SQL.

We had same issue with one of Content DB, where we found for some reason, DBA deleted the database at sql without informing us.

  • didn't help. database is there. there is actually a Search DB 2 also. can this be messing it up?
    – Cherubel
    Commented Feb 25, 2016 at 14:52
  • where is search DB2? on sharepoint or on sql?
    – Waqas Sarwar MVP
    Commented Feb 25, 2016 at 15:25
  • the DB2 is on the SQL server
    – Cherubel
    Commented Feb 29, 2016 at 6:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.