Logon Failure when executing report

I'm using RS 2005. I created a report that works fine in Visual Studio
and I can deploy it to the report server without any errors. But when
I try to execute the report in the Report Manager or by using a URL, I
get the following error: Logon Failed: unknown user name or bad
password. I have the default security settings for the report (Builtin
Administrators Group only). I am logged on as a domain administrator
when I try to run the report. What logon is the error referring to?
Thanks in advance for any help.How do you authenticate against your datasource?
What happens if you try it from a different computer?
If you are using NT authentication in your datasource, check what user you
are running the report as. One way is by adding your report site to Trusted
SItes in IE (Internet Options -Security) and then set Always prompt for
username and password in the Security Settings.
Kaisa M. Lindahl
"dba56" <lvigorito@.berdonllp.com> wrote in message
news:1137038010.522621.70160@.o13g2000cwo.googlegroups.com...
> I'm using RS 2005. I created a report that works fine in Visual Studio
> and I can deploy it to the report server without any errors. But when
> I try to execute the report in the Report Manager or by using a URL, I
> get the following error: Logon Failed: unknown user name or bad
> password. I have the default security settings for the report (Builtin
> Administrators Group only). I am logged on as a domain administrator
> when I try to run the report. What logon is the error referring to?
> Thanks in advance for any help.
>|||Thanks for the quick response. It turned out to be the execution
account. Don't know why it needs to log on with the execution account
when executing a report. But once I entered the correct login and
password for the execution account in the configuration utility,
reports run without any glitches.|||Hi
I've the same problem when executing my report from the Report Manager. It
works fine in the development tool though.
I run my report under almost the same conditions as you did, i.e
- as a local admin on the test server (Report Service and source database on
the same machine, the development tool to)
- The data source is set the SQL authentication and I have gone as far as
using the sa login
- In the config manager I have updated the Sevice to run as a local user
which is a member of the admin group and the two ReportinServices groups.
I still get the "log in failure". What more is there to do?
/Jesper
"dba56" wrote:
> Thanks for the quick response. It turned out to be the execution
> account. Don't know why it needs to log on with the execution account
> when executing a report. But once I entered the correct login and
> password for the execution account in the configuration utility,
> reports run without any glitches.
>

Logon failure executing reports in SRS2005

Environment: Application server with WS2003, IIS 6.0 and Reporting Services
2005; Database server with WS2003 and SQL Server 2005.
Each time I want to execure a report I get the following error message:
Logon failed. -->
Logon failure: the user has not been granted the requested logon type at
this computer. (Exception from HRESULT: 0x80070569)
Reporting Services Configuration tool does not show any errors.
Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
SERVICE.
Database Connection uses sa.
It does not make any difference from where I execute the report, application
server, client, Report Manager, Report Builder, always the same login
fauilure.What user is the Application Pool for the report virtual directories running
under?
I did have lots of problems with a RS server where someone had used a domain
user as the identity for the application pool. This domain user did not have
the access rigth to "Log on as a service", which was needed. I changed the
identity to run as network service, and all the errors went away. Might help
for you as well.
Kaisa M. Lindahl Lervik
"ChrisWF" <ChrisWF@.discussions.microsoft.com> wrote in message
news:0E9D8B8F-2A31-4731-B7B0-9F7D6348D3A1@.microsoft.com...
> Environment: Application server with WS2003, IIS 6.0 and Reporting
> Services
> 2005; Database server with WS2003 and SQL Server 2005.
> Each time I want to execure a report I get the following error message:
> Logon failed. -->
> Logon failure: the user has not been granted the requested logon type at
> this computer. (Exception from HRESULT: 0x80070569)
> Reporting Services Configuration tool does not show any errors.
> Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
> SERVICE.
> Database Connection uses sa.
> It does not make any difference from where I execute the report,
> application
> server, client, Report Manager, Report Builder, always the same login
> fauilure.|||They run under the Network Service account.
But your response triggered me to check once more the execution account (a
domain account) I use to perform unattended operations. When I added this
account to the administrators group it worked. Probably not the right
solution but at least I could move on with the testing.
Thanks,
Chris
"Kaisa M. Lindahl Lervik" wrote:
> What user is the Application Pool for the report virtual directories running
> under?
> I did have lots of problems with a RS server where someone had used a domain
> user as the identity for the application pool. This domain user did not have
> the access rigth to "Log on as a service", which was needed. I changed the
> identity to run as network service, and all the errors went away. Might help
> for you as well.
> Kaisa M. Lindahl Lervik
> "ChrisWF" <ChrisWF@.discussions.microsoft.com> wrote in message
> news:0E9D8B8F-2A31-4731-B7B0-9F7D6348D3A1@.microsoft.com...
> > Environment: Application server with WS2003, IIS 6.0 and Reporting
> > Services
> > 2005; Database server with WS2003 and SQL Server 2005.
> >
> > Each time I want to execure a report I get the following error message:
> >
> > Logon failed. -->
> > Logon failure: the user has not been granted the requested logon type at
> > this computer. (Exception from HRESULT: 0x80070569)
> >
> > Reporting Services Configuration tool does not show any errors.
> > Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
> > SERVICE.
> > Database Connection uses sa.
> >
> > It does not make any difference from where I execute the report,
> > application
> > server, client, Report Manager, Report Builder, always the same login
> > fauilure.
>
>