Parser: The syntax for the ImpersonationInfo object is incorrect, If the ImpersonateAccount value is used for ImpersonationInfo

15
votes

I am trying to deploy a cube for the first time on my PC. I have run SSMS as an Admin and made myself (Gary-pc\gary, using Windows authentication) an admin. Doing this got me past the error message user does not have permission to create a new object in 'GARY-PC', or the object does not exist. When I deploy the cube now, I get the error: the syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. I have not (knowingly! LOL) set up anything related to impersonation.

2
sql-serverssas
solved the problem, documenting for future reference. the link below provides info on how to change the impersonation (double click on the data source, select impersonation..). I changed to 'use credentials of user' and was able to deploy social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/… However, when I tried to process it , it said ‘impersonation method does not support processing’. So I changed to use the service account. And was able to process successfully. I am now able to browse the cube. Hooray! – gnackenson

2 Answers

17
votes

I've resolved the problem with this:

  • Double click on data source

  • Select impersonation

  • Choose use credentials of user

As @user1335419 says.

2
votes

I tried changing the impersonation to "Credentials of User" and although I was successful in deploying the cube, I could not process it. I ended up getting an error that said:

"The datasource contains an ImpersonationMode that is not supported for processing operations"

So I changed the impersonation from "Credentials of User" to "Inherit" and was able to process. I don't know if the first deployment would have worked with "Inherit", but thought I would share my experience.