Event ID 3760, Sharepoint 2010 - Cannot open database


Every hour I get the attached error message in our application eventlog.

We deleted our old Search Service Application due to config problems, and created a new Search Service App using new databases. The new search app seems to work correctly, but every hour this event is logged. I've searched through all of the service applications under "Manage Service Applications" in the Sharepoint 2010 CA, but can't seem to find any applications referring to the mentioned database.

The database itself is not existing anymore - we are now using "Search_Service_Application_v2_CrawlStoreDB_xxxxxxxxxxxx". How can I determine which application is trying to connect to this db - and how to stop it from trying to do so ?

Any help greatly appreciated!
Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          31.03.2011 02:00:01
Event ID:      3760
Task Category: Database
Level:         Critical
User:          Domain\SP_Farm
Computer:      Servername.domain.local
SQL Database 'Search_Service_Application_CrawlStoreDB_4817bcd57932487cad1af5c2e0bf151d' on SQL Server instance 'SQLserver\sharepoint' not found. Additional error information from SQL Server is included below.

Cannot open database "Search_Service_Application_CrawlStoreDB_4817bcd57932487cad1af5c2e0bf151d" requested by the login. The login failed.
Login failed for user 'Domain\SP_Farm'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <TimeCreated SystemTime="2011-03-31T00:00:01.653949100Z" />
    <Correlation ActivityID="{1AA01392-5A95-4A16-A601-7BFD7C451F36}" />
    <Execution ProcessID="2240" ThreadID="2504" />
    <Security UserID="S-1-5-21-2812511754-123718817-1394069073-3146" />
    <Data Name="string0">Search_Service_Application_CrawlStoreDB_4817bcd57932487cad1af5c2e0bf151d</Data>
    <Data Name="string1">SQLserver\sharepoint</Data>
    <Data Name="string2">Cannot open database "Search_Service_Application_CrawlStoreDB_4817bcd57932487cad1af5c2e0bf151d" requested by the login. The login failed.
Login failed for user 'Domain\SP_Farm'.</Data>

Open in new window

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I had the same issues a while back, this post was exactly what helped me out.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.