What are the challenges you face when working across database platforms? Take the survey
Options

Sql Server Connection errors - TLS?

Hi,

We are using AzureDevOps and the SCA cmdlets for our builds and are occasionally seeing the error below.

Have you all seen this issue and could provide us with any information on how to resolve or troubleshoot? We have TLS 1.0/1.1 disabled and I'm wondering if we need to do anything special or any advice you could provide.

<div><div>##[error]RedGate.Versioning.Automation.Shared.Errors.TerminatingException: SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error.
</div></div><div><div>SQLCompare.exe produced this error output:
</div></div><div><div>Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.RedgateTools.CompareResultExtensions.HandleCompareResult(RedgateToolResult redgateToolResult, ILog log, Object targetObject, String executable, Nullable`1 overrideReport)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.Compare.CompareUpdateGenerator.GetUpdateFrom(ISchemaSource sourceSchema, ISchemaSource targetSchema, Filter filter, SqlCompareOptions options, TransactionIsolationLevel transactionIsolationLevel, Boolean includeStaticData, Boolean ignoreAdditional, Boolean ignoreParserErrors)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.Compare.SchemaUpdater.PerformUpdate(String scriptsFolderPath, IDatabase database, CompareOptionArguments compareOptionArguments, TransactionIsolationLevel transactionIsolationLevel, Int32 timeout)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.Compare.SchemaUpdater.UpdateFromScriptsFolderWithAction(String scriptsFolderPath, IDatabase database, CreateDatabaseParameters createDatabaseParameters)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.SchemaValidation.DiskBackedProjectValidator.ValidateProject(IProjectPath projectPath, IDatabase database, CreateDatabaseParameters createDatabaseParameters)
</div></div><div><div>   at RedGate.Versioning.Automation.Compare.SchemaValidation.ProjectValidator.ValidateProject(String projectPath, CreateDatabaseParameters createDatabaseParameters)
</div></div><div><div>   at RedGate.Versioning.Automation.PowerShell.Commands.InvokeDatabaseBuildCommandImpl.Process()
</div></div><div><div>   at RedGate.Versioning.Automation.PowerShell.DlmAutomationCommandImpl`1.ProcessRecord()
</div></div><div><div>   at RedGate.PowerShell.CommandBase`2.DelegateTo(Action doImplementation)

</div></div>
Sign In or Register to comment.