SQL Server datbase login failed Event ID 3351

usspare
usspare used Ask the Experts™
on
We are unable to perform any bakups of the SharePoint 2010 Site Collection and are getting the SQL Server datbase login failed Event ID 3351 error in the application log on the SharePoint Server every min or so.  the account referenced in the error is not listed in AD, SQL or local machine - not sure where it is coming from.

Extract from Windows Application Log:

Microsoft-SharePoint Products-SharePoint Foundation
   [ Guid]  {6FB7E0CD-52E7-47DD-997A-241563931FC2}
 
   EventID 3351
 
   Version 14
 
   Level 1
 
   Task 3
 
   Opcode 0
 
   Keywords 0x4000000000000000
 
  - TimeCreated

   [ SystemTime]  2010-10-19T02:50:47.980496300Z
 
   EventRecordID 39605
 
   Correlation
 
  - Execution

   [ ProcessID]  3880
   [ ThreadID]  3768
 
   Channel Application
 
   Computer Sharepoint2010.company.Local
 
  - Security

   [ UserID]  S-1-5-18
 

- EventData

  string0 SharePoint_Config
  string1 Company-HV
  string2 Login failed for user 'Company\SHAREPOINT2010$'

SQL Log error:

Login failed for user 'Company\SHAREPOINT2010$'. Reason: Token-based server access validation

Any help would be greatly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
here is the info for that sid:
SID: S-1-5-18
Name: Local System
Description: A service account that is used by the operating system.

You might try using a domain account for the login as described here:
http://technet.microsoft.com/en-us/library/ee513059.aspx


Commented:
The solution that worked for us was to change the SharePoint Time Service from  a local service account to a domain account that has permissions on the SQL server.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial