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?

  • 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? – Marius Constantinescu - 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

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

|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

Change impersonate to false in web config file. By default it will be true. identity impersonate="false" />

|improve this answer|||||
  • Would you be able to add some more information please :) , like what could be the possible location of web.config file. So that it will be easy for users to track. – Asad Refai Jul 27 '15 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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