I'm creating Reporting Services reports in Visual Studio. I create a new
report, and see the Data, Layout, and Preview tabs.
In the data tab, I say: "select name from mytable". Four names are returned.
I'd like to display one name per page.
I posted this question a few days ago. The folks that responded (thanks)
suggested that in the Layout tab, I could place a table or list on the form,
then drag the "name" from DataSet1 onto the table or list. The problem with
this approach is that all 4 names are grouped on the first page. I'l like to
see one name per page.
In reality, mytable contains dozens of fields which will go on the report
form. I want Reporting Services to print out a one page report for Mr. Able,
Mr. Baker. Mr. Charles, and so on.
--
RandyI think the best way to handle this is with the List control.
In the layout tab drag the list from the toolbox.
You can then drag the name (and any other field) into the list control.
You can then right click on the List control and select properties.
In the General tab, click "Edit details group..."
In the top line of the expression list, choose the name field from the drop
down.
Check the "Page break at end" checkbox.
Each instance of the list will now show up on it's own page. You can drag
whatever fields you want into the list box.
Hope this helps.
"randy1200" wrote:
> I'm creating Reporting Services reports in Visual Studio. I create a new
> report, and see the Data, Layout, and Preview tabs.
> In the data tab, I say: "select name from mytable". Four names are returned.
> I'd like to display one name per page.
> I posted this question a few days ago. The folks that responded (thanks)
> suggested that in the Layout tab, I could place a table or list on the form,
> then drag the "name" from DataSet1 onto the table or list. The problem with
> this approach is that all 4 names are grouped on the first page. I'l like to
> see one name per page.
> In reality, mytable contains dozens of fields which will go on the report
> form. I want Reporting Services to print out a one page report for Mr. Able,
> Mr. Baker. Mr. Charles, and so on.
> --
> Randy|||Hi,
Hey Its simple. Suppose "select name from mytable" is your query.
After dragging table and placing fields as per your wish. Create a group
with "name" field, so whenever name changes it goes to the next page (dont
forget to click on "page break at end".
Amarnath
"randy1200" wrote:
> I'm creating Reporting Services reports in Visual Studio. I create a new
> report, and see the Data, Layout, and Preview tabs.
> In the data tab, I say: "select name from mytable". Four names are returned.
> I'd like to display one name per page.
> I posted this question a few days ago. The folks that responded (thanks)
> suggested that in the Layout tab, I could place a table or list on the form,
> then drag the "name" from DataSet1 onto the table or list. The problem with
> this approach is that all 4 names are grouped on the first page. I'l like to
> see one name per page.
> In reality, mytable contains dozens of fields which will go on the report
> form. I want Reporting Services to print out a one page report for Mr. Able,
> Mr. Baker. Mr. Charles, and so on.
> --
> Randy|||Got it! Many thanks...
--
Randy
"Amarnath" wrote:
> Hi,
> Hey Its simple. Suppose "select name from mytable" is your query.
> After dragging table and placing fields as per your wish. Create a group
> with "name" field, so whenever name changes it goes to the next page (dont
> forget to click on "page break at end".
> Amarnath
> "randy1200" wrote:
> > I'm creating Reporting Services reports in Visual Studio. I create a new
> > report, and see the Data, Layout, and Preview tabs.
> >
> > In the data tab, I say: "select name from mytable". Four names are returned.
> > I'd like to display one name per page.
> >
> > I posted this question a few days ago. The folks that responded (thanks)
> > suggested that in the Layout tab, I could place a table or list on the form,
> > then drag the "name" from DataSet1 onto the table or list. The problem with
> > this approach is that all 4 names are grouped on the first page. I'l like to
> > see one name per page.
> >
> > In reality, mytable contains dozens of fields which will go on the report
> > form. I want Reporting Services to print out a one page report for Mr. Able,
> > Mr. Baker. Mr. Charles, and so on.
> >
> > --
> > Randy|||That's exactly what I needed. Many thanks...
--
Randy
"Limey" wrote:
> I think the best way to handle this is with the List control.
> In the layout tab drag the list from the toolbox.
> You can then drag the name (and any other field) into the list control.
> You can then right click on the List control and select properties.
> In the General tab, click "Edit details group..."
> In the top line of the expression list, choose the name field from the drop
> down.
> Check the "Page break at end" checkbox.
> Each instance of the list will now show up on it's own page. You can drag
> whatever fields you want into the list box.
> Hope this helps.
>
> "randy1200" wrote:
> > I'm creating Reporting Services reports in Visual Studio. I create a new
> > report, and see the Data, Layout, and Preview tabs.
> >
> > In the data tab, I say: "select name from mytable". Four names are returned.
> > I'd like to display one name per page.
> >
> > I posted this question a few days ago. The folks that responded (thanks)
> > suggested that in the Layout tab, I could place a table or list on the form,
> > then drag the "name" from DataSet1 onto the table or list. The problem with
> > this approach is that all 4 names are grouped on the first page. I'l like to
> > see one name per page.
> >
> > In reality, mytable contains dozens of fields which will go on the report
> > form. I want Reporting Services to print out a one page report for Mr. Able,
> > Mr. Baker. Mr. Charles, and so on.
> >
> > --
> > Randy
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
On-Demand E-Mail Delivery
Hi,
Is there a way to deliver reports via email without any subscriptions?
Because, most of the time the reports users will send will only be sent once
and if i create a subscription for each of these i'll end up with hunders of
necessary subscriptions.
Any comments and ideas are welcome. Thanks in advance.
Best regards,
VolkanI solved the problem. In case someone faces a similar situation, i'll write
down my solution for future reference. It's not exactly how i wanted it to be
but at least it works.
01. Create a TimedSubscription and store its subscription ID. (Schedule
value doesn't matter, we'll delete it anyway after email is sent)
02. Call FireEvent method of the ReportingService class with EventData
parameter set to subscription ID.
03. Get subscription list and check if the event is triggered by checking
the LastExecuted property of the subscription object.
04. If the subscription is executed call DeleteSubscription
Maybe there's a better way out there but until i find it i'll stick with
this even tough it has some drawbacks.
Regards.
Is there a way to deliver reports via email without any subscriptions?
Because, most of the time the reports users will send will only be sent once
and if i create a subscription for each of these i'll end up with hunders of
necessary subscriptions.
Any comments and ideas are welcome. Thanks in advance.
Best regards,
VolkanI solved the problem. In case someone faces a similar situation, i'll write
down my solution for future reference. It's not exactly how i wanted it to be
but at least it works.
01. Create a TimedSubscription and store its subscription ID. (Schedule
value doesn't matter, we'll delete it anyway after email is sent)
02. Call FireEvent method of the ReportingService class with EventData
parameter set to subscription ID.
03. Get subscription list and check if the event is triggered by checking
the LastExecuted property of the subscription object.
04. If the subscription is executed call DeleteSubscription
Maybe there's a better way out there but until i find it i'll stick with
this even tough it has some drawbacks.
Regards.
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
>>
>
Subscribe to:
Posts (Atom)