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 below:
<ImpersonationInfo>
<ImpersonationMode>ImpersonateAccount</ImpersonationMode>
<Account>Domain\UserName</Account>
<Password>Password</Password></ImpersonationInfo>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateAccount</ImpersonationMode>
<Account>Domain\UserName</Account>
<Password>Password</Password></ImpersonationInfo>
No comments:
Post a Comment