search

DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
21 stars 14 forks source link

DeployCube: username and password not being passed to update tabular model on Azure AS #5

Open realdevopsguy opened 5 years ago

realdevopsguy commented 5 years ago

Great extension! It's so far has saved me a lot of time. However, I do have a problem with passing a secure variable with my u/p to update the model. I looks like it updates but when I go to process it, no luck. The process model task says The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The following system error occurred: The user name or password is incorrect. A connection could not be made to the data source with the Name of 'SqlAzure somewhereyoudontknow.database.windows.net datatrax'. '..

I have validated the u/p several times and looked at the connection string in SSAS and it looks ok. using the same u/p to manually update works fine.

DrJohnT commented 5 years ago

I will take a look when I get back from holiday

DrJohnT commented 3 years ago

@realdevopsguy I have updated the underlying PowerShell module (i.e. https://github.com/DrJohnT/DeployCube) to fully support deployment of tabular cubes to Azure Analysis Services. I just need to expose the relevant fields in my DeployTabularModel extension (i.e. u/p).