SSRS 2008 Noninteractive Logon with a datasource
I'm having a problem running some reports on a SSRS 2008 server. I'm using a shared datasource that connects to the a database (to extract data for the reports) and uses a "Credentials stored securely in the report server" with "Use as Windows credentials when connecting to the data source" option enabled and a Windows Domain user as credential. The problem lies in the fact that I have to use a noninteractive service account to as the account that I'm connecting to. If I do use a noninteractive account, when I try to run the report I get: An error occurred during client rendering. An error has occurred during report processing. Cannot impersonate user for data source 'DataSource1'. Log on failed. Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569) The windows event log shows a Logon Failure Audit event with Logon Type: 2 (interactive) as the issue. When I try to use a "Credentials are not required" connection type with setting the Exeuction Account to use the same credentials I get a similar error. Could you suggest an idea how to configure the datasource to connect properly without using an interactive logon?
March 18th, 2011 3:30pm

Hi, In your case, i would suggest you set "Credentials are not required" option for the datasource. 1. configure unattend execution account. 2. the datasource connection string should be like this: Data Source=YourServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2011 5:06am

Hi Jerry, I tried what you've suggested and got An error occurred during client rendering. The report server has encountered a configuration error. Logon failed for the unattended execution account. Log on failed. Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569) When you said unattend execution account I assumed you were talking about the execution account. Looking in the windows log I can still see that it tries to do an interactive logon to the SSRS server. Any ideas? Thanks !
March 21st, 2011 1:21pm

Hi mturuta, Yes, the account is execution acocunt in reporting services configuration manager tool. Have you granted sufficient permission for the execution account to access the datasource database? In my reporting enviroment, it worked well. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2011 9:25pm

I've tried that and it didn't help.
April 2nd, 2011 7:24am

The overall response from MS was that it's not possible. So the user running the report has to be interactive.
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 1:58pm

The user account should be interactive, because under the Administrative tools- Local security policy-Local Policies-User Rights Assignment,Under Deny log on locally properties if there No-Interactive logon then we can not use any non interactive account for connecting to the datasource through SSRS. As this policy will superscede another property called Allow log on locally also. Hope this answers the question. Local Policies | User Rights Assignment | " Deny log on locally properties i" policy and add domain users.
August 21st, 2012 9:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics