BC 14 Service is not starting in service & also instance is also not starting.

ShivaKrishna

Installed BC 14 month ago, i was worked fine, but now server instance is not starting, and i also viewed the event log.I got this error. Please help on me, very urgent, thank you
Server instance: SampleBC
Category: SqlConnection
ClientSessionId: 00000000-0000-0000-0000-000000000000
ClientActivityId: 00000000-0000-0000-0000-000000000000
ServerSessionUniqueId: 00000000-0000-0000-0000-000000000000
ServerActivityId: dc6aa393-cc83-429e-b17a-beab8b3a4ab1
EventTime: 05/27/2023 14:25:42
Message (SqlException): This message had personal data removed. The original may still be in transient telemetry. Find it using the transientTelemetryId.
RootException: SqlException
ExceptionStackTrace:
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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
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.Dynamics.Nav.Runtime.NavSqlConnection.TryConnect()
CallerStackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.TryConnect()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass119_0.<ExecuteAction>b__0()
at Microsoft.Dynamics.Nav.Types.NavThread.<>c__DisplayClass30_0.<RunExternalAction>b__0()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass122_0.<ExecuteActionWithTrace>b__0(Stopwatch watch)
at Microsoft.Dynamics.Nav.Diagnostic.NavDiagnostics.<>c__DisplayClass76_0.<SendTraceTagOnThreshold>b__0(Stopwatch watch)
at Microsoft.Dynamics.Nav.Diagnostic.NavDiagnostics.SendTraceTagOnThreshold[T](String tag, Category category, Verbosity verbosity, Int32 threshold, Func`2 action, PrivacyClassification classification, Func`1 includedMessage, String message, Func`1 parameters)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteActionWithTrace(EventTask task, String tenantId, Int32 sessionId, String userName, Action action, String commandText, Boolean isAdoCommand)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.OpenConnectionIfNeeded()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope.AcquireSqlConnectionFromPool(NavDatabase database, Boolean requireExclusiveConnection, TransactionType transactionType, NavSqlConnection lastUsedSqlConnection)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope..ctor(NavDatabase database, Boolean requireNewConnection, TransactionType transactionType, Boolean tryReuseConnection, NavSqlConnection lastUsedSqlConnection, Boolean requireExclusiveConnection)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope.Create(NavDatabase database, TransactionType transactionType)
at Microsoft.Dynamics.Nav.Runtime.NavSqlMetadataCommands.TableExists(NavDatabase database, String tableName)
at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseProperties.ReadDatabaseVersionNo()
at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseProperties.CheckDatabaseVersion()
at Microsoft.Dynamics.Nav.Runtime.NavDatabase.VerifyConnection(Int32 attemptCount)
at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.AddSystemTenant(String appDatabaseServerName, String appDatabaseName, String appDatabaseUserName, ProtectedDatabasePassword appDatabasePassword, Boolean verifyConnection, String newEncryptionKey, IDatabasePasswordPublicEncryptionKeyStorage keyStorage, Boolean allowOverwritePublicKey, Boolean verifyServerInstanceKey)
at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.AddSingleLegacyTenant(String databaseServerName, String databaseName, String databaseUserName, ProtectedDatabasePassword databasePassword, EncryptionProvider encryptionProvider, AzureKeyVaultSettings azureKeyVaultSettings)
at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.ConfigureTenants(ServerUserSettings settings, String encryptionKey)
at Microsoft.Dynamics.Nav.Runtime.NavTaskFactory.<>c__DisplayClass11_0.<StartNewTask>b__0()
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)


ProcessId: 15632
Tag: 000018R
ThreadId: 12
CounterInformation:

ShaiHulud

Could it be that the service account running the BC server instance had its password expire or it was changed?

ShivaKrishna

no