Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

how to pass credentials through bamboo to powershell script to auto deploy SSAS cube

AYODHYA MOUNICA
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 17, 2020

we are using power shell script to auto deploy SSAS cubes and the script is working fine with windows credentials when executed from windows powershell editor.

But when trying to execute the same from Bamboo, by default it is using some generic ID to deploy the cube which is throwing an error (issue with permissions)..

Could anyone help to pass windows credentials/specified credentials instead of bamboo default credentials for deployment.

 

1 answer

0 votes
Minh Tran
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 17, 2020

Can you share the power script that you used to deploy to SSAS cubes including the part that you pass the credential?

jim jim
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 20, 2020

Please find below the Powershell script..

 

Param(

$ServerInstance ="ServerName",
$path = "Bitbucket\bld-dir\path"

)


## Add the AMO namespace
$loadInfo = [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices")


$password = ConvertTo-SecureString “Password” -AsPlainText -Force

$Cred = New-Object System.Management.Automation.PSCredential (“Domain\Username”, $password)


$server = New-Object Microsoft.AnalysisServices.Server
$server.connect($ServerInstance)



Invoke-ASCmd -Server $ServerInstance -InputFile $path\File.xmla -Credential $Cred

jim jim
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 20, 2020

Kindly suggest the change to be done so that that deployment happens from bamboo with "Domain\UserName" and not with Bamboo default credentials. Thanks!!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events