I am trying to implement CICD for MDS via Azure Devops. Below are the steps which I have followed :
- Created a self hosted agent which has SSDT installed
- Tried executing the MDS Cmd queries from the VM which I created as a self hosted agent and it was a success :
- In Azure Devops, used the self hosted agent and CMD task:
And added the inline query :
cd C:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration
MDSModelDeploy createpackage -service MDS1 -model SalesBI -package "C:\MDS\CICD\SalesBI_CICD.pkg"
And after execution of the pipeline, I am getting the error :
The web configuration file for the Master Data Services instance cannot be loaded. An error occurred loading a configuration file: Access to the path 'C:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\web.config' is denied. (C:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\web.config)
So is there anything which I am missing out while setting up the self hosted agent in Devops because executing the same commands by manually logging into the same VM is getting executed successfully.