The step failed: Activity Server Bootstrapper on server failed with error 'The remote script failed with exit code 1'

(Arun Sudarsanam) #1

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
(Kenneth Bates) #3

Hi @arun.sudarsanam,

Thanks for getting in touch! After confirming your SQL server is configured to allow remote connections, I’d recommend trying to isolate this issue by running this manually outside of Octopus. If that’s successful, can you send us through the full task log from this failure? I’m hoping that will provide more context to help us dig deeper into what’s causing this. :slight_smile:

I look forward to hearing back!

Best regards,

Kenny