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.
>

login problem with new project

I have several reports in a project that I deploy to a debug/development
environment and to production. I'm writing some different kinds of reports
so I created a new project. I've created different folders for these new
reports to go to. I updated the project configuration to point debug and
prod to the same servers but to different folders. The authentication is the
same. I use a SQL Server ID and PW stored within the report. I am admin on
both dev and prod servers.
When I try to deploy the new project reports to either environment, I get
the Reporting Services Login prompt, which I don't remember getting before.
I entered my domain user ID and PW but that did not work. I can still deploy
my old project reports with no issues. I must just be missing some sort of
project set-up step. Any ideas?
StephanieI solved it. I was using ...Reports instead of ...ReportServer in the
configuration.
Stephanie
"Stephanie" wrote:
> I have several reports in a project that I deploy to a debug/development
> environment and to production. I'm writing some different kinds of reports
> so I created a new project. I've created different folders for these new
> reports to go to. I updated the project configuration to point debug and
> prod to the same servers but to different folders. The authentication is the
> same. I use a SQL Server ID and PW stored within the report. I am admin on
> both dev and prod servers.
> When I try to deploy the new project reports to either environment, I get
> the Reporting Services Login prompt, which I don't remember getting before.
> I entered my domain user ID and PW but that did not work. I can still deploy
> my old project reports with no issues. I must just be missing some sort of
> project set-up step. Any ideas?
> Stephanie