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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.