So we have a newly installed SP2013 sp1 farm running on WinSRV 2012 r2.
2 WFE / 2 APP / 2 SQL 2012(HA)
Issue is that every night at 3:30-ish.. we have a Critical Error on all Sharepoint boxes.
Event ID 3351 : SQL database login for ´sharepoint_config´ on instance ´sharepointsql13´failed. login failed for user ´domain/servername$´
The google tells me to look all over the place but nothing yet has helped me, the timer service runs as “farm account” and looks allright.
i am quite new at sharepoint so i would like some expert help from you all to add to my knowledge 🙂
Thank you. This one was driving me crazy because the service account was definitely a dbowner on the config db. The Get-SPDatabase | Add-SPShellAdmin -UserName DOMAIN\SERVER1$ command seems to have addressed this issue.
The Issue was still there this morning! and i found out the following!.
the timer job runs a check using a PowerShell call. For some reason, the PowerShell call does not run as the timer job account but the local system account (hence the DOMAINSERVER$).
Those local accounts do not have permissions to run PowerShell commands against the SharePoint farm. Therefore one must allow access to these local accounts by adding them as “Shell Admins”:
So i ran this
Get-SPDatabase | Add-SPShellAdmin -UserName DOMAIN\SERVER1$
Get-SPDatabase | Add-SPShellAdmin -UserName DOMAIN\SERVER2$
Get-SPDatabase | Add-SPShellAdmin -UserName DOMAIN\SERVER3$
Get-SPDatabase | Add-SPShellAdmin -UserName DOMAIN\SERVER4$
Hopefully error will not be there tomorrow!.
Found the solution myself, i will post it here if someone else has this issue sometime 🙂
The account that runs the timer jobs did not have correct access to the Sharepoint_Config database (db_owner)
Problem is..
Sharepoint says all jobs finish OK
Application logs says the above at 3:24 AM
Event ID 3351 : SQL database login for ´sharepoint_config´ on instance ´sharepointsql13´failed. login failed for user ´domain-name/srv1$´
if some job fails? it should show in job status?
if some “account” fails to login to SQL, it should say so in SQL logs on sql machine & Application logs on sharepoint machine?
but now the machine-account fails? towards “sharepoint_config”. ???
for example
srv1 srv2 srv3 srv4 all displays critical error at 3:24 AM
Login failed for user ‘Domain-name\SRV1$’.
Login failed for user ‘Domain-name\SRV2$’.
Login failed for user ‘Domain-name\SRV3$’.
Login failed for user ‘Domain-name\SRV4$’.
Please help? 🙂
