Showing posts with label call. Show all posts
Showing posts with label call. Show all posts

Monday, March 19, 2012

Bad Request for ReportServer

Hi
I've got the problem that http://myserver/Reports works perfect. I get
the folders and I get the reports.
However, when I try to call http://myserver/ReportServer I do get the
first folder listing, but as soon as I click into a folder I get a
"Bad Request" (400) error message.
Does anyone has an idea, why'
Thanks,
AndyOn Apr 28, 11:31 pm, andy moo <andy...@.techie.com> wrote:
> Hi
> I've got the problem thathttp://myserver/Reportsworks perfect. I get
> the folders and I get the reports.
> However, when I try to callhttp://myserver/ReportServerI do get the
> first folder listing, but as soon as I click into a folder I get a
> "Bad Request" (400) error message.
> Does anyone has an idea, why'
> Thanks,
> Andy
Try going to IIS and setting the IP address for the RS web site to All
Unassigned.
Brian.

Bad Practice: Calling Views From w/in Stored Procs

In general, is it bad practice to call a view from w/in a stored proc?
Some sites imply that SQL server creates two connections thereby
straining system resources that much more, some sites claim it doesn't.There is no penalty to using a view, whether inside a stored procedure
or not. There is no second connection from using a view.
If you have a source that actually says that, I would be concerned
about counting on that source for information.
Roy Harvey
Beacon Falls, CT
On 2 May 2006 10:45:32 -0700, "roy.@.nderson@.gm@.il.com"
<roy.anderson@.gmail.com> wrote:

>In general, is it bad practice to call a view from w/in a stored proc?
>Some sites imply that SQL server creates two connections thereby
>straining system resources that much more, some sites claim it doesn't.|||> Some sites imply that SQL server creates two connections thereby
> straining system resources that much more
Can you reference such a site / source?
A