sgovoni
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!
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!
have you read http://blogs.ameriteach.com/chris-randall/2009/12/11/sql-server-2008-forgot-to-add-an-administrator-account.html
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".
- Connect to the SSAS server using SQL Server Management Studio (Connect-->Analysis Services in Object Explorer)
- Right-click the SSAS server name in the object explorer and select Properties.
- Click "Security"
- Click "Add..."
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.AnalysisService s.Manageme ntDialogs) ".
Any ideas ?
Thanks
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.AnalysisService
Any ideas ?
Thanks
It normally takes an administrator to add an administrator. Do you not have any administrators at all?
ASKER
I haven't an administrator.
How do I add an administrator for SSAS using the user sa ?
How do I add an administrator for SSAS using the user sa ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I run SSMS as an administrator (my user is administrator of the machine), then I was able to access SSAS...
Thanks
Thanks
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.AnalysisService s.Manageme ntDialogs
The user connected to a server is not an administrator of Analysis Services. Only an administrator can make changes to server properties. (Microsoft.AnalysisService
You are commenting on an answered question from over 6 years ago. Do the comments and the solution above help?