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

vtwuwzda 于 2023-03-07 发布在其他

关注(0)|答案(3)|浏览(145)

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.

sql-server

来源：https://stackoverflow.com/questions/10336565/parser-the-syntax-for-the-impersonationinfo-object-is-incorrect-if-the-imperso

3条答案

按热度按时间

emeijp431#

I've resolved the problem with this:

Double click on data source
Select impersonation
Choose use credentials of user

As @user1335419 says.

赞(0）回复(0）举报 2023-03-07

f45qwnt82#

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.

赞(0）回复(0）举报 2023-03-07

lx0bsm1f3#

I've solved it with @napstercake's solution too. I choosed Use the service account in Impersonation info tab

赞(0）回复(0）举报 2023-03-07