SQL database login for 'ConfigDB' on instance ' failed.

shoab shah

8y1.8k

I know my question is very similar to this one; https://sharepoint.stackexchange.com/questions/179904/sql-database-login-for-config-on-instance-failed-additional-error-informat

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Open the PowerShell using Super admin
Run below command
$contentDB = Get-SPDatabase | ?{$_.Name -eq "wss_content"}
Add-SPShellAdmin -UserName "NT AUTHORITY\ANONYMOUS LOGON" -database $contentDB
0
shoab shah8y ago
Hi RajKiran,
Thank you for your response. Have gone through the shared link. However am concerned to go ahead and grant permissions to Anonymous user. Could you please elaborate your thought.
Thank you.
0
Rajkiran Swain8y ago
https://technet.microsoft.com/en-us/library/ee513059(v=office.14).aspx
0