Activity overview
Latest activity by Bill_E
@chris_ford2020 - Actually, it appears to be erroring on this line. $databaseConnection = New-DatabaseConnection -ServerInstance $env:SERVER_INSTANCE -Database $env:DATABASE -Username $env:USERNAME -Password $env:PASSWORD / comments
@chris_ford2020 - Actually, it appears to be erroring on this line. $databaseConnection = New-DatabaseConnection -ServerInstance $env:SERVER_INSTANCE -Database $env:DATABASE -Username $env:USERNAME...
@chris_ford2020 - Mine is failing here with basically the same error. What you posted earlier fixed my Build step name: CREATE_TXSURESTAGINGDATABASE_RELEASE_RESOURCES displayName: 'Create TxSureStagingDatabase Release Resources' enabled: 'true' failOnStderr: 'true' env: SERVER_INSTANCE: '$(serverInstanceNameReleaseTxSureStagingDatabase)' DATABASE: '$(databaseNameReleaseTxSureStagingDatabase)' USERNAME: '$(DevOps--Release--DatabaseAdminUserName)' PASSWORD: '$(DevOps--Release--DatabaseAdminUserPassword)' DATABASE_PACKAGE: '$(artifactDatabasePath)\TxSureStagingDatabase.1.0.nupkg' EXPORT_PATH: '$(releaseResourcePathTxSureStagingDatabase)' requiredVersionOfDlma: specific requiredVersion: 4.3.20259.22134 New-DatabaseReleaseArtifact : An unhandled error occurred:
RedGate.Versioning.Engine.Shared.DatabaseUtils.Exceptions.DatabaseConnectionException: Error connecting to database: A
connection was successfully established with the server, but then an error occurred during the login process.
(provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) --->
Microsoft.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error
occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an
authority that is not trusted.) ---> System.ComponentModel.Win32Exception: The certificate chain was issued by an
authority that is not trusted
/ comments
@chris_ford2020 - Mine is failing here with basically the same error. What you posted earlier fixed my Build stepname: CREATE_TXSURESTAGINGDATABASE_RELEASE_RESOURCESdisplayName: 'Create TxSureStag...
Does it need to be in both places? name: CREATE_TXSURESTAGINGDATABASE_RELEASE_RESOURCES
displayName: 'Create TxSureStagingDatabase Release Resources'
enabled: 'true'
failOnStderr: 'true'
env:
SERVER_INSTANCE: '$(serverInstanceNameReleaseTxSureStagingDatabase)'
DATABASE: '$(databaseNameReleaseTxSureStagingDatabase)'
USERNAME: '$(DevOps--Release--DatabaseAdminUserName)'
PASSWORD: '$(DevOps--Release--DatabaseAdminUserPassword)'
DATABASE_PACKAGE: '$(artifactDatabasePath)\TxSureStagingDatabase.1.0.nupkg'
EXPORT_PATH: '$(releaseResourcePathTxSureStagingDatabase)'
requiredVersionOfDlma: specific
requiredVersion: 4.3.20259.22134
- task: RedgateSqlChangeAutomationRelease@4
# 'SQL Change Automation: Release' task: https://marketplace.visualstudio.com/items?itemName=redgatesoftware.redgateDlmAutomationRelease
name: DEPLOY_TXSURESTAGINGDATABASE_RELEASE_RESOURCES
displayName: 'Deploy TxSureStagingDatabase Release Resources'
enabled: 'true'
inputs:
Operation: DeployFromResources
ImportPath: '$(releaseResourcePathTxSureStagingDatabase)'
AppendEnvironment: false
TargetDatabaseServer: '$(serverInstanceNameReleaseTxSureStagingDatabase)'
TargetDatabaseName: '$(databaseNameReleaseTxSureStagingDatabase)'
TargetDatabaseUsername: '$(DevOps--Release--DatabaseAdminUserName)'
TargetDatabasePassword: '$(DevOps--Release--DatabaseAdminUserPassword)'
requiredVersionOfDlma: specific
requiredVersion: 4.3.20259.22134
/ comments
Does it need to be in both places?name: CREATE_TXSURESTAGINGDATABASE_RELEASE_RESOURCES
displayName: 'Create TxSureStagingDatabase Release Resources'
enabled: 'true'
failOnStderr: 'true...
This solved my problem with the Build step but the Release step is still giving me trouble. / comments
This solved my problem with the Build step but the Release step is still giving me trouble.