Categories: SSAS

Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the nice error message saying I wasn’t a server administrator on the Tabular server.

I was almost 100% certain I added myself as an administrator during SQL Server set-up and the configuration of the Tabular server. I logged in the server, went to properties and then to security. The list of server administrators was as empty as a merchant’s soul (yep, I googled that one). I either forgot to add myself as an admin (not likely, because according to the docs the set-up doesn’t continue if you don’t select an admin), or something fishy was going on.

So I tried to add myself as an administrator, however no dice: I didn’t have the correct permissions. A quick search engine search (sorry) revealed I should be able to, because local administrators do have admin permissions in SSAS Tabular. This was starting to get annoying.

However, a bit more thorough search showed me the solution: you had to launch SSMS as an administrator. Good old UAC, you strike again, old foe.

And lo and behold, I could add myself as an admin! Which means I don’t have to run SSDT as an admin every time I want to create a new Tabular project.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

Recent Posts

Call a Fabric REST API from Azure Data Factory

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data…

18 hours ago

Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…

2 weeks ago

How I passed the DP-700 Exam

I recently took and passed the DP-700 exam, which is required for the Microsoft Certified:…

4 weeks ago

Take over Ownership in Microsoft Fabric

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…

2 months ago

Book Review – Agile Data Warehouse Design

I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…

3 months ago

Cloudbrew 2024 – Slides

You can find the slides for the session Building the €100 data warehouse with the…

4 months ago