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

OLEDB provider error.

Hi:

I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this.?

OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.".

Msg 7373, Level 16, State 2, Line 1

Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)".

Thanks,

Pramod

What's your Extended Properties? Please check whether there is any typo.|||

Xinwei:

Extended properties for my database is null...

Thanks,

Pramod

|||

Just leave it blank like this: Extended Properties="".
What's your whole connection string?
Thanks.

|||

Xinwei:

This is the query i am using...

SELECT a.* FROM OPENROWSET( 'MSOLAP','DATASOURCE=PKUMAR\PKUMAR;

Initial Catalog=Analysis Services Project1;', 'SELECT Measures.members ON ROWS,

[Product Category].members ON COLUMNS FROM [Adventure Works Internet Sales]') as a

go

Thanks,

|||The problem is on the Extended Properities as the error msg stated. If you have nothing to specify, please try delete it.|||Yep...it didnt help|||I am moving this to the SQL Server Analysis Services Forum.