Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The SharePoint logs, as well as in the event viewer keep popping up the following error:

'SQL database login for 'DBTable' on instance 'DatabaseServer' failed. Login failed for user 'domain\WebServerMachine$'

The strange thing is that I can access and return data from the database. All the webpages load fine.

I just can't seem to get rid of this error. Any Ideas?

share|improve this question
1  
Service Accounts? –  RJ Cuthbertson May 29 '13 at 14:56
    
In what sense are you talking? I am using Windows authentication –  TeddyRuxpin May 29 '13 at 15:13
    
did you used NetworkService for any Service Accounts - e.g in the case of Web Application Pools? –  C. Marius - MVP May 29 '13 at 15:29
    
The SharePoint application pool account in IIS is set to 'DomainName\SPAdmin' –  TeddyRuxpin May 29 '13 at 15:32
    
You still need to make these changed in central administration –  Joseph D Surgeon May 29 '13 at 15:55

1 Answer 1

up vote 1 down vote accepted

This is due to you having localSystem as a service account that accesses the database.. on the database in question add the user domain\machinename$ to the security group... I wouldn't recommend this because this is a highly priviledged account. it is best to create a new service account and change the service account sharepoint uses in central administration and give that account the necessary permissions to your database which is usuall DbOwner and dbBackupOperator

share|improve this answer
    
Are you referring to the 'Claims to Windows Token Service'? –  TeddyRuxpin May 29 '13 at 16:40
    
All my services are configured in the 'Configure Service Accounts' to use an account 'SPAdmin', instead of 'Local System'. That account is db_owner on all SharePoint db's. I am still getting the error. –  TeddyRuxpin May 29 '13 at 17:09
    
I am not absolutely sure but i know that account you were referencing is a localsystem account. One of your services are configured to use that account. check central administration and the services area on your win2k8 box. it would use SPAdmin if it were configured to use it.. make sure you are not overlooking a service. –  Joseph D Surgeon May 29 '13 at 17:53
    
Thanks for the suggestion. All the service accounts are configured to use my 'domain\SPAdmin' account. And I did an IIS Reset. I don't see what else there is to do –  TeddyRuxpin May 29 '13 at 18:37
1  
Glad you did let me know if you need help again –  Joseph D Surgeon Jun 17 '13 at 13:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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