Sharepoint 2019 psconfig run automatically

Question

Hello,

Few days ago we've noticed around 01:21 AM new PSCDiagnostics log is created on every server in the farm every day, meaning configuration wizard is running via command line and not manually.
Our last CU update was 2 months ago and of course we run Configuration Wizard on every server without any error. No updates were installed since then.

Begin trace logging for SharePoint 2019 Products Configuration Wizard. Version 16.0.10388.20004
12/20/2022 01:21:21 1 INF Entering function PsconfigCommandLineMain.Main

Following the log we see the error:
12/20/2022 01:21:21 1 INF Beginning the BaseTaskDriverModule.Run() for the psconfig.exe module
12/20/2022 01:21:21 1 INF Entering function CommandLine.Run
12/20/2022 01:21:21 1 INF Starting to parse the command-line
12/20/2022 01:21:21 1 INF Entering function CommandLine.Parse
12/20/2022 01:21:21 1 INF Found command line arguments, so will start parsing and validating
12/20/2022 01:21:21 1 INF CommandLine.IsCommand: The arg -? is not a command cmd
12/20/2022 01:21:21 1 INF -? argument is not a command key
12/20/2022 01:21:21 1 INF CommandLine.IsCommand: The arg -? is not a command help
12/20/2022 01:21:21 1 INF CommandLine.IsCommand: The arg -? is a command ? using delimiter -
12/20/2022 01:21:21 1 INF The command is the general help command ?
12/20/2022 01:21:21 1 INF Entering function CommandLine.ShowGenericHelp
12/20/2022 01:21:21 1 INF Entering function CommandLine.ShowGenericUsage
12/20/2022 01:21:21 1 INF Entering function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF Assembly name is PSCONFIG.EXE
12/20/2022 01:21:21 1 INF Leaving function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF Generic help is PSCONFIG.EXE -cmd <Command> [Parameters]
12/20/2022 01:21:21 1 INF Entering function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF Assembly name is PSCONFIG.EXE
12/20/2022 01:21:21 1 INF Leaving function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF Specific help usage is PSCONFIG.EXE -help [Command]
12/20/2022 01:21:21 1 INF Entering function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF Assembly name is PSCONFIG.EXE
12/20/2022 01:21:21 1 INF Leaving function Common.GetAssemblyName
12/20/2022 01:21:21 1 INF General help usage is PSCONFIG.EXE -?
12/20/2022 01:21:21 1 INF Leaving function CommandLine.ShowGenericUsage
12/20/2022 01:21:21 1 INF Leaving function CommandLine.ShowGenericHelp
12/20/2022 01:21:21 1 INF Leaving function CommandLine.Parse
12/20/2022 01:21:21 1 INF Command line was parsed successfully, but we were told to show help
12/20/2022 01:21:21 1 INF Leaving function CommandLine.Run
12/20/2022 01:21:21 1 INF The task driver module psconfig.exe successfully ran but BaseTaskDriverModule.Run() returned false and this tells me to stop without failure
12/20/2022 01:21:21 1 INF Entering function TaskDriver.Stop
12/20/2022 01:21:21 1 INF Entering function StringResourceManager.GetResourceString
12/20/2022 01:21:21 1 INF Resource id to be retrieved is PostSetupConfigurationSucceeded for language English (United States)
12/20/2022 01:21:21 1 INF Resource retrieved id PostSetupConfigurationSucceeded is Configuration of the SharePoint Products has succeeded.
12/20/2022 01:21:21 1 INF Leaving function StringResourceManager.GetResourceString
12/20/2022 01:21:21 1 INF Entering function TaskDriver.OnTaskDriverStop
12/20/2022 01:21:21 1 INF Sending a task driver stop event: TaskDriverEventArgs.EventCriticalityType info, TaskDriverEventArgs.EventType.stop,
12/20/2022 01:21:21 1 INF Entering function TaskDriverStateChange.Enter
12/20/2022 01:21:21 1 INF Acquiring the writer lock to change the state
12/20/2022 01:21:21 1 INF Current state of the task driver is neverrun. You want to change it to stoppedrunning
12/20/2022 01:21:21 1 INF Changed state of the task driver to neverrun
12/20/2022 01:21:21 1 INF Released the writer lock to change the state
12/20/2022 01:21:21 1 INF Leaving function TaskDriverStateChange.Enter
12/20/2022 01:21:21 1 INF Entering function TaskDriver.FireOnTaskDriverEvent
12/20/2022 01:21:21 1 INF Entering function CommandLine.TaskDriverEventHandler
12/20/2022 01:21:21 1 INF Received a TaskDriverEventHandler: TaskDriverEventArgs.EventCriticalityType info, TaskDriverEventArgs.EventType stop, message
12/20/2022 01:21:21 1 INF Leaving function CommandLine.TaskDriverEventHandler
12/20/2022 01:21:21 1 INF Leaving function TaskDriver.FireOnTaskDriverEvent
12/20/2022 01:21:21 1 INF Leaving function TaskDriver.OnTaskDriverStop
12/20/2022 01:21:21 1 INF Leaving function TaskDriver.Stop
12/20/2022 01:21:21 1 INF UnLocking the task driver for exclusive use while we ran tasks
12/20/2022 01:21:21 1 INF Leaving function TaskDriver.Run
12/20/2022 01:21:21 1 ERR Post setup configuration was not run successfully when using the command line task driver module

While it fails, we see some attempts accessing "config" database with anonymous user:

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

From ULS log we see that as well:
12/20/2022 01:21:21.47 Medium Could not determine SQL engine edition
12/20/2022 01:21:21.47 High System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 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(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SharePoint.Utilities.SqlSession.IsSqlEngineEdition(SPSqlServerEngineEdition sqlEdition) ClientConnectionId:dd334d9b-c818-4e08-a285-ebb5432dfc15 Error Number:18456,State:1,Class:14 12/20/2022 01:21:21.47 High at Microsoft.SharePoint.Utilities.SqlSession.get_IsSqlAzure() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.FetchId(QualifiedObjectName qName, Boolean& querySucceeded) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(String name, Guid parentId, Type type) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.get_Farm() at Microsoft.SharePoint.Administration.SPDatabase.OnDeserialization() at Microsoft.SharePoint.Administration.SPConfigurationDatabase.OnDeserialization() at Microsoft.SharePoint.Administration.SPPersistedObject.OnDeserializationWithTrace() at Microsoft.SharePoint.Administration.SPPersistedObject.Initialize(ISPPersistedStoreProvider persistedStoreProvider, Guid id, Guid parentId, String name, SPObjectStatus status, Int64 version, XElement state) at Microsoft.SharePoint.Administration.SPFileSystemCache.FetchObjectFromFileSystem(Guid id, Boolean idFieldsOnly, SPPersistedObjectContainerFields& fields) at Microsoft.SharePoint.Administration.SPFileSystemCache.GetValue(Guid id) at Microsoft.SharePoint.Administration.SPCache2.get_Item(K key) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(Guid id, Boolean checkInMemoryCache, Boolean checkFileSystemCache, Boolean checkDatabase) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Initialize(SqlConnectionStringBuilder connectionString, Boolean enableCaching, Boolean checkCompatibility, Boolean bindRequestGuid) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Initialize(SqlConnectionStringBuilder connectionString, Boolean enableCaching, Boolean checkCompatibility) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.get_Local() at Microsoft.SharePoint.Administration.SPFarm.FindLocal(SPFarm& farm, Boolean& isJoined) at Microsoft.SharePoint.Administration.SPFarm.get_Local() at Microsoft.SharePoint.Administration.SPWebService.get_ContentService() at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetAssembliesForDatabaseExtensions(List1 list) at Microsoft.SharePoint.Upgrade.SPDelegateManager.get_InitialTypeDictionary() at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegateTypes(Type tpObject) at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegates(Object o) at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetUpgraders(Object o) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.CanUpgrade(Object o) at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_CanUpgrade() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveCanUpgrade(Object o) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_NeedsUpgrade() at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.ValidateBackwardsCompatibility() at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Initialize(SqlConnectionStringBuilder connectionString, Boolean enableCaching, Boolean checkCompatibility, Boolean bindRequestGuid) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Initialize(SqlConnectionStringBuilder connectionString, Boolean enableCaching, Boolean checkCompatibility) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.get_Local() at Microsoft.SharePoint.Administration.SPFarm.FindLocal(SPFarm& farm, Boolean& isJoined) at Microsoft.SharePoint.Administration.SPFarm.get_Local() at Microsoft.SharePoint.Administration.SPServer.get_Local() at Microsoft.SharePoint.PostSetupConfiguration.Common.StartAllServices() at Microsoft.SharePoint.PostSetupConfiguration.PsconfigCommandLineMain.Main(String[] args) 12/20/2022 01:21:21.47 High SqlError: 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.' Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 65536 Server: 'SQL' 12/20/2022 01:21:21.49 Critical SQL database login for 'Farm_Config' on instance 'SQL' failed. Additional error information from SQL Server is included below. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 12/20/2022 01:21:21.49 High ConnectionString: 'Data Source=SQL;Initial Catalog=Farm_Config;Integrated Security=True;Persist Security Info=False;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;PoolBlockingPeriod=Auto;Asynchronous Processing=False;Connection Reset=True;MultipleActiveResultSets=False;Replication=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Load Balance Timeout=0;Packet Size=8000;Type System Version=Latest;Application Name=SqlSession[PSCONFIG][1][Farm_Config];User Instance=False;Context Connection=False;Transaction Binding="Implicit Unbind";ApplicationIntent=ReadWrite;MultiSubnetFailover=False;TransparentNetworkIPResolution=True;ConnectRetryCount=1;ConnectRetryInterval=10;Column Encryption Setting=Disabled' Partition: NULL ConnectionState: Closed ConnectionTimeout: 60 ConnectionClientId:00000000-0000-0000-0000-000000000000 12/20/2022 01:21:21.49 High SqlCommand: 'dbo.proc_getObjectsByClass' CommandType: StoredProcedure CommandTimeout: 30 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@ClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '674da553-ea77-44a3-b9f8-3f70d786de6a' Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '' Parameter: '@Name' Type: NVarChar Size: 0 Direction: Input Value: '' Parameter: '@RequestGuid' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'deed83a0-6eea-10ab-756c-c8e8ac136a7f' 12/20/2022 01:21:21.49 High SecurityOnOperationCheck = False 12/20/2022 01:21:21.49 Monitorable **Exception when querying Name for [Name:],[Parent:00000000-0000-0000-0000-000000000000]**, [type:Microsoft.SharePoint.Administration.SPFarm]. Exception: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 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(TaskCompletionSource1 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, CommandBehavior behavior) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.FetchId(QualifiedObjectName qName, Boolean& querySucceeded) ClientConnectionId:dd334d9b-c818-4e08-a285-ebb5432dfc15 Error Number:18456,State:1,Class:14
12/20/2022 01:21:21.49 Monitorable Can not find farm object in configuration database

I tried running manually Configuration Wizard and it completes without any error, also cleared farm cache.

Open to ideas.
Thanks

Answer 1

@Sergey Pelikh

Please go to Windows Services to check SharePoint Timer Service is running with a farm account. Then reboot the server to check whether this issue exists.

And you could go to Event Viewer to find more clues, such as Event ID.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.