1

I know my question is very similar to this one; SQL database login for 'Config' on instance '' failed. Additional error information from SQL Server is included below

However in my case the user is NT AUTHORITY\ANONYMOUS LOGON.

Complete Error Message:

SQL database login for 'SharePoint2016_Intranet_ConfigDB' on instance 'SQLServer_1' failed. Additional error information from SQL Server is included below. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I am new to SharePoint Administration. And thus don't know what it will mean giving permission to Anonymous Logon.

Kindly suggest.

1
  • Have you added any warm up script in Task scheduler ? Commented Aug 12, 2020 at 17:42

1 Answer 1

0

Looks like a permssion. check couple of things.

  1. Check if SharePoint Timer Services is running with "Local System" account? Changed it to Domain Account(farm admin) with necessary rights will fixed this issue.
  2. In an another case, "Windows SharePoint Services VSS Writer" service was running with local system account, and I had to change the account to a service account from AD.

Read more: http://www.sharepointdiary.com/2012/02/event-id-3351-sql-database-login-failed.html#ixzz5Es7w90f9

2
  • Hi Waqas, Thanks for the response. We have 4 servers (2 WFE and 2 APP). Checked "SP Timer Service" on all 4 servers. It is running through Farm Admin account. Regarding "Windows SharePoint Services VSS Writer" AKA "SharePoint VSS Writer" is not running. It's Startup is set to Manual. Kindly advise. Thank you. Commented May 8, 2018 at 14:05
  • whats the frequency of the error in your event log? is it on all servers or only one? Commented May 8, 2018 at 14:13

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.