question

RamyaHarinarthini-7767 avatar image
0 Votes"
RamyaHarinarthini-7767 asked ·

In Analysis Services, turning the AlwaysUseGateway property True/False

Hi,
We have a requirement to set the AsPaaS\AlwaysUseGateway property to true and when not in use, turn the property to false
In simple words, we want to automate its value,setting it to true/false whenever we require
Is there any way to do this?

(the below screenshot is of the same property I changed through SSMS)

7948-analysis-service.png

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

MSDN Source


azure-analysis-services
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ChiragMishra-MSFT avatar image
0 Votes"
ChiragMishra-MSFT answered ·

Hello,

You can use TOM or XMLA, with the client libraries (AMO/ADOMD/PowerShell).

E.g. https://blog.crossjoin.co.uk/2019/08/25/setting-azure-analysis-services-server-properties-not-visible-in-sql-server-management-studio/ shows how to set a server property using an XMLA script.

MSDN Source


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.