Passing SSRS server Windows authentication and executing PowerShell script using Windows virtual machine in Azure DevOps.
Budget: $30 – $250 CAD
I currently have a powershell script that automatically uploads a report file (*.rdl) to a SQL Server Reporting Services (SSRS) server.
I'm implementing Azure DevOps to CI/CD report files whenever a new report file is uploaded to the repository.
The above mentioned powershell script works without problems on the local machine that has passed Windows authentication on the SSRS server.
What I want to implement is
1. Create a Windows virtual machine that can pass SSRS server authentication in Azure DevOps environment
2. Save the user name and password to be authenticated by the SSRS server in the pipeline environment
3. Execute above mentioned script as script block inside Invoke-Command and pass the variables as arguments.
Since I can't share my development environment, all I'm asking is to guide me with a manual on how to handle this process, or a demonstration with your Azure DevOps environemnt to show hot it works. (I may request you giving advice on some of the problems while I'm following your process.)
I'm implementing Azure DevOps to CI/CD report files whenever a new report file is uploaded to the repository.
The above mentioned powershell script works without problems on the local machine that has passed Windows authentication on the SSRS server.
What I want to implement is
1. Create a Windows virtual machine that can pass SSRS server authentication in Azure DevOps environment
2. Save the user name and password to be authenticated by the SSRS server in the pipeline environment
3. Execute above mentioned script as script block inside Invoke-Command and pass the variables as arguments.
Since I can't share my development environment, all I'm asking is to guide me with a manual on how to handle this process, or a demonstration with your Azure DevOps environemnt to show hot it works. (I may request you giving advice on some of the problems while I'm following your process.)