This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 93%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I need to get SSAS server admin information.
I know that can be found in the SSMS UI with the corresponding action.
Is there any other way to get them? For example, T-SQL or other statements.
Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
What for "SSAS server admin information." do you mean, that's not clear for me?
Hi @David -
Not sure if this thread is what you are looking for.
https://stackoverflow.com/questions/70613711/get-list-of-ssas-server-admins
Best regards,
Percy Tang
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 27%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
You can query the sys.server_principals catalog view to retrieve information about server-level principals, including the server administrator(s). Run the following T-SQL query:
sql
Copy code
SELECT name, type_desc
FROM sys.server_principals
WHERE type_desc = 'SERVER_ROLE' AND name = 'Administrators';