Link to home
Start Free TrialLog in
Avatar of sgovoni
sgovoniFlag for Italy

asked on

How to add an administrator user of SQL Server Analysis Services 2008 after the install

Hi,

I don't know how to add an administrator of the administrator users of SQL Server Analysis Services in SQL Server 2008 ?

During the installation of SSAS, the installer provides the option of adding one or more Administrators (Tab "Account Provisioning") for access to SSAS, but after the installation I can not find a way to change these settings in particular I should add a user.

With SQL Server 2005 was the utility sqlprov.exe, but this is not present in SQL Server 2008.

The BOL at this link: http://technet.microsoft.com/en-us/library/cc281723.aspx explain how to add the user during installation ... but how do I do after installing?

The environment on which I have this problem is:

- S.O. Windows 7 Professional 64-bit
- SQL Server 2008 SP1 (with Analysis Services)

Thanks!
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Avatar of sgovoni

ASKER

I have read... but I retrieve the same error, and when i try to restore a DB in SSAS i recieve this error: "To run the command SystemGetLogicalDrives are necessary permissions database administrator or server administrator".
  1. Connect to the SSAS server using SQL Server Management Studio (Connect-->Analysis Services in Object Explorer)
  2. Right-click the SSAS server name in the object explorer and select Properties.
  3. Click "Security"
  4. Click "Add..."
Avatar of sgovoni

ASKER

Hi rscowden,

thanks for your answer, but after the connection to the SSAS, when I click (right) on the SSAS server name in the object explorer I retrieve this error:

"The user connected to a server is not an administrator of Analysis Services. Only an administrator can make changes to server properties. (Microsoft.AnalysisServices.ManagementDialogs)".

Any ideas ?

Thanks
It normally takes an administrator to add an administrator. Do you not have any administrators at all?
Avatar of sgovoni

ASKER

I haven't an administrator.
How do I add an administrator for SSAS using the user sa ?
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sgovoni

ASKER

I run SSMS as an administrator (my user is administrator of the machine), then I was able to access SSAS...

Thanks
Avatar of Shubham Agarwal
Shubham Agarwal

when i right click on ssas server then i got the below error.

The user connected to a server is not an administrator of Analysis Services. Only an administrator can make changes to server properties. (Microsoft.AnalysisServices.ManagementDialogs
You are commenting on an answered question from over 6 years ago. Do the comments and the solution above help?