HI i get the following error in one of WFE server in sharepoint 2010 farm, and
Claims to Windows Token Service
Microsoft SharePoint Foundation Web
Application Search Query and Site Settings Service
The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.TraceDiagnosticsProvider (ID 6725ef52-3ce4-48dc-8927-3cb5a74ef152) threw an exception. More information is included below.
Cannot open database "WSS_UsageApplication" requested by the login. The login failed. Login failed for user 'xxx\spfarm'.
Spfarm user has db_owner for wss_usageapplication db.