SQL Server Error on Install

[MadMaximusJB]

Error Code:

worker-1    | !!! +- Name or service not known
worker-1    | -------------------------------------------------------------------------------
worker-1    | VersionMigration migrating
worker-1    | -------------------------------------------------------------------------------
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       There was an error trying to update the Resgrid Database, see the error output below:
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught)
worker-1    |        ---> System.Net.Sockets.SocketException (00000005, 0xFFFDFFFF): Name or service not known
worker-1    |          at System.Net.Dns.GetHostEntryOrAddressesCore(String hostName, Boolean justAddresses, AddressFamily addressFamily, Nullable`1 startingTimestamp)
worker-1    |          at System.Net.Dns.GetHostAddresses(String hostNameOrAddress, AddressFamily family)
worker-1    |          at Microsoft.Data.SqlClient.SNI.SNICommon.GetDnsIpAddresses(String serverName)
worker-1    |          at Microsoft.Data.SqlClient.SNI.SNITCPHandle.Connect(String serverName, Int32 port, TimeSpan timeout, Boolean isInfiniteTimeout, SqlConnectionIPAddressPreference ipPreference, String cachedFQDN, SQLDNSInfo& pendingDNSInfo)
worker-1    |          at Microsoft.Data.SqlClient.SNI.SNITCPHandle..ctor(String serverName, Int32 port, Int64 timerExpire, Boolean parallel, SqlConnectionIPAddressPreference ipPreference, String cachedFQDN, SQLDNSInfo& pendingDNSInfo, Boolean tlsFirst, String hostNameInCertificate, String serverCertificateFilename)
worker-1    |          at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
worker-1    |          at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
worker-1    |          at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnectionString connectionOptions, Boolean withFailover)
worker-1    |          at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
worker-1    |          at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
worker-1    |          at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
worker-1    |          at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool)
worker-1    |          at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
worker-1    |          at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
worker-1    |          at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
worker-1    |          at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
worker-1    |          at Microsoft.Data.SqlClient.SqlConnection.Open()
worker-1    |          at FluentMigrator.Runner.Processors.GenericProcessorBase.<>c__DisplayClass6_1.<.ctor>b__1()
worker-1    |          at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
worker-1    |       --- End of stack trace from previous location ---
worker-1    |          at System.Lazy`1.CreateValue()
worker-1    |          at FluentMigrator.Runner.Processors.GenericProcessorBase.get_Connection()
worker-1    |          at FluentMigrator.Runner.Processors.GenericProcessorBase.EnsureConnectionIsOpen()
worker-1    |          at FluentMigrator.Runner.Processors.GenericProcessorBase.BeginTransaction()
worker-1    |          at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.BeginTransaction()
worker-1    |          at FluentMigrator.Runner.TransactionalMigrationScope..ctor(IMigrationProcessor processor, Action disposalAction)
worker-1    |          at FluentMigrator.Runner.MigrationScopeHandler.BeginScope()
worker-1    |          at FluentMigrator.Runner.MigrationScopeHandler.CreateOrWrapMigrationScope(Boolean transactional)
worker-1    |          at FluentMigrator.Runner.MigrationRunner.ApplyMigrationUp(IMigrationInfo migrationInfo, Boolean useTransaction)
worker-1    |          at FluentMigrator.Runner.MigrationRunner.Up(IMigration migration)
worker-1    |          at FluentMigrator.Runner.VersionLoader.LoadVersionInfo()
worker-1    |          at FluentMigrator.Runner.VersionLoader..ctor(IProcessorAccessor processorAccessor, IConventionSet conventionSet, IMigrationRunnerConventions conventions, IVersionTableMetaData versionTableMetaData, IMigrationRunner runner)
worker-1    |          at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
worker-1    |          at System.Reflection.MethodBaseInvoker.InvokeWithManyArgs(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.ConstructorMatcher.CreateInstance(IServiceProvider provider)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProvider provider, Type instanceType, Object[] parameters)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance[T](IServiceProvider provider, Object[] parameters)
worker-1    |          at Microsoft.Extensions.DependencyInjection.FluentMigratorServiceCollectionExtensions.<>c.<AddFluentMigratorCore>b__0_6(IServiceProvider sp)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
worker-1    |          at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
worker-1    |          at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
worker-1    |          at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
worker-1    |          at System.Lazy`1.CreateValue()
worker-1    |          at FluentMigrator.Runner.MigrationRunner.get_VersionLoader()
worker-1    |          at FluentMigrator.Runner.MigrationRunner.IsMigrationStepNeededForUpMigration(IMigrationInfo migration, Int64 targetVersion)
worker-1    |          at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass60_0.<GetUpMigrationsToApply>b__0(KeyValuePair`2 pair)
worker-1    |          at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
worker-1    |          at FluentMigrator.Runner.MigrationRunner.MigrateUp(Int64 targetVersion, Boolean useAutomaticTransactionManagement)
worker-1    |          at FluentMigrator.Runner.MigrationRunner.MigrateUp(Boolean useAutomaticTransactionManagement)
worker-1    |          at FluentMigrator.Runner.MigrationRunner.MigrateUp()
worker-1    |          at Resgrid.Workers.Console.DatabaseUpgradeService.UpdateDatabase(IServiceProvider serviceProvider) in /src/Workers/Resgrid.Workers.Console/Program.cs:line 404
worker-1    |          at Resgrid.Workers.Console.DatabaseUpgradeService.ExecuteAsync(CancellationToken stoppingToken) in /src/Workers/Resgrid.Workers.Console/Program.cs:line 384
worker-1    |       ClientConnectionId:00000000-0000-0000-0000-000000000000
worker-1    | info: Resgrid.Workers.Console.QueuesProcessingService[0]
worker-1    |       Starting Queues Event Watcher
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       Starting Scheduler
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       Scheduler Started
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       Starting Scheduled Jobs
worker-1    | info: Resgrid.Workers.Console.ScheduledJobsService[0]
worker-1    |       Scheduling Calendar Notifications
rabbitmq-1  | 2025-01-24 03:10:17.437507+00:00 [info] <0.1269.0> accepting AMQP connection <0.1269.0> (xxxx -> xxxx)
rabbitmq-1  | 2025-01-24 03:10:17.450538+00:00 [info] <0.1269.0> connection <0.1269.0> (xxxx -> xxxx) has a client-provided name: QueueProcessor-CQRS
rabbitmq-1  | 2025-01-24 03:10:17.453706+00:00 [info] <0.1269.0> connection <0.1269.0> (xxxx -> xxxx - QueueProcessor-CQRS): user 'resgrid' authenticated and granted access to vhost '/'
worker-1    | info: Microsoft.Hosting.Lifetime[0]
worker-1    |       Application started. Press Ctrl+C to shut down.
worker-1    | info: Microsoft.Hosting.Lifetime[0]
worker-1    |       Hosting environment: Production
worker-1    | info: Microsoft.Hosting.Lifetime[0]
worker-1    |       Content root path: /app/
2025-01-24 03:10:17.72 Logon       Error: 18456, Severity: 14, State: 38.
2025-01-24 03:10:17.72 Logon       Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'ResgridWorkers'. [CLIENT: 172.16.193.54]
worker-1    | fail: Microsoft.Extensions.Hosting.Internal.Host[9]
worker-1    |       BackgroundService failed
worker-1    |       System.Data.SqlClient.SqlException (0x80131904): Cannot open database "ResgridWorkers" requested by the login. The login failed.
worker-1    |       Login failed for user 'sa'.
worker-1    |          at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
worker-1    |          at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
worker-1    |          at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
worker-1    |       --- End of stack trace from previous location ---
worker-1    |          at Quidjibo.SqlServer.Utils.SqlRunner.ExecuteAsync(Func`2 func, String connectionString, Boolean inTransaction, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.SqlServer.Factories.SqlScheduleProviderFactory.CreateAsync(String[] queues, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.SqlServer.Factories.SqlScheduleProviderFactory.CreateAsync(String queues, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.Clients.QuidjiboClient.ScheduleAsync(String name, String queue, IQuidjiboCommand command, Cron cron, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.Clients.QuidjiboClient.ScheduleAsync(String name, IQuidjiboCommand command, Cron cron, CancellationToken cancellationToken)
worker-1    |          at Resgrid.Workers.Console.ScheduledJobsService.ExecuteAsync(CancellationToken stoppingToken) in /src/Workers/Resgrid.Workers.Console/Program.cs:line 267
worker-1    |          at Microsoft.Extensions.Hosting.Internal.Host.TryExecuteBackgroundServiceAsync(BackgroundService backgroundService)
worker-1    |       ClientConnectionId:cbf42286-0362-42ab-a24b-c85f174385e6
worker-1    |       Error Number:4060,State:1,Class:11
worker-1    | crit: Microsoft.Extensions.Hosting.Internal.Host[10]
worker-1    |       The HostOptions.BackgroundServiceExceptionBehavior is configured to StopHost. A BackgroundService has thrown an unhandled exception, and the IHost instance is stopping. To avoid this behavior, configure this to Ignore; however the BackgroundService will not be restarted.
worker-1    |       System.Data.SqlClient.SqlException (0x80131904): Cannot open database "ResgridWorkers" requested by the login. The login failed.
worker-1    |       Login failed for user 'sa'.
worker-1    |          at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
worker-1    |          at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
worker-1    |          at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
worker-1    |          at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
worker-1    |       --- End of stack trace from previous location ---
worker-1    |          at Quidjibo.SqlServer.Utils.SqlRunner.ExecuteAsync(Func`2 func, String connectionString, Boolean inTransaction, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.SqlServer.Factories.SqlScheduleProviderFactory.CreateAsync(String[] queues, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.SqlServer.Factories.SqlScheduleProviderFactory.CreateAsync(String queues, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.Clients.QuidjiboClient.ScheduleAsync(String name, String queue, IQuidjiboCommand command, Cron cron, CancellationToken cancellationToken)
worker-1    |          at Quidjibo.Clients.QuidjiboClient.ScheduleAsync(String name, IQuidjiboCommand command, Cron cron, CancellationToken cancellationToken)
worker-1    |          at Resgrid.Workers.Console.ScheduledJobsService.ExecuteAsync(CancellationToken stoppingToken) in /src/Workers/Resgrid.Workers.Console/Program.cs:line 267
worker-1    |          at Microsoft.Extensions.Hosting.Internal.Host.TryExecuteBackgroundServiceAsync(BackgroundService backgroundService)
worker-1    |       ClientConnectionId:xxxxxx
worker-1    |       Error Number:4060,State:1,Class:11
worker-1    | info: Microsoft.Hosting.Lifetime[0]
worker-1    |       Application is shutting down...

Using Debian 12 Bookworm. Main page also will not load. I'm guessing a problem with the SQL server, but haven't been able to figure it out. Any advice? Thank you.

[welcome]

Thanks for opening this issue. A contributor should be by to give feedback soon. In the meantime, please check out the contributing guidelines.

[talshafie]

I think this is due to wrong mssql-tools path specified in the below files:
./resgrid/db/initdbs.sh and ./resgrid/db/run-initialization.sh

the correct path in both files above should be:
/opt/mssql-tools/bin/sqlcmd

[ucswift]

Hey, thanks for reporting. Let me take a look.

[ucswift]

I've fixed the path in Resgrid/resgrid-setup@183162a and will be verifying here shortly.

[ucswift]

26a2b3a and Resgrid/resgrid-setup@6492e37 resolve the SQL issue (by removing it and replacing it with Postgres). If you find any other issues, please feel free to open up new issues.