This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 0%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Hello,
I have a windows Azure Agent which has been setup by our Azure Admin team. The agent does not have the SQLPackage and Powershell installed on it which is required for SQL DACPAC file generation. As part of my release pipeline I am using a powershell task also which is not working because it is not installed on the agent. Do we have any deploying task which can install SQLPackage and Powershell ?
Kindly provide your valuable inputs.
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
That the reason and issue we are facing on our agent profile. As the SQLPackage and Powershell is not installed due to which we can also not update travel bags site. Have you found the solution to install the SQLPackage and Powershell so that we can also fix it.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 53%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDI%3C/text%3E%3C/svg%3E)
HI SACHIN
To install SQLPackage and PowerShell on a Windows Azure Agent, you can follow these general steps. Keep in mind that Azure DevOps and Azure Pipelines are frequently updated, so the specific steps might vary slightly based on the current version. As of my last knowledge update in January 2022, here's a general guide:
Installing SQLPackage:
1. **Enable Execution Policy:**
- Set the execution policy to allow the execution of PowerShell scripts. Open PowerShell as an administrator and run the following command:
- 
- Azure Agent Setup:
1. **Azure DevOps Agent:**
- Download and configure the Azure DevOps agent on your Windows machine. You can follow the instructions provided by Microsoft: Azure Pipelines Agent
1. **Agent Capabilities:**
- Ensure that the agent machine has the necessary capabilities for SQLPackage and PowerShell. You can configure these capabilities in the agent pool settings.
1. **Environment Variables:**
- Add the paths to the SQLPackage and PowerShell executables to the system's PATH environment variable. This allows the agent to locate and execute these tools easily.
Pipeline Configuration:
1. **Pipeline YAML:**
- In your Azure DevOps pipeline YAML file, ensure that you are using the appropriate tasks to run SQLPackage and PowerShell scripts. Here is a basic example:
- 
- **Variables and Secrets:**
- If your SQLPackage or PowerShell scripts require sensitive information, such as connection strings or authentication details, consider using Azure Pipelines variables or secrets to securely manage these values.
Please adapt the steps according to the specific requirements of your project, and be sure to refer to the latest Azure DevOps documentation for any updates or changes.
Visit my other [website](https://rawfarmfresh.com/)
Hi @sachin gupta You can refer to the development pipelines shared by @Alberto Morillo
I know it says "upgrade" but it is an MSI installer and will install if not already installed, at the bottom has the instructions for dacfx/sqlpackage
Regards
Geetha
@GeethaThatipatri-MSFT Please post ithis comment as answer. I think that is the answer both OPs are looking for.
Sure @Alberto Morillo Thanks for confirming.
Regards
Geetha
Please refer to this documentation: SqlPackage in development pipelines.
You can also install it manually from here.
In addition, you can run a pipeline task to deploy dacpacs as explained here. See other available tasks. WindRM is another pipeline task you can use. You can can also create your own agent to install what you need.
@Alberto Morillo thanks for the response. This article will help only to update the version of the existing installed sql package. I want install a sqlpackage on our self hosted windows Azure VM and I dont know how we can do that using Azure DevOps pipeline. Do we have any step- by-step guide to do so?
Please provide your guidance.
I updated my answer. Let me know if the pipeline tasks I shared help you achieve what you want.
@Alberto Morillo @GeethaThatipatri-MSFT ...i think this will help me.
@Alberto Morillo ... the task which you mentioned, i am already using that to generate the dacpac file, but for that I am using the Windows-latest as the available VM from azure pool, but as soon as I switch to our self hosted VM, the dacpac generation fails because of unavailability of the packages. I guess with the YAML script mentioned by @GeethaThatipatri-MSFT will work for me.
Thanks for all the assistance. Appreciate it.
Thank you @GeethaThatipatri-MSFT for your help.
@sachin gupta Glad you found a solution here in Microsoft QA. Thank you for visiting us today
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 23%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
hi solve your issue?