Impersonate Account Setting in SSAS 2012 XMLA script

http://mahadevanrv.blogspot.com/2011/05/impersonate-account-setting-in-ssas.html

<ImpersonationInfo>
  <ImpersonationMode>ImpersonateAccount</ImpersonationMode>
  <Account>Domain\UserName</Account>
  <Password>Password</Password>

</ImpersonationInfo>

While generating Create SSAS Database through XMLA script, we can see that the password field in impersonate account is not appearing anywhere. If you execute the script as it is the database will be created but fails whenever you process the database. to avoid this you need to add user account password to run the cube as shown above

Advertisements

One thought on “Impersonate Account Setting in SSAS 2012 XMLA script

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s