Octopus server is not starting as it is not able to connect to sql server

Hi,
I am not able to start octopus server. It is giving following error

Login failed for user ‘SPRINGERNATURE\SENLDOGO5501$’.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘SPRINGERNATURE\SENLDOGO5501$’.
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 Nevermore.Transient.RetryPolicy.<>c__DisplayClass26_0.<ExecuteAction>b__0() at Nevermore.Transient.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Nevermore.RelationalTransaction…ctor(RelationalTransactionRegistry registry, RetriableOperation retriableOperation, IsolationLevel isolationLevel, ISqlCommandFactory sqlCommandFactory, JsonSerializerSettings jsonSerializerSettings, RelationalMappings mappings, IKeyAllocator keyAllocator, IRelatedDocumentStore relatedDocumentStore, String name)
at Nevermore.RelationalStore.BeginTransaction(RetriableOperation retriableOperation, String name)
at Octopus.Core.Repositories.ConfigurationStore.Get[TDocument](String id) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Core\Repositories\ConfigurationStore.cs:line 26
at Octopus.Core.WebPortal.WebPortalConfigurationStore.GetDocProperty[T](Func2 getter) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Core\WebPortal\WebPortalConfigurationStore.cs:line 125 at Octopus.Server.Web.OctopusWebBootstrapper.ConfigureConventions(NancyConventions nancyConventions) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\OctopusWebBootstrapper.cs:line 106 at Nancy.Bootstrapper.NancyBootstrapperBase1.Initialise()
at Octopus.Server.Web.OctopusNancyHost…ctor(INancyBootstrapper bootstrapper, HostConfiguration configuration, Uri[] baseUris) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\OctopusNancyHost.cs:line 94
at Octopus.Server.Web.WebServerInitializer.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\WebServerInitializer.cs:line 36
at Octopus.Server.OctopusServerEngine.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\OctopusServerEngine.cs:line 65
at Octopus.Server.Commands.RunCommand.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Commands\RunCommand.cs:line 48
at Octopus.Shared.Startup.AbstractCommand.Octopus.Shared.Startup.ICommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions, String displayName, String version, String informationalVersion, String[] environmentInformation, String instanceName) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\AbstractCommand.cs:line 78
at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\OctopusProgram.cs:line 235
at Octopus.Shared.Startup.WindowsServiceHost.<>c__DisplayClass1_0.b__0() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\WindowsServiceHost.cs:line 20
at Octopus.Shared.Startup.WindowsServiceAdapter.RunService() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\WindowsServiceAdapter.cs:line 44
ClientConnectionId:b4923fa0-1953-4b91-84ae-97b15d60f2b1
Error Number:18456,State:1,Class:14
2019-12-23 10:54:49.2309 7 FATAL Unhandled AppDomain exception occurred: Login failed for user ‘SPRINGERNATURE\SENLDOGO5501$’.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘SPRINGERNATURE\SENLDOGO5501$’.
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 Nevermore.Transient.RetryPolicy.<>c__DisplayClass26_0.<ExecuteAction>b__0() at Nevermore.Transient.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Nevermore.RelationalTransaction…ctor(RelationalTransactionRegistry registry, RetriableOperation retriableOperation, IsolationLevel isolationLevel, ISqlCommandFactory sqlCommandFactory, JsonSerializerSettings jsonSerializerSettings, RelationalMappings mappings, IKeyAllocator keyAllocator, IRelatedDocumentStore relatedDocumentStore, String name)
at Nevermore.RelationalStore.BeginTransaction(RetriableOperation retriableOperation, String name)
at Octopus.Core.Repositories.ConfigurationStore.Get[TDocument](String id) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Core\Repositories\ConfigurationStore.cs:line 26
at Octopus.Core.WebPortal.WebPortalConfigurationStore.GetDocProperty[T](Func2 getter) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Core\WebPortal\WebPortalConfigurationStore.cs:line 125 at Octopus.Server.Web.OctopusWebBootstrapper.ConfigureConventions(NancyConventions nancyConventions) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\OctopusWebBootstrapper.cs:line 106 at Nancy.Bootstrapper.NancyBootstrapperBase1.Initialise()
at Octopus.Server.Web.OctopusNancyHost…ctor(INancyBootstrapper bootstrapper, HostConfiguration configuration, Uri[] baseUris) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\OctopusNancyHost.cs:line 94
at Octopus.Server.Web.WebServerInitializer.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Web\WebServerInitializer.cs:line 36
at Octopus.Server.OctopusServerEngine.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\OctopusServerEngine.cs:line 65
at Octopus.Server.Commands.RunCommand.Start() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Server\Commands\RunCommand.cs:line 48
at Octopus.Shared.Startup.AbstractCommand.Octopus.Shared.Startup.ICommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions, String displayName, String version, String informationalVersion, String[] environmentInformation, String instanceName) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\AbstractCommand.cs:line 78
at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime) in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\OctopusProgram.cs:line 235
at Octopus.Shared.Startup.WindowsServiceHost.<>c__DisplayClass1_0.b__0() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\WindowsServiceHost.cs:line 20
at Octopus.Shared.Startup.WindowsServiceAdapter.RunService() in Z:\buildAgent\workDir\eec88466c176b607\source\Octopus.Shared\Startup\WindowsServiceAdapter.cs:line 59
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()
ClientConnectionId:b4923fa0-1953-4b91-84ae-97b15d60f2b1
Error Number:18456,State:1,Class:14

Please help, Thanks in advance

Hi @jagrutichavan14,

Thanks for getting in touch!

As this looks to be an issue with the SQL server, are you able to access that server and confirm if the service is running ok?
Can you login to SQL as that user? Or another user?
Have any changes been made to the server hosting SQL?

Regards,
Paul