Activity overview
Latest activity by nfp1
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...
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...
How to modify connection string when using PerformDeployFromPackage addin in TFS?
I am using Redgate addins in TFS for build and release. Lately security settings in target SQL server are changed and default Windows authentication started to fail. I need to modify some Connectio...
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...
this login already has an account under different user name during Build phase
Successfully created and built SQL Change Automation project. Database has number of users assigned to the roles. Users are mapped to the SQL server type of Logins. Baseline script has these ite...