We are able to connect to ping/ telnet to DB host from the host where the activity is being executed.
TCP is enabled and not blocked by firewall.
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: 0 - No such host is known.)
September 5th 2019 12:01:23
Info
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)
September 5th 2019 12:01:23
Info
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
September 5th 2019 12:01:23
Info
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
September 5th 2019 12:01:23
Info
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
September 5th 2019 12:01:23
Info
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
September 5th 2019 12:01:23
Info
at System.Data.SqlClient.SqlConnection.Open()
September 5th 2019 12:01:23
Info
at CallSite.Target(Closure , CallSite , Object )
September 5th 2019 12:01:23
Error
Script 'Y:\Octopus\Applications\Confirmit.Server.Bootstrapper\21.0.7\Deploy.ps1' returned non-zero exit code: -1. Deployment terminated.
September 5th 2019 12:01:23
Error
Running rollback conventions...
September 5th 2019 12:01:23
Error
Script 'Y:\Octopus\Applications\Confirmit.Server.Bootstrapper\21.0.7\Deploy.ps1' returned non-zero exit code: -1. Deployment terminated.
September 5th 2019 12:01:23
Fatal
The remote script failed with exit code 1
September 5th 2019 12:01:23
Fatal
The action Server Bootstrapper on confirmit-batch failed