I have a complexed report
It makes use of two queries and 2 tables
I need to use a group in order to display the information correctly,
If I had one query it would have worked perfectly, But the data I am
retrieving is so complexed that I need to make use of two queries other wise
I get duplicate data
Table 1 contains section1, and 2 of the displayed info
Table 2 contains the 3rd section
it looks like this;
Page 1
header
Section1
Section 2
Section 3
Footer
Page 2
header
Section1
Section 2
Section 3
Footer
So in order to accomplish this I take two tables link them to one dataset.
Add a group, But this results in the following. I need page breaks so I set
the page break option in the group properties
Page 1
header
section 1
section2
Footer
Page 2
section1
section2
Page 3
Section 3
Page 4 Section 3
I then put the 2 tables in a list box, and set the grouping on the list, And
This works 100 %. It groups all the data brilliantly. The problem is I cant
use one query, I need to use two!
SO Is their a work around or some way to link 2 datasets to one list
control.By adding the full path or something. The only way I can currently
reference more than one dataset per table is by using aggeragate funtions.
But =First(Fields!SIZE.Value, "DataSet2") will only return the top 1 result
so that doesnt work I tried (Fields!SIZE.Value, "DataSet2") but that returns
an errorData regions, in SQL Server 2000 Reporting Services, can only be bound to a
single data set with once exception: All secondary data references must be
contained in an aggregate function with the dataset specified. For example,
First(=Fields!<SomeField>.Value), "<SomeDataSet>"), is allowed. To achieve
the effect you want will have to be done in the query. Some of the tools
available to you are joins, unions, openrowset, or linked servers.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Griffen" <Griffen@.discussions.microsoft.com> wrote in message
news:B7A2C3C0-4522-466A-B5D2-08ECCD3471C1@.microsoft.com...
> I have a complexed report
> It makes use of two queries and 2 tables
> I need to use a group in order to display the information correctly,
> If I had one query it would have worked perfectly, But the data I am
> retrieving is so complexed that I need to make use of two queries other
wise
> I get duplicate data
> Table 1 contains section1, and 2 of the displayed info
> Table 2 contains the 3rd section
> it looks like this;
> Page 1
> header
> Section1
> Section 2
> Section 3
> Footer
>
> Page 2
> header
> Section1
> Section 2
> Section 3
> Footer
> So in order to accomplish this I take two tables link them to one dataset.
> Add a group, But this results in the following. I need page breaks so I
set
> the page break option in the group properties
>
> Page 1
> header
> section 1
> section2
> Footer
> Page 2
> section1
> section2
> Page 3
> Section 3
> Page 4 Section 3
> I then put the 2 tables in a list box, and set the grouping on the list,
And
> This works 100 %. It groups all the data brilliantly. The problem is I
cant
> use one query, I need to use two!
> SO Is their a work around or some way to link 2 datasets to one list
> control.By adding the full path or something. The only way I can currently
> reference more than one dataset per table is by using aggeragate funtions.
> But =First(Fields!SIZE.Value, "DataSet2") will only return the top 1
result
> so that doesnt work I tried (Fields!SIZE.Value, "DataSet2") but that
returns
> an errorsql
Showing posts with label display. Show all posts
Showing posts with label display. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
once published, I Cannot display Reports
(sorry, previous posting went too fast - in the middle of editing)
on sql05, from vStudio05, I created a report, it shows fine in preview. and
was deployed successfully.
on //localhost/Reports it is listed as New,
and on //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:
Logon failed. (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
I am not sure if this failure is due to some wrong settings fo the Virtual
directories for (Reports and ReportManager) on the IIS server or for some
other reasons.
Thank you for your help.Check the credentials for the data source.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
> (sorry, previous posting went too fast - in the middle of editing)
> on sql05, from vStudio05, I created a report, it shows fine in preview.
> and was deployed successfully.
> on //localhost/Reports it is listed as New,
> and on //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:
> Logon failed. (rsLogonFailed)
> Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> I am not sure if this failure is due to some wrong settings fo the Virtual
> directories for (Reports and ReportManager) on the IIS server or for some
> other reasons.
> Thank you for your help.
>|||data source credential show Windows authentication, I tested the connection,
it works fine, and I am admin on the box (this is a simple case from the
tutorial pages and uses AdventureWorks)
?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
> Check the credentials for the data source.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>|||What OS are you on?
Also, make sure you do not have anonymous website via IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
> data source credential show Windows authentication, I tested the
> connection, it works fine, and I am admin on the box (this is a simple
> case from the tutorial pages and uses AdventureWorks)
> ?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>>
>|||Yes, Integrated Windows Authentication is selecteed on the web site
Directory security/Authentication Methods.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
> What OS are you on?
> Also, make sure you do not have anonymous website via IIS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>|||What OS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> Yes, Integrated Windows Authentication is selecteed on the web site
> Directory security/Authentication Methods.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>|||windows 2003 server with sp1.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> What OS?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>>
>|||If you are trying to view this from the sever itself, Windows 2003 server
SP1 has enhanced security for IE. You have to add your own computer to the
safe sites list for IE.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
> windows 2003 server with sp1.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>
>>
>>
>>
>>
>|||just to be clear:
1 - after previewing the new report, I save it then deploy it: the report is
deployed and shows on the reort manager as a new report. the last step of
the deploy process Report Builder tries to open the new report in a new IE.
so in the new IE, the hourglass: generating the report shows and then I get
the error I mentioned:
a.. Logon failed.
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
2 - the same error happens if I try to open the report from the Report
Manager (on the IIS, right click on Reports then Browse, the report manager
opens, I try to open the report from there...
3 - I am not sure what you meant by adding my computer to the safe sites:
//Localhost is part of the Trusted Sites. do you mean something else?
thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
> If you are trying to view this from the sever itself, Windows 2003 server
> SP1 has enhanced security for IE. You have to add your own computer to the
> safe sites list for IE.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a
>> simple case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Yeah, you need to add the computer name to trusted sites. Give it a try.
I do not use Report Builder but I do know that with Report Manager there are
times where the name of the server is put in. I don't think you can count on
localhost always being a part of the path, the computer name might be in
there instead, which means that you could get caught up in the enhanced
security.
Anyway, it is worth a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
> just to be clear:
> 1 - after previewing the new report, I save it then deploy it: the report
> is deployed and shows on the reort manager as a new report. the last step
> of the deploy process Report Builder tries to open the new report in a new
> IE. so in the new IE, the hourglass: generating the report shows and then
> I get the error I mentioned:
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> 2 - the same error happens if I try to open the report from the Report
> Manager (on the IIS, right click on Reports then Browse, the report
> manager opens, I try to open the report from there...
> 3 - I am not sure what you meant by adding my computer to the safe sites:
> //Localhost is part of the Trusted Sites. do you mean something else?
> thanks
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003 server
>> SP1 has enhanced security for IE. You have to add your own computer to
>> the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||I added http://computerName to the trusted sites.
still, it tries to generate the report and fails with the same error.
strange!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
> Yeah, you need to add the computer name to trusted sites. Give it a try.
> I do not use Report Builder but I do know that with Report Manager there
> are times where the name of the server is put in. I don't think you can
> count on localhost always being a part of the path, the computer name
> might be in there instead, which means that you could get caught up in the
> enhanced security.
> Anyway, it is worth a try.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the report
>> is deployed and shows on the reort manager as a new report. the last step
>> of the deploy process Report Builder tries to open the new report in a
>> new IE. so in the new IE, the hourglass: generating the report shows and
>> then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe sites:
>> //Localhost is part of the Trusted Sites. do you mean something else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //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:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Do you have another computer you can try this from, i.e. connect across the
network to it?
Also, is your IP address fixed or dynamic? I had a problem once because I
did not have a fixed IP address.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%236qMXmvgHHA.2368@.TK2MSFTNGP04.phx.gbl...
>I added http://computerName to the trusted sites.
> still, it tries to generate the report and fails with the same error.
> strange!
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
>> Yeah, you need to add the computer name to trusted sites. Give it a try.
>> I do not use Report Builder but I do know that with Report Manager there
>> are times where the name of the server is put in. I don't think you can
>> count on localhost always being a part of the path, the computer name
>> might be in there instead, which means that you could get caught up in
>> the enhanced security.
>> Anyway, it is worth a try.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the
>> report is deployed and shows on the reort manager as a new report. the
>> last step of the deploy process Report Builder tries to open the new
>> report in a new IE. so in the new IE, the hourglass: generating the
>> report shows and then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe
>> sites: //Localhost is part of the Trusted Sites. do you mean something
>> else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>>> Yes, Integrated Windows Authentication is selecteed on the web site
>>> Directory security/Authentication Methods.
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>>> Check the credentials for the data source.
>>>>
>>>>
>>>> --
>>>> Bruce Loehle-Conger
>>>> MVP SQL Server Reporting Services
>>>>
>>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //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:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
on sql05, from vStudio05, I created a report, it shows fine in preview. and
was deployed successfully.
on //localhost/Reports it is listed as New,
and on //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:
Logon failed. (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
I am not sure if this failure is due to some wrong settings fo the Virtual
directories for (Reports and ReportManager) on the IIS server or for some
other reasons.
Thank you for your help.Check the credentials for the data source.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
> (sorry, previous posting went too fast - in the middle of editing)
> on sql05, from vStudio05, I created a report, it shows fine in preview.
> and was deployed successfully.
> on //localhost/Reports it is listed as New,
> and on //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:
> Logon failed. (rsLogonFailed)
> Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> I am not sure if this failure is due to some wrong settings fo the Virtual
> directories for (Reports and ReportManager) on the IIS server or for some
> other reasons.
> Thank you for your help.
>|||data source credential show Windows authentication, I tested the connection,
it works fine, and I am admin on the box (this is a simple case from the
tutorial pages and uses AdventureWorks)
?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
> Check the credentials for the data source.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>|||What OS are you on?
Also, make sure you do not have anonymous website via IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
> data source credential show Windows authentication, I tested the
> connection, it works fine, and I am admin on the box (this is a simple
> case from the tutorial pages and uses AdventureWorks)
> ?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>>
>|||Yes, Integrated Windows Authentication is selecteed on the web site
Directory security/Authentication Methods.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
> What OS are you on?
> Also, make sure you do not have anonymous website via IIS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>|||What OS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> Yes, Integrated Windows Authentication is selecteed on the web site
> Directory security/Authentication Methods.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>|||windows 2003 server with sp1.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> What OS?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //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:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>>
>|||If you are trying to view this from the sever itself, Windows 2003 server
SP1 has enhanced security for IE. You have to add your own computer to the
safe sites list for IE.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
> windows 2003 server with sp1.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>
>>
>>
>>
>>
>|||just to be clear:
1 - after previewing the new report, I save it then deploy it: the report is
deployed and shows on the reort manager as a new report. the last step of
the deploy process Report Builder tries to open the new report in a new IE.
so in the new IE, the hourglass: generating the report shows and then I get
the error I mentioned:
a.. Logon failed.
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
2 - the same error happens if I try to open the report from the Report
Manager (on the IIS, right click on Reports then Browse, the report manager
opens, I try to open the report from there...
3 - I am not sure what you meant by adding my computer to the safe sites:
//Localhost is part of the Trusted Sites. do you mean something else?
thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
> If you are trying to view this from the sever itself, Windows 2003 server
> SP1 has enhanced security for IE. You have to add your own computer to the
> safe sites list for IE.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a
>> simple case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Yeah, you need to add the computer name to trusted sites. Give it a try.
I do not use Report Builder but I do know that with Report Manager there are
times where the name of the server is put in. I don't think you can count on
localhost always being a part of the path, the computer name might be in
there instead, which means that you could get caught up in the enhanced
security.
Anyway, it is worth a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
> just to be clear:
> 1 - after previewing the new report, I save it then deploy it: the report
> is deployed and shows on the reort manager as a new report. the last step
> of the deploy process Report Builder tries to open the new report in a new
> IE. so in the new IE, the hourglass: generating the report shows and then
> I get the error I mentioned:
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> 2 - the same error happens if I try to open the report from the Report
> Manager (on the IIS, right click on Reports then Browse, the report
> manager opens, I try to open the report from there...
> 3 - I am not sure what you meant by adding my computer to the safe sites:
> //Localhost is part of the Trusted Sites. do you mean something else?
> thanks
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003 server
>> SP1 has enhanced security for IE. You have to add your own computer to
>> the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //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:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||I added http://computerName to the trusted sites.
still, it tries to generate the report and fails with the same error.
strange!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
> Yeah, you need to add the computer name to trusted sites. Give it a try.
> I do not use Report Builder but I do know that with Report Manager there
> are times where the name of the server is put in. I don't think you can
> count on localhost always being a part of the path, the computer name
> might be in there instead, which means that you could get caught up in the
> enhanced security.
> Anyway, it is worth a try.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the report
>> is deployed and shows on the reort manager as a new report. the last step
>> of the deploy process Report Builder tries to open the new report in a
>> new IE. so in the new IE, the hourglass: generating the report shows and
>> then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe sites:
>> //Localhost is part of the Trusted Sites. do you mean something else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //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:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Do you have another computer you can try this from, i.e. connect across the
network to it?
Also, is your IP address fixed or dynamic? I had a problem once because I
did not have a fixed IP address.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%236qMXmvgHHA.2368@.TK2MSFTNGP04.phx.gbl...
>I added http://computerName to the trusted sites.
> still, it tries to generate the report and fails with the same error.
> strange!
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
>> Yeah, you need to add the computer name to trusted sites. Give it a try.
>> I do not use Report Builder but I do know that with Report Manager there
>> are times where the name of the server is put in. I don't think you can
>> count on localhost always being a part of the path, the computer name
>> might be in there instead, which means that you could get caught up in
>> the enhanced security.
>> Anyway, it is worth a try.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the
>> report is deployed and shows on the reort manager as a new report. the
>> last step of the deploy process Report Builder tries to open the new
>> report in a new IE. so in the new IE, the hourglass: generating the
>> report shows and then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe
>> sites: //Localhost is part of the Trusted Sites. do you mean something
>> else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>>> Yes, Integrated Windows Authentication is selecteed on the web site
>>> Directory security/Authentication Methods.
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>>> Check the credentials for the data source.
>>>>
>>>>
>>>> --
>>>> Bruce Loehle-Conger
>>>> MVP SQL Server Reporting Services
>>>>
>>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //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:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
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
>>
>
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
>>
>
on reporting services 2005(to dsiplay zeroes if data is not there in database)plss helppp
I am working on reporting services 2005 and i need to display zeroes in the report preview for the data which is not there in database,So pls help me if u can
Use the IsNull() or COALESCE functions in your sql. Check the Books Online (BOL) for instructions on how to use them.
On export to excel
I have list within an list and we have section 1 thru 7. We display the list based the parameters seleted from report for some result section might start from 3 thru 6 . In such case when try to export to excel i get huge gaps as i am missing section 1 thru 2 in the report.
How do we avoid those spaces when exporting to excel,
What I could understand from your description is that each section is a list, and all 7 lists are within another list. You have set the visibility of these lists based on some parameter value.
If that is the case, try putting each list inside a rectangle and set the visibility expression for the rectangles, instead of the lists. That should resolve your problem.
-Aayush
Subscribe to:
Posts (Atom)