Sample Header Ad - 728x90

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 SQLDBA and enter image description here When right-cliking on the server-properties-security-Add- then adding my AD group 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. enter image description here 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
Asked by Marcello Miorelli (17274 rep)
May 15, 2018, 01:50 PM
Last activity: Nov 22, 2018, 08:49 PM