Comments
Sort by recent activity
Sergio, I am trying to follow your advice and implement PowerShell components instead of addons in Build and Release. And having the same issue - cannot find the way to provide parameter TrustServerCertificate=True to the New-DatabaseConnection cmdlet. Is it any way to do it using PowerShell? Thank you, Nikolai / comments
Sergio, I am trying to follow your advice and implement PowerShell components instead of addons in Build and Release. And having the same issue - cannot find the way to provide parameter TrustServe...
nfp1 said:
Sergio,
I am trying to follow your advice and implement PowerShell components instead of addons in Build and Release. And having the same issue - cannot find the way to provide parameter TrustServerCertificate=True to the New-DatabaseConnection cmdlet. Is it any way to do it using PowerShell?
Thank you,
Nikolai
Answering myself. Found an option to use cmdlet Test_DatabaseConnection instead which can consume explicit connection string. / comments
nfp1 said:
Sergio,
I am trying to follow your advice and implement PowerShell components instead of addons in Build and Release. And having the same issue - cannot find the way to provide p...
Finally, I made it work. But solution maybe not permanent yet. Yes, build task is configured. The build succeeded when I designated the "Shadow" db as a build database and made SQL login from build configuration a dbo in shadow database. Not sure how long this fix will survive as in DEV and TARGET databases dbo user should be mapped to the our company dedicated account. Nevertheless, I appreciate your tip it helped me. But if I do not designate database in the build configuration which one is being used for project verification by Agent? Thank you wayOutwest / comments
Finally, I made it work. But solution maybe not permanent yet. Yes, build task is configured. The build succeeded when I designated the "Shadow" db as a build database and made SQL login from build...
thank you for prompt response. This error happens when TFS agent runs the Build. during this stage powershell script invokes Invoke-DatabaseBuild and does Validating project 'D:\agent\vsts-agent-win-x64-2.131.0\_work\256\s\MCRCDB_SCA.sqlproj'. How it validates I have no idea but as result I have DbBuildTask: ERROR [image] \agent\vsts-agent-win-x64-2.131.0\_work\256\s\Migrations\1.0.0-Baseline\001_20190225-0803_nfp1.sql(0,0): An error occurred while attempting to verify your deployment scripts. In Visual studio project get built just fine? I don't know which database DbBuildTask uses. Need some insight here. / comments
thank you for prompt response. This error happens when TFS agent runs the Build. during this stage powershell script invokes Invoke-DatabaseBuild and does Validating project 'D:\agent\vsts-agent-wi...