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.
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
View Comments
Thanks a ton.. works perfectly
Thanks!