November 30, 2010 at 3:34 am
We are using a windows service account to connect from SSRS report to Analysis service Cube. This service accoung user name and password are hardcoded in the report datasource properties, checked option "Use as Windows credentials when connecting to the data source". This service account has full permissions at the cube level. When i am running the report, i am getting the following issue
An error occurred during client rendering.
An error has occurred during report processing.
Cannot impersonate user for data source 'ALERTCUBE'.
Log on failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
I tried adding the user in Admin group in both Reportin Server and in Analysis Server. But no Use.
As per the microsoft site http://technet.microsoft.com/en-us/library/cc161372.aspx i verified all the required permissions (logon on locally) for this service account. All are good. But not able to connnect to the cube.
If i hard code my credentials, report is running fine.
Looks like the problem is only with the service account.
Please help me if you come across this kind of issue
Thanks
November 30, 2010 at 4:21 am
I figured out the problem. It is due to the service account is present in the "Deny logon locally" Group.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply