A family of Microsoft on-premises document management and storage systems.
Hi adil,
The errors point to SQL Server being unable to resolve or authenticate AD accounts, not to a SharePoint fault:
- Event 5586 / SQL 15404: could not obtain information about 'DOMAIN\FarmAcc', error 0x5 (access denied)
- Event 3351: login failed for 'DOMAIN\WEB01$' (machine account) on SP_CONFIG
Please run the following and verify on the SQL Server (use the farm account's domain for <domain>):
- DC discovery and secure channel (elevated prompt): nltest /dsgetdc:<domain> nltest /sc_verify:<domain> The second should end with NERR_Success.
- DNS: nslookup <domain> nslookup <dc_fqdn>
- Reproduce the lookup in SSMS: EXEC xp_logininfo 'DOMAIN\FarmAcc'; If this returns 0x5, the issue is SQL-to-AD, independent of SharePoint.
- Ports to the DC (TCP only; UDP 53/88/389 are not covered by this test): 53,88,135,389,445,3268 | ForEach-Object { Test-NetConnection <DCName> -Port $_ } Also confirm the RPC dynamic range (49152-65535) is open between SQL and the DCs.
- SQL service identity (needs VIEW SERVER SECURITY STATE on SQL 2022): SELECT servicename, service_account FROM sys.dm_server_services;
On WEB01 (and WEB02), check for SharePoint services running as the machine account:
Get-CimInstance Win32_Service | Where-Object { $_.Name -match '^(SPTimerV4|SPAdminV4|SPTraceV4|SPWriterV4|AppFabricCachingService)$' } | Select-Object Name, StartName
Any service showing LocalSystem or NetworkService should be moved to a domain account.
If the farm account is in a different domain from SQL, please also confirm the trust direction and any selective authentication. Please also review the GPOs applied to the SQL Server for restrictions on remote SAM calls or NTLM.
For the failures, check the SQL ERRORLOG (login failure state), the Security log on SQL and the DC, and the SharePoint ULS logs around the event timestamps.
For reference:
MSSQLSERVER_15404 - SQL Server | Microsoft Learn
However, if the issue persists, please create a ticket online or contact our support by signing in to Engage Center.
This route ensures that a Microsoft support engineer can initiate a remote session to investigate backend configurations, run advanced diagnostic tools, and, if necessary, you can request to escalate the case to specialized teams with access to internal systems and logs. These backend resources are essential for resolving issues that go beyond what’s visible in the user interface.
As community moderators, we’re here to guide you, but due to privacy and security limitations, we don’t have access to the backend tools required for a full resolution. For this reason, contacting Microsoft Support via the Engage Center is the most secure and efficient way forward.
I hope this helps you resolve the issue quickly. I’m glad to assist and truly hope the information provided has been useful. Please feel free to reach out anytime if you need further assistance.
Thank you for your kindness and contributions to the forum.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.