topic Re: how to automate changing password for gMSA user account for Report Server SQL DataSource in Report Server

how to automate changing password for gMSA user account for Report Server SQL DataSource

ryatatu — Tue, 07 Dec 2021 10:44:58 GMT

Dear PBI experts,

Pls provide advice

I faced following situation:

for my PBIX file SQL Database used as DataSource

i need to organize process of refresh data model by means of using gMSA windows domain account.

When i put gMSA account into User name Report Server asks me for gMSA password, but as username is gMSA,

i expect password for gMSA to be provided automatically.

should i use some Power Shell script for this task to change gMSA password automatically?

or there are some alternatives ways you may recommend to change password automatically without need of manual password changing ?

Bst rgrds,

Alexsandr

Re: how to automate changing password for gMSA user account for Report Server SQL DataSource

Anonymous — Tue, 07 Dec 2021 11:32:36 GMT

I think this has to be a manual process, but would suggest trying out with power automate once.

Re: how to automate changing password for gMSA user account for Report Server SQL DataSource

ryatatu — Tue, 07 Dec 2021 11:38:48 GMT

we consider it has no sense for us to change password manually, instead try to find some way to get passsword from AD and change it automatically by means of PS script, as described in this link:

https://stackoverflow.com/questions/60165643/set-report-data-source-and-credentials-on-power-bi-report-server-through-rest-ap

Re: how to automate changing password for gMSA user account for Report Server SQL DataSource

ryatatu — Tue, 07 Dec 2021 11:41:09 GMT

did anybody have experience of getting gMSA password directly from AD by means of PS script ?

Re: how to automate changing password for gMSA user account for Report Server SQL DataSource

v-henryk-mstf — Fri, 10 Dec 2021 03:16:57 GMT

Hi ryatatu ,

Try the following command in powershell.

New-ADServiceAccount [-Name] <string> -RestrictToOutboundAuthenticationOnly [-ManagedPasswordIntervalInDays <Nullable[Int32]>] [-PrincipalsAllowedToRetrieveManagedPassword <ADPrincipal[]>]

Also, you can refer to the following blog as below.

https://blog.wicktech.net/powershell-install-gmsa/

If the problem is still not resolved, please point it out and provide related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.