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!
sgovoniAsked:
Who is Participating?
 
Megan BrooksSQL Server ConsultantCommented:
Supposedly, by default Windows administrators for the machine on which SSAS is installed (local and domain administrators) are SSAS administrators even they do not show in the administrator list. Try logging directly on to the server using a local Windows administrator account, running SSMS, and repeating the above steps. If you don't have SSMS installed there you may need to install it.
You probably don't have to log directly on to the server, but the account you use to assign new SSAS administrators would otherwise need to be a Windows Domain Administrator account or else would need to be in the local Administrators group for the SSAS machine.
0
 
sgovoniAuthor Commented:
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".
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Megan BrooksSQL Server ConsultantCommented:
  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..."
0
 
sgovoniAuthor Commented:
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
0
 
Megan BrooksSQL Server ConsultantCommented:
It normally takes an administrator to add an administrator. Do you not have any administrators at all?
0
 
sgovoniAuthor Commented:
I haven't an administrator.
How do I add an administrator for SSAS using the user sa ?
0
 
sgovoniAuthor Commented:
I run SSMS as an administrator (my user is administrator of the machine), then I was able to access SSAS...

Thanks
0
 
Shubham AgarwalCommented:
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
0
 
Megan BrooksSQL Server ConsultantCommented:
You are commenting on an answered question from over 6 years ago. Do the comments and the solution above help?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.