I'm relatively new to SSAS and have run into an issue when attempting to process a dimension or cube from within Sql Server Management Server. I've seen this error mentioned several times in various posts, but so far nothing I've found has directly
applied to what I'm running into.
The error is:
Could not load file or assembly 'System.Transactions, Version=126.96.36.199, Culture=neutral,PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception
from HRESULT: 0x80070542)
Sql Server and Analysis Services (2012) are running on the same server and I'm logged in as a local administrator.
SSAS has a single database that has a Data Source defined that is using a specific account (mine) that is used for the Impersonate Account of that Data Source.
The Impersonate Account has a sysadmin role on the local SqlServer instance.
I've tried various accounts in various combinations but have not been able to get an account to successfully process any dimension or cube.
I'd appreciate any help or direction in resolving this.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.