Report Viewing and Vista

Hi

I am facing a strange problem while viewing a Windows Report in Windows Vista.

I have a machine which has Vista installed as the Operating system. I have two user id created to log into the system.

(Assumed user A and User B). Both the users have the same login credentials. However, the default user of the system is

User B.

I have a windows application, which uses Winreports for viewing the reports. I am creating the entire rdlc on - the - fly based on

the parameters specified from the User Interface. If I log into the system using user A and try to view the reports, the report is

perfectly generated and is being viewed properly without any error. However, if I log into the system using User B (the

default user of the system) and then try to view the same report (with all the parameters same) I am getting an Unauthorised

Access Violation error.

Please help with some of our valuable suggestions.

FYI: This happens only on PC having Windows Vista as the Operating System

Thanking you in advance,

Kind Regards,

PS

Hi Everybody,

Thank you very much to everybody who went through this issue.

Actually, the profile of user B had some issues. I deleted the account User B and re - created again, and it worked fine.

Thanking You once again,

Kind Regards,

Pratik

Report Viewer/Authentication

Hello,
We are trying to avoid the login pop-up when using the report viewer control
from an internet facing solution. Sorry it is long, but here is the scenario.
ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
legacy ASP application that we have added an ASP.NET page that uses the
report viewer control to connect to ServerB.
ServerB (the report server, windows 2003 server SP1, RS Standard Edition
SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
what the report viewer control uses from ServerA. ServerB has a local user
that has full access to the reports that need to be delivered.
When you first try to access the report server (ServerB) from the internet
it prompts for a username and password. Once the local user's credentials
from ServerB have been entered we are able to view all reports until the
browser is closed. We have RS 2000 Standard Edition so there is no option for
a custom security extension.
Is there anyway that we can avoid forcing the web users to type in the
username and password that was setup on ServerB? I have tried everything I
can think of and have had no success. There are many security issues with
making that RS login public using URL access and even more security issues by
making the report server allow anonymous access. I need a solution!
Any help would be greatly appreciated.
Thanks in advance!how your users are authenticated on the serverA?
(form authentication or basic authentication?)
The reportviewer webcontrol is a ASP.Net 2.0 control.
do you use another version?
the .Net 2 version is great, because this version will do what you want to
do!
in .Net 1.1...
To solve your issue, you have to intercept and process the reports using
your own webpages and not authorize the user to access your report server
directly.
(the user must go through your own pages, so you control which credential
will be used to access reportserver instead of prompting the user)
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> Hello,
> We are trying to avoid the login pop-up when using the report viewer
> control
> from an internet facing solution. Sorry it is long, but here is the
> scenario.
> ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
> legacy ASP application that we have added an ASP.NET page that uses the
> report viewer control to connect to ServerB.
> ServerB (the report server, windows 2003 server SP1, RS Standard Edition
> SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
> what the report viewer control uses from ServerA. ServerB has a local
> user
> that has full access to the reports that need to be delivered.
> When you first try to access the report server (ServerB) from the internet
> it prompts for a username and password. Once the local user's credentials
> from ServerB have been entered we are able to view all reports until the
> browser is closed. We have RS 2000 Standard Edition so there is no option
> for
> a custom security extension.
> Is there anyway that we can avoid forcing the web users to type in the
> username and password that was setup on ServerB? I have tried everything
> I
> can think of and have had no success. There are many security issues with
> making that RS login public using URL access and even more security issues
> by
> making the report server allow anonymous access. I need a solution!
> Any help would be greatly appreciated.
> Thanks in advance!|||Users on serverA are authenticated with a custom SQL login from the ASP
pages. The entire site on serverA is classic ASP. We are trying to add the
ASPX page with the report viewer control. We are able to determine if the
users are authenticated once they hit the ASPX/Report Viewer page.
We are using the 1.1 version of the report viewer control that came with SP1
or SP2 for RS 2000.
Once the web user accesses our ASPX page with the report viewer control how
do we set the credentials that access the report server via URL? That is
were everything stops working as planned and the standard login pop-up shows.
You can type the credentials of the user we want them to access with and
everything works fine from that point forward. But we want to set the
credentials in the code-behind of the page and not make the credentials
publicly available.
Any help you could provide to set the credentials that will be used by the
report viewer control would be greatly appreciated. I have poured many hours
into these reports and the integration with the classic ASP site. The
reports use custom assemblies to dynamically build the SQL statements, etc.
but now I can't get internet access to them using the report viewer without
manually typing in the credentials!
Thank you very much.
"Jéjé" wrote:
> how your users are authenticated on the serverA?
> (form authentication or basic authentication?)
> The reportviewer webcontrol is a ASP.Net 2.0 control.
> do you use another version?
> the .Net 2 version is great, because this version will do what you want to
> do!
> in .Net 1.1...
> To solve your issue, you have to intercept and process the reports using
> your own webpages and not authorize the user to access your report server
> directly.
> (the user must go through your own pages, so you control which credential
> will be used to access reportserver instead of prompting the user)
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> > Hello,
> >
> > We are trying to avoid the login pop-up when using the report viewer
> > control
> > from an internet facing solution. Sorry it is long, but here is the
> > scenario.
> >
> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
> > legacy ASP application that we have added an ASP.NET page that uses the
> > report viewer control to connect to ServerB.
> >
> > ServerB (the report server, windows 2003 server SP1, RS Standard Edition
> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
> > what the report viewer control uses from ServerA. ServerB has a local
> > user
> > that has full access to the reports that need to be delivered.
> >
> > When you first try to access the report server (ServerB) from the internet
> > it prompts for a username and password. Once the local user's credentials
> > from ServerB have been entered we are able to view all reports until the
> > browser is closed. We have RS 2000 Standard Edition so there is no option
> > for
> > a custom security extension.
> >
> > Is there anyway that we can avoid forcing the web users to type in the
> > username and password that was setup on ServerB? I have tried everything
> > I
> > can think of and have had no success. There are many security issues with
> > making that RS login public using URL access and even more security issues
> > by
> > making the report server allow anonymous access. I need a solution!
> >
> > Any help would be greatly appreciated.
> >
> > Thanks in advance!
>
>|||this control use an IFrame to render the report.
this IFrame "redirect" the user to RS directly.
To override this issue you have to open your pages on the ServerA web site
and disallow the users to access the serverb directly.
To do this, you have to render the reports by yourself using your own ASPX
page(s) (you have to call the SOAP API and not use the URL access)
another way...
look at this reverse proxy tool:
http://www.saltypickle.com/Home/16
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> Users on serverA are authenticated with a custom SQL login from the ASP
> pages. The entire site on serverA is classic ASP. We are trying to add
> the
> ASPX page with the report viewer control. We are able to determine if the
> users are authenticated once they hit the ASPX/Report Viewer page.
> We are using the 1.1 version of the report viewer control that came with
> SP1
> or SP2 for RS 2000.
> Once the web user accesses our ASPX page with the report viewer control
> how
> do we set the credentials that access the report server via URL? That is
> were everything stops working as planned and the standard login pop-up
> shows.
> You can type the credentials of the user we want them to access with and
> everything works fine from that point forward. But we want to set the
> credentials in the code-behind of the page and not make the credentials
> publicly available.
> Any help you could provide to set the credentials that will be used by the
> report viewer control would be greatly appreciated. I have poured many
> hours
> into these reports and the integration with the classic ASP site. The
> reports use custom assemblies to dynamically build the SQL statements,
> etc.
> but now I can't get internet access to them using the report viewer
> without
> manually typing in the credentials!
> Thank you very much.
>
> "Jéjé" wrote:
>> how your users are authenticated on the serverA?
>> (form authentication or basic authentication?)
>> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> do you use another version?
>> the .Net 2 version is great, because this version will do what you want
>> to
>> do!
>> in .Net 1.1...
>> To solve your issue, you have to intercept and process the reports using
>> your own webpages and not authorize the user to access your report server
>> directly.
>> (the user must go through your own pages, so you control which credential
>> will be used to access reportserver instead of prompting the user)
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> > Hello,
>> >
>> > We are trying to avoid the login pop-up when using the report viewer
>> > control
>> > from an internet facing solution. Sorry it is long, but here is the
>> > scenario.
>> >
>> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving
>> > a
>> > legacy ASP application that we have added an ASP.NET page that uses the
>> > report viewer control to connect to ServerB.
>> >
>> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> > Edition
>> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This
>> > is
>> > what the report viewer control uses from ServerA. ServerB has a local
>> > user
>> > that has full access to the reports that need to be delivered.
>> >
>> > When you first try to access the report server (ServerB) from the
>> > internet
>> > it prompts for a username and password. Once the local user's
>> > credentials
>> > from ServerB have been entered we are able to view all reports until
>> > the
>> > browser is closed. We have RS 2000 Standard Edition so there is no
>> > option
>> > for
>> > a custom security extension.
>> >
>> > Is there anyway that we can avoid forcing the web users to type in the
>> > username and password that was setup on ServerB? I have tried
>> > everything
>> > I
>> > can think of and have had no success. There are many security issues
>> > with
>> > making that RS login public using URL access and even more security
>> > issues
>> > by
>> > making the report server allow anonymous access. I need a solution!
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Thanks in advance!
>>|||Hello,
Do you have links to any samples using the SOAP API? Do you still have the
option to show the toolbar, hide parameters, etc. like the URL access?
Thanks!
"Jéjé" wrote:
> this control use an IFrame to render the report.
> this IFrame "redirect" the user to RS directly.
> To override this issue you have to open your pages on the ServerA web site
> and disallow the users to access the serverb directly.
> To do this, you have to render the reports by yourself using your own ASPX
> page(s) (you have to call the SOAP API and not use the URL access)
> another way...
> look at this reverse proxy tool:
> http://www.saltypickle.com/Home/16
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> > Users on serverA are authenticated with a custom SQL login from the ASP
> > pages. The entire site on serverA is classic ASP. We are trying to add
> > the
> > ASPX page with the report viewer control. We are able to determine if the
> > users are authenticated once they hit the ASPX/Report Viewer page.
> >
> > We are using the 1.1 version of the report viewer control that came with
> > SP1
> > or SP2 for RS 2000.
> >
> > Once the web user accesses our ASPX page with the report viewer control
> > how
> > do we set the credentials that access the report server via URL? That is
> > were everything stops working as planned and the standard login pop-up
> > shows.
> > You can type the credentials of the user we want them to access with and
> > everything works fine from that point forward. But we want to set the
> > credentials in the code-behind of the page and not make the credentials
> > publicly available.
> >
> > Any help you could provide to set the credentials that will be used by the
> > report viewer control would be greatly appreciated. I have poured many
> > hours
> > into these reports and the integration with the classic ASP site. The
> > reports use custom assemblies to dynamically build the SQL statements,
> > etc.
> > but now I can't get internet access to them using the report viewer
> > without
> > manually typing in the credentials!
> >
> > Thank you very much.
> >
> >
> > "Jéjé" wrote:
> >
> >> how your users are authenticated on the serverA?
> >> (form authentication or basic authentication?)
> >>
> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> do you use another version?
> >> the .Net 2 version is great, because this version will do what you want
> >> to
> >> do!
> >>
> >> in .Net 1.1...
> >> To solve your issue, you have to intercept and process the reports using
> >> your own webpages and not authorize the user to access your report server
> >> directly.
> >> (the user must go through your own pages, so you control which credential
> >> will be used to access reportserver instead of prompting the user)
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> > Hello,
> >> >
> >> > We are trying to avoid the login pop-up when using the report viewer
> >> > control
> >> > from an internet facing solution. Sorry it is long, but here is the
> >> > scenario.
> >> >
> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving
> >> > a
> >> > legacy ASP application that we have added an ASP.NET page that uses the
> >> > report viewer control to connect to ServerB.
> >> >
> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> > Edition
> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This
> >> > is
> >> > what the report viewer control uses from ServerA. ServerB has a local
> >> > user
> >> > that has full access to the reports that need to be delivered.
> >> >
> >> > When you first try to access the report server (ServerB) from the
> >> > internet
> >> > it prompts for a username and password. Once the local user's
> >> > credentials
> >> > from ServerB have been entered we are able to view all reports until
> >> > the
> >> > browser is closed. We have RS 2000 Standard Edition so there is no
> >> > option
> >> > for
> >> > a custom security extension.
> >> >
> >> > Is there anyway that we can avoid forcing the web users to type in the
> >> > username and password that was setup on ServerB? I have tried
> >> > everything
> >> > I
> >> > can think of and have had no success. There are many security issues
> >> > with
> >> > making that RS login public using URL access and even more security
> >> > issues
> >> > by
> >> > making the report server allow anonymous access. I need a solution!
> >> >
> >> > Any help would be greatly appreciated.
> >> >
> >> > Thanks in advance!
> >>
> >>
> >>
>
>|||you have to develop the parameters interface.
there is samples on the web and in RS books
a good sample:
http://www.codeproject.com/aspnet/SQLRSViewer.asp
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> Hello,
> Do you have links to any samples using the SOAP API? Do you still have
> the
> option to show the toolbar, hide parameters, etc. like the URL access?
> Thanks!
> "Jéjé" wrote:
>> this control use an IFrame to render the report.
>> this IFrame "redirect" the user to RS directly.
>> To override this issue you have to open your pages on the ServerA web
>> site
>> and disallow the users to access the serverb directly.
>> To do this, you have to render the reports by yourself using your own
>> ASPX
>> page(s) (you have to call the SOAP API and not use the URL access)
>> another way...
>> look at this reverse proxy tool:
>> http://www.saltypickle.com/Home/16
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> > Users on serverA are authenticated with a custom SQL login from the ASP
>> > pages. The entire site on serverA is classic ASP. We are trying to
>> > add
>> > the
>> > ASPX page with the report viewer control. We are able to determine if
>> > the
>> > users are authenticated once they hit the ASPX/Report Viewer page.
>> >
>> > We are using the 1.1 version of the report viewer control that came
>> > with
>> > SP1
>> > or SP2 for RS 2000.
>> >
>> > Once the web user accesses our ASPX page with the report viewer control
>> > how
>> > do we set the credentials that access the report server via URL? That
>> > is
>> > were everything stops working as planned and the standard login pop-up
>> > shows.
>> > You can type the credentials of the user we want them to access with
>> > and
>> > everything works fine from that point forward. But we want to set the
>> > credentials in the code-behind of the page and not make the credentials
>> > publicly available.
>> >
>> > Any help you could provide to set the credentials that will be used by
>> > the
>> > report viewer control would be greatly appreciated. I have poured many
>> > hours
>> > into these reports and the integration with the classic ASP site. The
>> > reports use custom assemblies to dynamically build the SQL statements,
>> > etc.
>> > but now I can't get internet access to them using the report viewer
>> > without
>> > manually typing in the credentials!
>> >
>> > Thank you very much.
>> >
>> >
>> > "Jéjé" wrote:
>> >
>> >> how your users are authenticated on the serverA?
>> >> (form authentication or basic authentication?)
>> >>
>> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> do you use another version?
>> >> the .Net 2 version is great, because this version will do what you
>> >> want
>> >> to
>> >> do!
>> >>
>> >> in .Net 1.1...
>> >> To solve your issue, you have to intercept and process the reports
>> >> using
>> >> your own webpages and not authorize the user to access your report
>> >> server
>> >> directly.
>> >> (the user must go through your own pages, so you control which
>> >> credential
>> >> will be used to access reportserver instead of prompting the user)
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > We are trying to avoid the login pop-up when using the report viewer
>> >> > control
>> >> > from an internet facing solution. Sorry it is long, but here is the
>> >> > scenario.
>> >> >
>> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
>> >> > serving
>> >> > a
>> >> > legacy ASP application that we have added an ASP.NET page that uses
>> >> > the
>> >> > report viewer control to connect to ServerB.
>> >> >
>> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> >> > Edition
>> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
>> >> > This
>> >> > is
>> >> > what the report viewer control uses from ServerA. ServerB has a
>> >> > local
>> >> > user
>> >> > that has full access to the reports that need to be delivered.
>> >> >
>> >> > When you first try to access the report server (ServerB) from the
>> >> > internet
>> >> > it prompts for a username and password. Once the local user's
>> >> > credentials
>> >> > from ServerB have been entered we are able to view all reports until
>> >> > the
>> >> > browser is closed. We have RS 2000 Standard Edition so there is no
>> >> > option
>> >> > for
>> >> > a custom security extension.
>> >> >
>> >> > Is there anyway that we can avoid forcing the web users to type in
>> >> > the
>> >> > username and password that was setup on ServerB? I have tried
>> >> > everything
>> >> > I
>> >> > can think of and have had no success. There are many security
>> >> > issues
>> >> > with
>> >> > making that RS login public using URL access and even more security
>> >> > issues
>> >> > by
>> >> > making the report server allow anonymous access. I need a solution!
>> >> >
>> >> > Any help would be greatly appreciated.
>> >> >
>> >> > Thanks in advance!
>> >>
>> >>
>> >>
>>|||Hello,
I just wanted to confirm that there will be no limitations using the SOAP
API with the Standard version of reporting services. The reason I ask is
that in many of the different solutions I have tried the "this is not
supported in this version" has come up. I tried the logonuser method
connecting to the web service and received a similar error. I was trying to
connect and logon prior to connecting with the report viewer control hoping
that would save the authentication like manually typing in the credentials
does. You only have to manually type them in once, but that is too many!
The sad thing about it is that with all the hours wasted trying to get the
Standard Edition to work we probably could have simply purchased the
Enterprise Edition, used forms authentication and deployed the solution
months ago!
Thanks for all your assistance!
"Jéjé" wrote:
> you have to develop the parameters interface.
> there is samples on the web and in RS books
> a good sample:
> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> > Hello,
> >
> > Do you have links to any samples using the SOAP API? Do you still have
> > the
> > option to show the toolbar, hide parameters, etc. like the URL access?
> >
> > Thanks!
> >
> > "Jéjé" wrote:
> >
> >> this control use an IFrame to render the report.
> >> this IFrame "redirect" the user to RS directly.
> >>
> >> To override this issue you have to open your pages on the ServerA web
> >> site
> >> and disallow the users to access the serverb directly.
> >> To do this, you have to render the reports by yourself using your own
> >> ASPX
> >> page(s) (you have to call the SOAP API and not use the URL access)
> >>
> >> another way...
> >> look at this reverse proxy tool:
> >> http://www.saltypickle.com/Home/16
> >>
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> >> > Users on serverA are authenticated with a custom SQL login from the ASP
> >> > pages. The entire site on serverA is classic ASP. We are trying to
> >> > add
> >> > the
> >> > ASPX page with the report viewer control. We are able to determine if
> >> > the
> >> > users are authenticated once they hit the ASPX/Report Viewer page.
> >> >
> >> > We are using the 1.1 version of the report viewer control that came
> >> > with
> >> > SP1
> >> > or SP2 for RS 2000.
> >> >
> >> > Once the web user accesses our ASPX page with the report viewer control
> >> > how
> >> > do we set the credentials that access the report server via URL? That
> >> > is
> >> > were everything stops working as planned and the standard login pop-up
> >> > shows.
> >> > You can type the credentials of the user we want them to access with
> >> > and
> >> > everything works fine from that point forward. But we want to set the
> >> > credentials in the code-behind of the page and not make the credentials
> >> > publicly available.
> >> >
> >> > Any help you could provide to set the credentials that will be used by
> >> > the
> >> > report viewer control would be greatly appreciated. I have poured many
> >> > hours
> >> > into these reports and the integration with the classic ASP site. The
> >> > reports use custom assemblies to dynamically build the SQL statements,
> >> > etc.
> >> > but now I can't get internet access to them using the report viewer
> >> > without
> >> > manually typing in the credentials!
> >> >
> >> > Thank you very much.
> >> >
> >> >
> >> > "Jéjé" wrote:
> >> >
> >> >> how your users are authenticated on the serverA?
> >> >> (form authentication or basic authentication?)
> >> >>
> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> >> do you use another version?
> >> >> the .Net 2 version is great, because this version will do what you
> >> >> want
> >> >> to
> >> >> do!
> >> >>
> >> >> in .Net 1.1...
> >> >> To solve your issue, you have to intercept and process the reports
> >> >> using
> >> >> your own webpages and not authorize the user to access your report
> >> >> server
> >> >> directly.
> >> >> (the user must go through your own pages, so you control which
> >> >> credential
> >> >> will be used to access reportserver instead of prompting the user)
> >> >>
> >> >>
> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > We are trying to avoid the login pop-up when using the report viewer
> >> >> > control
> >> >> > from an internet facing solution. Sorry it is long, but here is the
> >> >> > scenario.
> >> >> >
> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
> >> >> > serving
> >> >> > a
> >> >> > legacy ASP application that we have added an ASP.NET page that uses
> >> >> > the
> >> >> > report viewer control to connect to ServerB.
> >> >> >
> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> >> > Edition
> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
> >> >> > This
> >> >> > is
> >> >> > what the report viewer control uses from ServerA. ServerB has a
> >> >> > local
> >> >> > user
> >> >> > that has full access to the reports that need to be delivered.
> >> >> >
> >> >> > When you first try to access the report server (ServerB) from the
> >> >> > internet
> >> >> > it prompts for a username and password. Once the local user's
> >> >> > credentials
> >> >> > from ServerB have been entered we are able to view all reports until
> >> >> > the
> >> >> > browser is closed. We have RS 2000 Standard Edition so there is no
> >> >> > option
> >> >> > for
> >> >> > a custom security extension.
> >> >> >
> >> >> > Is there anyway that we can avoid forcing the web users to type in
> >> >> > the
> >> >> > username and password that was setup on ServerB? I have tried
> >> >> > everything
> >> >> > I
> >> >> > can think of and have had no success. There are many security
> >> >> > issues
> >> >> > with
> >> >> > making that RS login public using URL access and even more security
> >> >> > issues
> >> >> > by
> >> >> > making the report server allow anonymous access. I need a solution!
> >> >> >
> >> >> > Any help would be greatly appreciated.
> >> >> >
> >> >> > Thanks in advance!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||the SOAP API is available in any edition.
the link sent to you can be used with any version of RS
when you call the RS webservice, create a specific credential or use the
impersonate account setup in the web.config file
read this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
(the section called "Using specific credentials")
so your application continue to use your own authentication system and
you'll control all the access to RS through your application.
The only limitation:
you can't use the User!UserID in your reports, you have to change this by a
a standard report parameter and fill this parameter in your web application
without displaying this parameter to the end user.
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
> Hello,
> I just wanted to confirm that there will be no limitations using the SOAP
> API with the Standard version of reporting services. The reason I ask is
> that in many of the different solutions I have tried the "this is not
> supported in this version" has come up. I tried the logonuser method
> connecting to the web service and received a similar error. I was trying
> to
> connect and logon prior to connecting with the report viewer control
> hoping
> that would save the authentication like manually typing in the credentials
> does. You only have to manually type them in once, but that is too many!
> The sad thing about it is that with all the hours wasted trying to get the
> Standard Edition to work we probably could have simply purchased the
> Enterprise Edition, used forms authentication and deployed the solution
> months ago!
> Thanks for all your assistance!
>
> "Jéjé" wrote:
>> you have to develop the parameters interface.
>> there is samples on the web and in RS books
>> a good sample:
>> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
>> > Hello,
>> >
>> > Do you have links to any samples using the SOAP API? Do you still have
>> > the
>> > option to show the toolbar, hide parameters, etc. like the URL access?
>> >
>> > Thanks!
>> >
>> > "Jéjé" wrote:
>> >
>> >> this control use an IFrame to render the report.
>> >> this IFrame "redirect" the user to RS directly.
>> >>
>> >> To override this issue you have to open your pages on the ServerA web
>> >> site
>> >> and disallow the users to access the serverb directly.
>> >> To do this, you have to render the reports by yourself using your own
>> >> ASPX
>> >> page(s) (you have to call the SOAP API and not use the URL access)
>> >>
>> >> another way...
>> >> look at this reverse proxy tool:
>> >> http://www.saltypickle.com/Home/16
>> >>
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> >> > Users on serverA are authenticated with a custom SQL login from the
>> >> > ASP
>> >> > pages. The entire site on serverA is classic ASP. We are trying to
>> >> > add
>> >> > the
>> >> > ASPX page with the report viewer control. We are able to determine
>> >> > if
>> >> > the
>> >> > users are authenticated once they hit the ASPX/Report Viewer page.
>> >> >
>> >> > We are using the 1.1 version of the report viewer control that came
>> >> > with
>> >> > SP1
>> >> > or SP2 for RS 2000.
>> >> >
>> >> > Once the web user accesses our ASPX page with the report viewer
>> >> > control
>> >> > how
>> >> > do we set the credentials that access the report server via URL?
>> >> > That
>> >> > is
>> >> > were everything stops working as planned and the standard login
>> >> > pop-up
>> >> > shows.
>> >> > You can type the credentials of the user we want them to access with
>> >> > and
>> >> > everything works fine from that point forward. But we want to set
>> >> > the
>> >> > credentials in the code-behind of the page and not make the
>> >> > credentials
>> >> > publicly available.
>> >> >
>> >> > Any help you could provide to set the credentials that will be used
>> >> > by
>> >> > the
>> >> > report viewer control would be greatly appreciated. I have poured
>> >> > many
>> >> > hours
>> >> > into these reports and the integration with the classic ASP site.
>> >> > The
>> >> > reports use custom assemblies to dynamically build the SQL
>> >> > statements,
>> >> > etc.
>> >> > but now I can't get internet access to them using the report viewer
>> >> > without
>> >> > manually typing in the credentials!
>> >> >
>> >> > Thank you very much.
>> >> >
>> >> >
>> >> > "Jéjé" wrote:
>> >> >
>> >> >> how your users are authenticated on the serverA?
>> >> >> (form authentication or basic authentication?)
>> >> >>
>> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> >> do you use another version?
>> >> >> the .Net 2 version is great, because this version will do what you
>> >> >> want
>> >> >> to
>> >> >> do!
>> >> >>
>> >> >> in .Net 1.1...
>> >> >> To solve your issue, you have to intercept and process the reports
>> >> >> using
>> >> >> your own webpages and not authorize the user to access your report
>> >> >> server
>> >> >> directly.
>> >> >> (the user must go through your own pages, so you control which
>> >> >> credential
>> >> >> will be used to access reportserver instead of prompting the user)
>> >> >>
>> >> >>
>> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> >> > Hello,
>> >> >> >
>> >> >> > We are trying to avoid the login pop-up when using the report
>> >> >> > viewer
>> >> >> > control
>> >> >> > from an internet facing solution. Sorry it is long, but here is
>> >> >> > the
>> >> >> > scenario.
>> >> >> >
>> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
>> >> >> > serving
>> >> >> > a
>> >> >> > legacy ASP application that we have added an ASP.NET page that
>> >> >> > uses
>> >> >> > the
>> >> >> > report viewer control to connect to ServerB.
>> >> >> >
>> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> >> >> > Edition
>> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
>> >> >> > This
>> >> >> > is
>> >> >> > what the report viewer control uses from ServerA. ServerB has a
>> >> >> > local
>> >> >> > user
>> >> >> > that has full access to the reports that need to be delivered.
>> >> >> >
>> >> >> > When you first try to access the report server (ServerB) from the
>> >> >> > internet
>> >> >> > it prompts for a username and password. Once the local user's
>> >> >> > credentials
>> >> >> > from ServerB have been entered we are able to view all reports
>> >> >> > until
>> >> >> > the
>> >> >> > browser is closed. We have RS 2000 Standard Edition so there is
>> >> >> > no
>> >> >> > option
>> >> >> > for
>> >> >> > a custom security extension.
>> >> >> >
>> >> >> > Is there anyway that we can avoid forcing the web users to type
>> >> >> > in
>> >> >> > the
>> >> >> > username and password that was setup on ServerB? I have tried
>> >> >> > everything
>> >> >> > I
>> >> >> > can think of and have had no success. There are many security
>> >> >> > issues
>> >> >> > with
>> >> >> > making that RS login public using URL access and even more
>> >> >> > security
>> >> >> > issues
>> >> >> > by
>> >> >> > making the report server allow anonymous access. I need a
>> >> >> > solution!
>> >> >> >
>> >> >> > Any help would be greatly appreciated.
>> >> >> >
>> >> >> > Thanks in advance!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks again for all your help!
"Jéjé" wrote:
> the SOAP API is available in any edition.
> the link sent to you can be used with any version of RS
> when you call the RS webservice, create a specific credential or use the
> impersonate account setup in the web.config file
> read this:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
> (the section called "Using specific credentials")
> so your application continue to use your own authentication system and
> you'll control all the access to RS through your application.
> The only limitation:
> you can't use the User!UserID in your reports, you have to change this by a
> a standard report parameter and fill this parameter in your web application
> without displaying this parameter to the end user.
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
> > Hello,
> >
> > I just wanted to confirm that there will be no limitations using the SOAP
> > API with the Standard version of reporting services. The reason I ask is
> > that in many of the different solutions I have tried the "this is not
> > supported in this version" has come up. I tried the logonuser method
> > connecting to the web service and received a similar error. I was trying
> > to
> > connect and logon prior to connecting with the report viewer control
> > hoping
> > that would save the authentication like manually typing in the credentials
> > does. You only have to manually type them in once, but that is too many!
> >
> > The sad thing about it is that with all the hours wasted trying to get the
> > Standard Edition to work we probably could have simply purchased the
> > Enterprise Edition, used forms authentication and deployed the solution
> > months ago!
> >
> > Thanks for all your assistance!
> >
> >
> > "Jéjé" wrote:
> >
> >> you have to develop the parameters interface.
> >>
> >> there is samples on the web and in RS books
> >>
> >> a good sample:
> >> http://www.codeproject.com/aspnet/SQLRSViewer.asp
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> >> > Hello,
> >> >
> >> > Do you have links to any samples using the SOAP API? Do you still have
> >> > the
> >> > option to show the toolbar, hide parameters, etc. like the URL access?
> >> >
> >> > Thanks!
> >> >
> >> > "Jéjé" wrote:
> >> >
> >> >> this control use an IFrame to render the report.
> >> >> this IFrame "redirect" the user to RS directly.
> >> >>
> >> >> To override this issue you have to open your pages on the ServerA web
> >> >> site
> >> >> and disallow the users to access the serverb directly.
> >> >> To do this, you have to render the reports by yourself using your own
> >> >> ASPX
> >> >> page(s) (you have to call the SOAP API and not use the URL access)
> >> >>
> >> >> another way...
> >> >> look at this reverse proxy tool:
> >> >> http://www.saltypickle.com/Home/16
> >> >>
> >> >>
> >> >>
> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> >> >> > Users on serverA are authenticated with a custom SQL login from the
> >> >> > ASP
> >> >> > pages. The entire site on serverA is classic ASP. We are trying to
> >> >> > add
> >> >> > the
> >> >> > ASPX page with the report viewer control. We are able to determine
> >> >> > if
> >> >> > the
> >> >> > users are authenticated once they hit the ASPX/Report Viewer page.
> >> >> >
> >> >> > We are using the 1.1 version of the report viewer control that came
> >> >> > with
> >> >> > SP1
> >> >> > or SP2 for RS 2000.
> >> >> >
> >> >> > Once the web user accesses our ASPX page with the report viewer
> >> >> > control
> >> >> > how
> >> >> > do we set the credentials that access the report server via URL?
> >> >> > That
> >> >> > is
> >> >> > were everything stops working as planned and the standard login
> >> >> > pop-up
> >> >> > shows.
> >> >> > You can type the credentials of the user we want them to access with
> >> >> > and
> >> >> > everything works fine from that point forward. But we want to set
> >> >> > the
> >> >> > credentials in the code-behind of the page and not make the
> >> >> > credentials
> >> >> > publicly available.
> >> >> >
> >> >> > Any help you could provide to set the credentials that will be used
> >> >> > by
> >> >> > the
> >> >> > report viewer control would be greatly appreciated. I have poured
> >> >> > many
> >> >> > hours
> >> >> > into these reports and the integration with the classic ASP site.
> >> >> > The
> >> >> > reports use custom assemblies to dynamically build the SQL
> >> >> > statements,
> >> >> > etc.
> >> >> > but now I can't get internet access to them using the report viewer
> >> >> > without
> >> >> > manually typing in the credentials!
> >> >> >
> >> >> > Thank you very much.
> >> >> >
> >> >> >
> >> >> > "Jéjé" wrote:
> >> >> >
> >> >> >> how your users are authenticated on the serverA?
> >> >> >> (form authentication or basic authentication?)
> >> >> >>
> >> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> >> >> do you use another version?
> >> >> >> the .Net 2 version is great, because this version will do what you
> >> >> >> want
> >> >> >> to
> >> >> >> do!
> >> >> >>
> >> >> >> in .Net 1.1...
> >> >> >> To solve your issue, you have to intercept and process the reports
> >> >> >> using
> >> >> >> your own webpages and not authorize the user to access your report
> >> >> >> server
> >> >> >> directly.
> >> >> >> (the user must go through your own pages, so you control which
> >> >> >> credential
> >> >> >> will be used to access reportserver instead of prompting the user)
> >> >> >>
> >> >> >>
> >> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> >> >> > Hello,
> >> >> >> >
> >> >> >> > We are trying to avoid the login pop-up when using the report
> >> >> >> > viewer
> >> >> >> > control
> >> >> >> > from an internet facing solution. Sorry it is long, but here is
> >> >> >> > the
> >> >> >> > scenario.
> >> >> >> >
> >> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
> >> >> >> > serving
> >> >> >> > a
> >> >> >> > legacy ASP application that we have added an ASP.NET page that
> >> >> >> > uses
> >> >> >> > the
> >> >> >> > report viewer control to connect to ServerB.
> >> >> >> >
> >> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> >> >> > Edition
> >> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
> >> >> >> > This
> >> >> >> > is
> >> >> >> > what the report viewer control uses from ServerA. ServerB has a
> >> >> >> > local
> >> >> >> > user
> >> >> >> > that has full access to the reports that need to be delivered.
> >> >> >> >
> >> >> >> > When you first try to access the report server (ServerB) from the
> >> >> >> > internet
> >> >> >> > it prompts for a username and password. Once the local user's
> >> >> >> > credentials
> >> >> >> > from ServerB have been entered we are able to view all reports
> >> >> >> > until
> >> >> >> > the
> >> >> >> > browser is closed. We have RS 2000 Standard Edition so there is
> >> >> >> > no
> >> >> >> > option
> >> >> >> > for
> >> >> >> > a custom security extension.
> >> >> >> >
> >> >> >> > Is there anyway that we can avoid forcing the web users to type
> >> >> >> > in
> >> >> >> > the
> >> >> >> > username and password that was setup on ServerB? I have tried
> >> >> >> > everything
> >> >> >> > I
> >> >> >> > can think of and have had no success. There are many security
> >> >> >> > issues
> >> >> >> > with
> >> >> >> > making that RS login public using URL access and even more
> >> >> >> > security
> >> >> >> > issues
> >> >> >> > by
> >> >> >> > making the report server allow anonymous access. I need a
> >> >> >> > solution!
> >> >> >> >
> >> >> >> > Any help would be greatly appreciated.
> >> >> >> >
> >> >> >> > Thanks in advance!
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||A big setback with using SOAP API is that you lose the report toolbar.
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:68B042E6-912D-4F08-8C81-C77F2F9BDD82@.microsoft.com...
> Thanks again for all your help!
> "Jéjé" wrote:
>> the SOAP API is available in any edition.
>> the link sent to you can be used with any version of RS
>> when you call the RS webservice, create a specific credential or use the
>> impersonate account setup in the web.config file
>> read this:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
>> (the section called "Using specific credentials")
>> so your application continue to use your own authentication system and
>> you'll control all the access to RS through your application.
>> The only limitation:
>> you can't use the User!UserID in your reports, you have to change this by
>> a
>> a standard report parameter and fill this parameter in your web
>> application
>> without displaying this parameter to the end user.
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
>> > Hello,
>> >
>> > I just wanted to confirm that there will be no limitations using the
>> > SOAP
>> > API with the Standard version of reporting services. The reason I ask
>> > is
>> > that in many of the different solutions I have tried the "this is not
>> > supported in this version" has come up. I tried the logonuser method
>> > connecting to the web service and received a similar error. I was
>> > trying
>> > to
>> > connect and logon prior to connecting with the report viewer control
>> > hoping
>> > that would save the authentication like manually typing in the
>> > credentials
>> > does. You only have to manually type them in once, but that is too
>> > many!
>> >
>> > The sad thing about it is that with all the hours wasted trying to get
>> > the
>> > Standard Edition to work we probably could have simply purchased the
>> > Enterprise Edition, used forms authentication and deployed the solution
>> > months ago!
>> >
>> > Thanks for all your assistance!
>> >
>> >
>> > "Jéjé" wrote:
>> >
>> >> you have to develop the parameters interface.
>> >>
>> >> there is samples on the web and in RS books
>> >>
>> >> a good sample:
>> >> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > Do you have links to any samples using the SOAP API? Do you still
>> >> > have
>> >> > the
>> >> > option to show the toolbar, hide parameters, etc. like the URL
>> >> > access?
>> >> >
>> >> > Thanks!
>> >> >
>> >> > "Jéjé" wrote:
>> >> >
>> >> >> this control use an IFrame to render the report.
>> >> >> this IFrame "redirect" the user to RS directly.
>> >> >>
>> >> >> To override this issue you have to open your pages on the ServerA
>> >> >> web
>> >> >> site
>> >> >> and disallow the users to access the serverb directly.
>> >> >> To do this, you have to render the reports by yourself using your
>> >> >> own
>> >> >> ASPX
>> >> >> page(s) (you have to call the SOAP API and not use the URL access)
>> >> >>
>> >> >> another way...
>> >> >> look at this reverse proxy tool:
>> >> >> http://www.saltypickle.com/Home/16
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> >> >> > Users on serverA are authenticated with a custom SQL login from
>> >> >> > the
>> >> >> > ASP
>> >> >> > pages. The entire site on serverA is classic ASP. We are trying
>> >> >> > to
>> >> >> > add
>> >> >> > the
>> >> >> > ASPX page with the report viewer control. We are able to
>> >> >> > determine
>> >> >> > if
>> >> >> > the
>> >> >> > users are authenticated once they hit the ASPX/Report Viewer
>> >> >> > page.
>> >> >> >
>> >> >> > We are using the 1.1 version of the report viewer control that
>> >> >> > came
>> >> >> > with
>> >> >> > SP1
>> >> >> > or SP2 for RS 2000.
>> >> >> >
>> >> >> > Once the web user accesses our ASPX page with the report viewer
>> >> >> > control
>> >> >> > how
>> >> >> > do we set the credentials that access the report server via URL?
>> >> >> > That
>> >> >> > is
>> >> >> > were everything stops working as planned and the standard login
>> >> >> > pop-up
>> >> >> > shows.
>> >> >> > You can type the credentials of the user we want them to access
>> >> >> > with
>> >> >> > and
>> >> >> > everything works fine from that point forward. But we want to
>> >> >> > set
>> >> >> > the
>> >> >> > credentials in the code-behind of the page and not make the
>> >> >> > credentials
>> >> >> > publicly available.
>> >> >> >
>> >> >> > Any help you could provide to set the credentials that will be
>> >> >> > used
>> >> >> > by
>> >> >> > the
>> >> >> > report viewer control would be greatly appreciated. I have
>> >> >> > poured
>> >> >> > many
>> >> >> > hours
>> >> >> > into these reports and the integration with the classic ASP site.
>> >> >> > The
>> >> >> > reports use custom assemblies to dynamically build the SQL
>> >> >> > statements,
>> >> >> > etc.
>> >> >> > but now I can't get internet access to them using the report
>> >> >> > viewer
>> >> >> > without
>> >> >> > manually typing in the credentials!
>> >> >> >
>> >> >> > Thank you very much.
>> >> >> >
>> >> >> >
>> >> >> > "Jéjé" wrote:
>> >> >> >
>> >> >> >> how your users are authenticated on the serverA?
>> >> >> >> (form authentication or basic authentication?)
>> >> >> >>
>> >> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> >> >> do you use another version?
>> >> >> >> the .Net 2 version is great, because this version will do what
>> >> >> >> you
>> >> >> >> want
>> >> >> >> to
>> >> >> >> do!
>> >> >> >>
>> >> >> >> in .Net 1.1...
>> >> >> >> To solve your issue, you have to intercept and process the
>> >> >> >> reports
>> >> >> >> using
>> >> >> >> your own webpages and not authorize the user to access your
>> >> >> >> report
>> >> >> >> server
>> >> >> >> directly.
>> >> >> >> (the user must go through your own pages, so you control which
>> >> >> >> credential
>> >> >> >> will be used to access reportserver instead of prompting the
>> >> >> >> user)
>> >> >> >>
>> >> >> >>
>> >> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote
>> >> >> >> in
>> >> >> >> message
>> >> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> >> >> > Hello,
>> >> >> >> >
>> >> >> >> > We are trying to avoid the login pop-up when using the report
>> >> >> >> > viewer
>> >> >> >> > control
>> >> >> >> > from an internet facing solution. Sorry it is long, but here
>> >> >> >> > is
>> >> >> >> > the
>> >> >> >> > scenario.
>> >> >> >> >
>> >> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework)
>> >> >> >> > is
>> >> >> >> > serving
>> >> >> >> > a
>> >> >> >> > legacy ASP application that we have added an ASP.NET page that
>> >> >> >> > uses
>> >> >> >> > the
>> >> >> >> > report viewer control to connect to ServerB.
>> >> >> >> >
>> >> >> >> > ServerB (the report server, windows 2003 server SP1, RS
>> >> >> >> > Standard
>> >> >> >> > Edition
>> >> >> >> > SP2) there is a public IP that is Nat's to a local IP of
>> >> >> >> > ServerB.
>> >> >> >> > This
>> >> >> >> > is
>> >> >> >> > what the report viewer control uses from ServerA. ServerB has
>> >> >> >> > a
>> >> >> >> > local
>> >> >> >> > user
>> >> >> >> > that has full access to the reports that need to be delivered.
>> >> >> >> >
>> >> >> >> > When you first try to access the report server (ServerB) from
>> >> >> >> > the
>> >> >> >> > internet
>> >> >> >> > it prompts for a username and password. Once the local user's
>> >> >> >> > credentials
>> >> >> >> > from ServerB have been entered we are able to view all reports
>> >> >> >> > until
>> >> >> >> > the
>> >> >> >> > browser is closed. We have RS 2000 Standard Edition so there
>> >> >> >> > is
>> >> >> >> > no
>> >> >> >> > option
>> >> >> >> > for
>> >> >> >> > a custom security extension.
>> >> >> >> >
>> >> >> >> > Is there anyway that we can avoid forcing the web users to
>> >> >> >> > type
>> >> >> >> > in
>> >> >> >> > the
>> >> >> >> > username and password that was setup on ServerB? I have tried
>> >> >> >> > everything
>> >> >> >> > I
>> >> >> >> > can think of and have had no success. There are many security
>> >> >> >> > issues
>> >> >> >> > with
>> >> >> >> > making that RS login public using URL access and even more
>> >> >> >> > security
>> >> >> >> > issues
>> >> >> >> > by
>> >> >> >> > making the report server allow anonymous access. I need a
>> >> >> >> > solution!
>> >> >> >> >
>> >> >> >> > Any help would be greatly appreciated.
>> >> >> >> >
>> >> >> >> > Thanks in advance!
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Report subscription ...help !

I am facing problem today with subscription..it was working fine...but it stopped working today after I tried to make some changes in config file.. ..after I corrected again...its still not working.Here is my problem...I create subsctiptoon for file share ..I enter all required info in page and then click on OK button. but instead of showing my subscription list, it shows this error "The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help " I have checked agent service hundred times in last few hours, its started ...I restarted it again ..I restarted Report Server service too...but its of no use..I am getting the same error again and again... Its quite critical issue for me ...so help me if u have any idea... Thanks !prashant

restart your SQL Agent service and then is should work

Report SnapShot Creation Programmatically through Java

Hi,

I am facing some issues while creating report snapshots programmatically using axis (Java platform for creating and deploying web services applications).

To create a report snapshot what should be the methods called ? I tried using UpdateReportExecutionSnapshot() but didn't find any parameters to set the schedule information which would say when the execute the report snapshot. Can you please guide me for this ?

Also I had one more doubt regarding report snapshots. If a parameterized report is configured as snapshot then we would require to set default parameters for the report.

Is there a way to create snapshots of the same report with different parameters ?

eg : The employee information report displays the information based on the employee id taken as a parameter. So is it possible to create snapshots with different employee id's ?

Thanks,

Amit Shah.

For configuring snapshots programmatically you can call SetReportHistoryOptions SOAP API. But for the task as you described you better pre-populate cache using subscriptions with Null Delivery Provider. You can create multiple ordinal subscriptions with different parameter sets or create one data-driven subscription which will iterate through different parameter sets (e.g. users) via query. Then configure report execution options to allow rendering the report from the cache. See: http://msdn2.microsoft.com/en-us/library/ms155927.aspx and http://msdn2.microsoft.com/en-us/library/ms155876.aspx

|||

Thanks for the replies.

I tried create a report snapshots and saving it in the report history by using the CreateReportHistorySnapshot() method call, but facing some issues with it.

The report being used to create the snapshot is a parameterized report. Hence before calling CreateReportHistorySnapshot() I call setReportParameters(). I pseudo code is something like this :

for( int i=0; i<10; i++) {

reportSnapshot.setParameters(parameterValue)

reportSnapshot.createReportHistorySnapShot().

}

But when I check the report History it has only 4 snapshots created (instead of 10). I confirmed that the report parameters are set properly by calling getReportParameters().

One more important point is that the last report was not having the latest parameter values passed i.e the snapshot was not having the values which are passed during the 10th iteration. It was having values passed during the 7th iteration(this was also not consistent).

Can anyone please guide me.

Thanks in advance.

|||

I don’t have an explanation why you’re missing some reports in the history snapshots. Analyze warnings returned by this API and log file. But history snapshots are not used as cached reports anyways. I would advise exploring Null Delivery Provider for pre-populating the cache as I pointed in my previous reply.

-Igor|||Just to add to my previous posting. The likely reason you are missing some reports in the history is the following. By design RS keeps unique index on ReportID+SnapshotCreateDate in History table, and timestamp’s granularity is in seconds. If report’s default parameters are changed and new snapshot is being created within same second as previously created snapshot, then the last one will be discarded. The bad thing is that RS won’t return an error on CreateReportHistorySnapshot call. This is the known issue.|||

I liked this thread so much, I just blogged about it. Here's the post:

http://blogs.msdn.com/lukaszp/archive/2007/01/12/per-user-snapshots-or-multiple-snapshots-for-a-report-each-with-different-parameters-at-the-same-time.aspx

-Lukasz

|||

Thanks a lot for the replies.

But as you mentioned that :

If report’s default parameters are changed and new snapshot is being created within same second as previously created snapshot, then the last one will be discarded. The bad thing is that RS won’t return an error on CreateReportHistorySnapshot call. This is the known issue.

So if I dont change the parameters or create a snapshot of a report which does not have any parameters, then will more than one snapshots get created in one second ?

I tried this programmatically but the snapshot was not getting created for a parameterless report & also when the reports parameters were not changed. Just wanted to confirm on whether I was doing some thing wrong or it is because of the timestamp's granularity is set in seconds.

Thanks in advance.

|||I believe nothing wrong with your code - it happens because timestamp's granularity is set in seconds.

Report SnapShot Creation Programmatically through Java

Hi,

I am facing some issues while creating report snapshots programmatically using axis (Java platform for creating and deploying web services applications).

To create a report snapshot what should be the methods called ? I tried using UpdateReportExecutionSnapshot() but didn't find any parameters to set the schedule information which would say when the execute the report snapshot. Can you please guide me for this ?

Also I had one more doubt regarding report snapshots. If a parameterized report is configured as snapshot then we would require to set default parameters for the report.

Is there a way to create snapshots of the same report with different parameters ?

eg : The employee information report displays the information based on the employee id taken as a parameter. So is it possible to create snapshots with different employee id's ?

Thanks,

Amit Shah.

For configuring snapshots programmatically you can call SetReportHistoryOptions SOAP API. But for the task as you described you better pre-populate cache using subscriptions with Null Delivery Provider. You can create multiple ordinal subscriptions with different parameter sets or create one data-driven subscription which will iterate through different parameter sets (e.g. users) via query. Then configure report execution options to allow rendering the report from the cache. See: http://msdn2.microsoft.com/en-us/library/ms155927.aspx and http://msdn2.microsoft.com/en-us/library/ms155876.aspx

|||

Thanks for the replies.

I tried create a report snapshots and saving it in the report history by using the CreateReportHistorySnapshot() method call, but facing some issues with it.

The report being used to create the snapshot is a parameterized report. Hence before calling CreateReportHistorySnapshot() I call setReportParameters(). I pseudo code is something like this :

for( int i=0; i<10; i++) {

reportSnapshot.setParameters(parameterValue)

reportSnapshot.createReportHistorySnapShot().

}

But when I check the report History it has only 4 snapshots created (instead of 10). I confirmed that the report parameters are set properly by calling getReportParameters().

One more important point is that the last report was not having the latest parameter values passed i.e the snapshot was not having the values which are passed during the 10th iteration. It was having values passed during the 7th iteration(this was also not consistent).

Can anyone please guide me.

Thanks in advance.

|||

I don’t have an explanation why you’re missing some reports in the history snapshots. Analyze warnings returned by this API and log file. But history snapshots are not used as cached reports anyways. I would advise exploring Null Delivery Provider for pre-populating the cache as I pointed in my previous reply.

-Igor|||Just to add to my previous posting. The likely reason you are missing some reports in the history is the following. By design RS keeps unique index on ReportID+SnapshotCreateDate in History table, and timestamp’s granularity is in seconds. If report’s default parameters are changed and new snapshot is being created within same second as previously created snapshot, then the last one will be discarded. The bad thing is that RS won’t return an error on CreateReportHistorySnapshot call. This is the known issue.|||

I liked this thread so much, I just blogged about it. Here's the post:

http://blogs.msdn.com/lukaszp/archive/2007/01/12/per-user-snapshots-or-multiple-snapshots-for-a-report-each-with-different-parameters-at-the-same-time.aspx

-Lukasz

|||

Thanks a lot for the replies.

But as you mentioned that :

If report’s default parameters are changed and new snapshot is being created within same second as previously created snapshot, then the last one will be discarded. The bad thing is that RS won’t return an error on CreateReportHistorySnapshot call. This is the known issue.

So if I dont change the parameters or create a snapshot of a report which does not have any parameters, then will more than one snapshots get created in one second ?

I tried this programmatically but the snapshot was not getting created for a parameterless report & also when the reports parameters were not changed. Just wanted to confirm on whether I was doing some thing wrong or it is because of the timestamp's granularity is set in seconds.

Thanks in advance.

|||I believe nothing wrong with your code - it happens because timestamp's granularity is set in seconds.

Report Server for e-mail delivery of reports with Lotus Notes

I'm facing a pb in configuring Report Server for e-mail delivery with Lotus
Notes. Is it possible?
If so, what are the points, I should pay attention to.
I entered the Lotus Notes Mail server IP address in SMTPServer key in
RSReportServer.Config file.
I'm getting this error message:"the transport failed to connect to the
server"
I'm using Reporting services (SP1) on Windows 2000 server (SP4).
Thanks for your helpOur new product, Proposion Report Adapter for Microsoft Reporting Services
and Lotus Notes/Domino, fixes this problem and a lot more. (It also allows
you to use Notes/Domino as data sources for reports and/or allows you to
automatically deposit scheduled reports into Notes databases.) See
http://www.proposion.com/ReportAdapter.
Side note: We recently exhibited at a big Lotus user's conference and, to
our surprise, this was our most popular product this year. I ended up doing
dozens of Reporting Services demos and many commented that it blew away
Crystal Reports, etc. Often, people already had SQL Server in house but did
not know about Reporting Services. I also found a fair amount of customers
who were already in the process of switching to Reporting Services, but did
not realize how extensible it was.
I can't wait to get started with the Yukon version!
-Steve
"bhmsaad" <bhmsaad@.discussions.microsoft.com> wrote in message
news:722F9A59-1398-48C9-B4D8-C28AAF5C9A09@.microsoft.com...
> I'm facing a pb in configuring Report Server for e-mail delivery with
> Lotus
> Notes. Is it possible?
> If so, what are the points, I should pay attention to.
> I entered the Lotus Notes Mail server IP address in SMTPServer key in
> RSReportServer.Config file.
> I'm getting this error message:"the transport failed to connect to the
> server"
> I'm using Reporting services (SP1) on Windows 2000 server (SP4).
> Thanks for your help

Report server Error Messages

Hi,

I am using Reporting services through web services using the SOAP API. The problem I am facing is for any errors that occur the messages are getting displayed more than once.

For example : while rendering a report(which takes a parameter) if the parameter is not passed the same error message is displayed thrice.

"This report requires a default or user-defined value for the report parameter 'Num_RP_1'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'Num_RP_1'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'Num_RP_1'. To run or subscribe to this report, you must provide a parameter value."

while calling listChildren() method if the folderpath passed is a non existing one then the same error message is displayed twice.

"The path of the item '/SomeNonExistantPath/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. > The path of the item '/SomeNonExistantPath/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash."

1. Why some messages are displayed twice and some are displayed thrice ?

2. Is there any way to get the error message only once ?

Thanks in advance,

1. Propagation of errors?

2. You can get it down to zero by not invoking the error
You need to finish debugging your web app, add exception handling and add custom error pages.
Forget about the error being displayed 2 or 3 times|||

Thanks for the reply, but I guess I didn't properly convey my problem

The problem is not why the error message is displayed, but it is why the error message displayed thrice or twice. We have the exception handling code in place. On getting an error we just do e.getMessage(), but this displays the error message twice or thrice.

Is there any configuration on the report server or something else which would help to get the error message only once ?