question

NaitoKazumi-7364 avatar image
0 Votes"
NaitoKazumi-7364 asked ZoeHui-MSFT answered

Unable to deploy SSAS cubes with Windows credentials


How can I resolve this permissions error when deploying an Analysis Services cube? The user already has SA privileges on the localhost server.

I modify role membership using the following procedure.

Run SQL Server Management Studio as administrator
Open the Analysis Services server in the Object Explorer
Go to Properties
Go to Security
Add the user as an administrator.

I wanna deploy SSAS cubes with Windows credentials.



------ Build started: Project: FerrariRusso, Configuration: Development ------
Started Building Analysis Services project: Incremental ....
Dimension [Date] : Create hierarchies in non-parent child dimensions.
Dimension [Customer] : Create hierarchies in non-parent child dimensions.
Dimension [Product] : Create hierarchies in non-parent child dimensions.
Build complete -- 0 errors, 3 warnings
------ Deploy started: Project: FerrariRusso, Configuration: Development ------
Performing an incremental deployment of the 'FerrariRusso' database to the 'localhost' server.
Generating deployment script...
Add Database FerrariRusso
Process Database FerrariRusso
Done
Sending deployment script to the server...
Error -1055391738 : Either the 'ACMECorp\tarzan' user does not have permission to create a new object in 'ACTARZAN-WIN81', or the object does not exist.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

sql-server-generalsql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered OlafHelper-2800 commented

The user already has SA privileges

"sa" is the standard SysAdmin account in relational database; has nothing to do with SSAS
SSAS has it's own permissioning system and supports only Windows Authentication.
As the error message says, the Windows login ACMECorp\tarzan don't have permissions to create a SSAS; you have to grant permissions first.
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Olaf Helper-san,

For SSAS DB in 'ACTARZAN-WIN81'
I'm trying to deploy from within a client device ('ACMECorp \ tarzan') using my Windows credentials.

However, although the Windows credential information on the server side is registered and connected in the client terminal,
Since the client terminal local credentials are activated,
I can't deploy.

0 Votes 0 ·

However, although the Windows credential information on the server side is registered and connected in the client terminal,

What for a terminal, RDP?
Your Windows permission don't matter, you need admin permissions for SSAS to create a database / deploy it.
See
https://docs.microsoft.com/en-us/analysis-services/instances/grant-server-admin-rights-to-an-analysis-services-instance?view=asallproducts-allversions
0 Votes 0 ·
NaitoKazumi-7364 avatar image
0 Votes"
NaitoKazumi-7364 answered

For SSAS DB in 'ACTARZAN-WIN81'
I'm trying to deploy from within a client device ('ACMECorp \ tarzan') using my Windows credentials.

However, although the Windows credential information on the server side is registered and connected in the client terminal,
Since the client terminal local credentials are activated,
I can't deploy.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @NaitoKazumi-7364 ,

Please note that Client and SSAS server should be on the same domain, and must be domain joined machine.

Secondly, the account you are login with your client machine should the an administrator in your SSAS server.

Please make sure you have verify above two points.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.