administrator permissions on a SSAS database
6
votes
2
answers
9236
views
I had a third party company coming over and building ssas databases to produce reports.
They did, but now the DBA wants to have a look but I haven't got permissions, to even see those databases, as you can see on the picture below.
Can I grant myself administrator permissions?
I am system administrator. there is a AD group called
When right-cliking on the server-properties-security-Add-
then adding my AD group
TITLE: Microsoft SQL Server Management Studio
------------------------------
Either the 'mycompany\MMiorelli' user does not have permission to alter the 'myserver\instance' object, or the object does not exist.
(Microsoft.AnalysisServices.AppLocal.Core)
------------------------------
BUTTONS:
OK
SQLDBA
and

SQLDBA
it says I don't have the permissions to alter
the server object as you can see on the picture below.
I had previously added that sqldba
AD group as an administrator to that box.

Asked by Marcello Miorelli
(17274 rep)
May 15, 2018, 01:50 PM
Last activity: Nov 22, 2018, 08:49 PM
Last activity: Nov 22, 2018, 08:49 PM