1

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?

6
  • 1
    Service Accounts? May 29, 2013 at 14:56
  • In what sense are you talking? I am using Windows authentication May 29, 2013 at 15:13
  • did you used NetworkService for any Service Accounts - e.g in the case of Web Application Pools? May 29, 2013 at 15:29
  • The SharePoint application pool account in IIS is set to 'DomainName\SPAdmin' May 29, 2013 at 15:32
  • You still need to make these changed in central administration May 29, 2013 at 15:55

2 Answers 2

2

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

9
  • Are you referring to the 'Claims to Windows Token Service'? May 29, 2013 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. May 29, 2013 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. May 29, 2013 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 May 29, 2013 at 18:37
  • 1
    Glad you did let me know if you need help again Jun 17, 2013 at 13:37
-1

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

1
  • 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, 2015 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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