SharePoint 2019 On Premise Error (Event ID 8400, 3351, 5586)

SHUO .H 706 Reputation points
2021-07-30T09:08:43.363+00:00

Hi there,

I got error message from our event viewer as shown below. Does anyone have any idea on it? the error message comes up due to the database failover (NOT failover cluster) changing to secondary. When SharePoint connects to Database, also it(SharePoint) spend 20 mins to 4 hrs on connecting.

Thanks

119576-image.png
119540-image.png

Error 6/24/2021 6:58:04 PM Microsoft-SharePoint Products-SharePoint Foundation 8400 (59)

The description for Event ID 8400 from source Microsoft-SharePoint Products-SharePoint Foundation cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

GetEntries(object transactionContext, string type)
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'HKAIRPORT\AA_SP_SERVICES'.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command)
at Microsoft.SharePoint.DistributedCaching.Utilities.SPDistributedCacheClusterCustomProvider.GetEntries(Object transactionContext, String type)
ClientConnectionId:9dfdccfc-ea35-4d11-aeb9-5dd9eff5a6f7
Error Number:18456,State:1,Class:14

The locale specific resource for the desired message is not present

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,378 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,964 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JoyZ 18,071 Reputation points
    2021-08-02T04:18:16.603+00:00

    @SHUO .H ,

    I want to confirm more information with you to further troubleshoot:

    1. What do you mean "the database failover (NOT failover cluster) changing to secondary"?
    2. Do you change the sql server for current farm?

    For the critical error 3351, please check if the login failed user is added as a user of the SharePoint_Config database and given membership as "db_owner".

    119646-image.png

    Then check whether the error disappears,for errors 5586 and 8840, it may also be caused by insufficient SQL server database permissions.


    If an Answer is helpful, please click "Accept Answer" and upvote it.

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.