once published, I Cannot display Reports

Hi,
on sql05, from vStudio05, I created a report, it shows fine in prevew. I
deployed successfully.
on //localhost/Reports it is listed as New,
and //localhost/ReportServer a new <dir> is added to the list, and inside
is the report.
However, I cannot display the report from either page. the error is:
a.. Logon failed. (rsLogonFailed)
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
: from , it is listed as New on ReportManager. it is also listed on
Reportsbut when I try to view it from ReportThe authentication is used at two places.
1. To access the report
2. To access the source database.
So Just check the username and password, properly, as per the error it seems
the username/password is wrong.
Amarnath
"newToSql" wrote:
> Hi,
> on sql05, from vStudio05, I created a report, it shows fine in prevew. I
> deployed successfully.
> on //localhost/Reports it is listed as New,
> and //localhost/ReportServer a new <dir> is added to the list, and inside
> is the report.
> However, I cannot display the report from either page. the error is:
> a.. Logon failed. (rsLogonFailed)
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> : from , it is listed as New on ReportManager. it is also listed on
> Reportsbut when I try to view it from Report
>
>|||Hi Amarnath,
I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys admin
on the sql server 2005...
I added my domain alias as well as my computer alias as sys admin on sql.
I can deploy reports successfully. on the Reporting Server
http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
builtin\admin, my domain alias, and my localcomputer alias all permissions:
Browser, Content Manager, etc... on Home (these permissions show also at the
level of hte reports themselves)
still whe I click to view the report, I get the hour glass "Report is being
generated" then the error message
a.. Logon failed.
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E) b.. c..
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
> The authentication is used at two places.
> 1. To access the report
> 2. To access the source database.
> So Just check the username and password, properly, as per the error it
> seems
> the username/password is wrong.
> Amarnath
> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew. I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //localhost/ReportServer a new <dir> is added to the list, and
>> inside
>> is the report.
>> However, I cannot display the report from either page. the error is:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>|||I found the culprit - first me ! then:
when using the configuration tool to configure the report server: the
Execution Account name was misspelled:
to set the execution account, you have to provide a login name, a passord
and verify the password. This would suggest that the configuration tool
immediately checks the validity of this account, but the configuration tool
does does not check.
Again, thank you and Bruce L for your help.
"newToSql" <noneone@.hotmail.com> wrote in message
news:emQTDOshHHA.4680@.TK2MSFTNGP06.phx.gbl...
> Hi Amarnath,
> I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys
> admin on the sql server 2005...
> I added my domain alias as well as my computer alias as sys admin on sql.
> I can deploy reports successfully. on the Reporting Server
> http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
> builtin\admin, my domain alias, and my localcomputer alias all
> permissions: Browser, Content Manager, etc... on Home (these permissions
> show also at the level of hte reports themselves)
> still whe I click to view the report, I get the hour glass "Report is
> being generated" then the error message
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E) b.. c..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
>> The authentication is used at two places.
>> 1. To access the report
>> 2. To access the source database.
>> So Just check the username and password, properly, as per the error it
>> seems
>> the username/password is wrong.
>> Amarnath
>> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew.
>> I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //localhost/ReportServer a new <dir> is added to the list, and
>> inside
>> is the report.
>> However, I cannot display the report from either page. the error is:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception
>> from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>
>|||I have had a problem when my server had a dynamically assigned IP. Can you
give it a static address?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:emQTDOshHHA.4680@.TK2MSFTNGP06.phx.gbl...
> Hi Amarnath,
> I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys
> admin on the sql server 2005...
> I added my domain alias as well as my computer alias as sys admin on sql.
> I can deploy reports successfully. on the Reporting Server
> http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
> builtin\admin, my domain alias, and my localcomputer alias all
> permissions: Browser, Content Manager, etc... on Home (these permissions
> show also at the level of hte reports themselves)
> still whe I click to view the report, I get the hour glass "Report is
> being generated" then the error message
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E) b.. c..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
>> The authentication is used at two places.
>> 1. To access the report
>> 2. To access the source database.
>> So Just check the username and password, properly, as per the error it
>> seems
>> the username/password is wrong.
>> Amarnath
>> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew.
>> I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //localhost/ReportServer a new <dir> is added to the list, and
>> inside
>> is the report.
>> However, I cannot display the report from either page. the error is:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception
>> from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>
>