question

SHUOH-8693 avatar image
0 Votes"
SHUOH-8693 asked JoyZ commented

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

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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 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


office-sharepoint-server-administrationoffice-sharepoint-server-itpro
image.png (223.2 KiB)
image.png (149.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

@SHUOH-8693,

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.



image.png (34.2 KiB)
· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JulieWang-MSFT,

thanks for your reply.

- What do you mean "the database failover (NOT failover cluster) changing to secondary"?

Because I found out the settings of "Clustered" of SQL Server Properties is No. I don't think currently my SQL server farm is mode of "Failover Cluster". It should be just only have Failover mechanism.

119745-123.jpg


- Do you change the SQL server for current farm? No, I don't change anything for current farm.





0 Votes 0 ·
123.jpg (21.6 KiB)

@SHUOH-8693,

If current SQL server is not part of cluster, it will show "No".

Do you check the permission of SharePoint_Config database for issued user?

If there is any update, please feel free to reply.

0 Votes 0 ·

Hi @JulieWang-MSFT,

"If current SQL server is not part of cluster, it will show "No"." --> Yes, the client's environment shows "No". That means the failover is enabled but not to join a cluster?? Righ?

currently I don't have any update. If I have, will post here once again.

Thanks

0 Votes 0 ·
Show more comments