Hi,
Our application using an SQL 2000 database, which is currently using Windows
Authentication. For some reason, we need to change the access mode to mixed
mode. Could someone please throw some light on the impact of this change.
Thanks in advance
SuhasOne extra door to guard?
Not sure what you mean by impact. From a performance or resource overhead
perspective? Nothing there. From a security perspective, you now need to
figure out how to manage the SQL Server logins to ensure they follow your
password policies (complexity, length, expiration, re-use, etc...). Not much
help built into SQL Server 2000 but in 2005, life gets a LOT better.
joe.
"Suhas Vengilat" <SuhasVengilat@.discussions.microsoft.com> wrote in message
news:34F882D9-448F-4EDC-A62C-BB87CCAF9307@.microsoft.com...
> Hi,
> Our application using an SQL 2000 database, which is currently using
> Windows
> Authentication. For some reason, we need to change the access mode to
> mixed
> mode. Could someone please throw some light on the impact of this change.
> Thanks in advance
> Suhas|||With either SQL Server 2000 or SQL Server 2005, the process is virtually
identical as follows:
Run SQL Enterprise Manager (or Start > Run > SQLwb.exe if using 2005)
Connect to the server
Launch Server Properties dialog
Switch to the Security tab
Select the Authentication option (Mixed or Windows only) > OK
Dismiss the "restart the server to implement changes" message box
"Restart" the MSSQLServer service (Start > Run > Compmgmt.msc >
services.msc)
Regards,
Keith
This posting is provided "as is" without inferring rights or warranties.
"Joe Yong" <NO_jyong_SPAM@.scalabilityexperts.com> wrote in message
news:OVSeLmxvFHA.1032@.TK2MSFTNGP12.phx.gbl...
> One extra door to guard?
> Not sure what you mean by impact. From a performance or resource overhead
> perspective? Nothing there. From a security perspective, you now need to
> figure out how to manage the SQL Server logins to ensure they follow your
> password policies (complexity, length, expiration, re-use, etc...). Not
> much help built into SQL Server 2000 but in 2005, life gets a LOT better.
>
> joe.
>
> "Suhas Vengilat" <SuhasVengilat@.discussions.microsoft.com> wrote in
> message news:34F882D9-448F-4EDC-A62C-BB87CCAF9307@.microsoft.com...
>
Showing posts with label access. Show all posts
Showing posts with label access. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
images, stream ids, etc
ok, I have finally made my mind about how I will be doing the displaying
images in my site when I am using soap access ... here is the thread I posted
before:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
as long as I understand stream ids are unique, so the way I am doing this is
as follows:
1) I have an aspx page to render my reports
2) I have a grid to display the parameters, which definition I grab
dinamically trough soap access ... which gives me nice things, like types,
valid values (which are translated to dropdownlists:P), default values,
dependencies, etc ...
3) Once the user clicks the view report button (there are others, as export,
...) and the parameters have been validated I get the report from Reporting
Services, indicating that the streamroot is a special page I will have to
display images, indicating in the query string the parameters values and
related stuff selected by the user ...
4) As I said I will have a page to display the images. Right at the moment
the user is accesing this page, it will make the call to the reporting
services, thus I wont be having the need to handle saving the images and then
deleting them.
5) I dont want that page to be asking for an image it has already handled,
which might in turn be an image that appears in the very same report several
times ... In order to do this I will be turning asp.net cache on in that
page, so asp.net will handle saving it temporarily ...
The Question:
Does that way of handling the image is good enough when talking about
performance? ...
in the mean time, I will be doing that image page, and testing all this ...
I would highly apreciate any comments on this ...Eglasius,
Did you have success with this? I have done nearly the exact same thing,
but have found a couple of problems with chart images.
I first wanted (and prefer) to allow the client browser to cache the entire
page so that as they drill through the report charts, they can easily go back
by using the browser's back button -- requiring no return to the server.
However, I found that the streamIDs are NOT unique in some cases. For
example, I have a pie chart that with one set of data has a stream id of
C_21_S. The user drills through this chart and the chart is now rendered
using different data which obviously produces a different looking chart.
BUT! -- the stream id is still C_21_S! The browser of course cached the last
version of the image so the report renders with the wrong chart.
I considered a couple of options:
1) Adding something unique to the streamroot in addition to the
not-so-unique streamid. Then, the client browser would consider the image
url unique even if the streamid is not. I guess I would have to generate a
guid to use in the stream root. Perhasps something like this:
"<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
"&imageid=</StreamRoot>"
2) Second option would be to send HTTP headers to prevent caching of just
the image elements -- I think this is possible, but wanted to avoid it.
Thoughts anyone?
"eglasius" wrote:
> ok, I have finally made my mind about how I will be doing the displaying
> images in my site when I am using soap access ... here is the thread I posted
> before:
> http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> as long as I understand stream ids are unique, so the way I am doing this is
> as follows:
> 1) I have an aspx page to render my reports
> 2) I have a grid to display the parameters, which definition I grab
> dinamically trough soap access ... which gives me nice things, like types,
> valid values (which are translated to dropdownlists:P), default values,
> dependencies, etc ...
> 3) Once the user clicks the view report button (there are others, as export,
> ...) and the parameters have been validated I get the report from Reporting
> Services, indicating that the streamroot is a special page I will have to
> display images, indicating in the query string the parameters values and
> related stuff selected by the user ...
> 4) As I said I will have a page to display the images. Right at the moment
> the user is accesing this page, it will make the call to the reporting
> services, thus I wont be having the need to handle saving the images and then
> deleting them.
> 5) I dont want that page to be asking for an image it has already handled,
> which might in turn be an image that appears in the very same report several
> times ... In order to do this I will be turning asp.net cache on in that
> page, so asp.net will handle saving it temporarily ...
> The Question:
> Does that way of handling the image is good enough when talking about
> performance? ...
> in the mean time, I will be doing that image page, and testing all this ...
> I would highly apreciate any comments on this ...|||Well, my case was a very particular one, since I wasnt using dynamic images
(it was a static logo) yet, but I did want the image to be grabbed from the
report. The solution I used also needed to be compatible in case I were to
use dynamic images.
The thing is so far it has worked well, but we are using any dynamic image.
Because of this, I have no clue if I would experience the very same problem
that is happening to you.
On the other hand, I do have to say that at the end I didn't have to turn
asp.net cache on for the image served, since the browser seems to ask for the
image only once regardless of configuration (what I was worried about was a
browser with the "every visit to the page" configuration turned on asking for
a 20 pages report and ending up getting the image 20 times, which at the end
didn't happen).
In your case I would check if the drilled down page is actually being asked
to asp.net (or it is coming from the cache), and if not using a guid sounds
reasonable. If you have any other "unique" value (that relates to drilling
down) you are already using at hand, you might as well use that one instead.
One thing that really grabbed my attention, is that you aren't including
which report or params in the stream root. Unless your report doesn't have
parameters, all of them are fixed or your are saving them in some middle
object, I don't seem to understand how your are doing it.
I say so, because of this:
reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
encoding, out mimeType);
when getting the image one sends the report + streamId+parms.
"David Swanson" wrote:
> Eglasius,
> Did you have success with this? I have done nearly the exact same thing,
> but have found a couple of problems with chart images.
> I first wanted (and prefer) to allow the client browser to cache the entire
> page so that as they drill through the report charts, they can easily go back
> by using the browser's back button -- requiring no return to the server.
> However, I found that the streamIDs are NOT unique in some cases. For
> example, I have a pie chart that with one set of data has a stream id of
> C_21_S. The user drills through this chart and the chart is now rendered
> using different data which obviously produces a different looking chart.
> BUT! -- the stream id is still C_21_S! The browser of course cached the last
> version of the image so the report renders with the wrong chart.
> I considered a couple of options:
> 1) Adding something unique to the streamroot in addition to the
> not-so-unique streamid. Then, the client browser would consider the image
> url unique even if the streamid is not. I guess I would have to generate a
> guid to use in the stream root. Perhasps something like this:
> "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> "&imageid=</StreamRoot>"
> 2) Second option would be to send HTTP headers to prevent caching of just
> the image elements -- I think this is possible, but wanted to avoid it.
> Thoughts anyone?
> "eglasius" wrote:
> > ok, I have finally made my mind about how I will be doing the displaying
> > images in my site when I am using soap access ... here is the thread I posted
> > before:
> > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> >
> > as long as I understand stream ids are unique, so the way I am doing this is
> > as follows:
> > 1) I have an aspx page to render my reports
> > 2) I have a grid to display the parameters, which definition I grab
> > dinamically trough soap access ... which gives me nice things, like types,
> > valid values (which are translated to dropdownlists:P), default values,
> > dependencies, etc ...
> > 3) Once the user clicks the view report button (there are others, as export,
> > ...) and the parameters have been validated I get the report from Reporting
> > Services, indicating that the streamroot is a special page I will have to
> > display images, indicating in the query string the parameters values and
> > related stuff selected by the user ...
> > 4) As I said I will have a page to display the images. Right at the moment
> > the user is accesing this page, it will make the call to the reporting
> > services, thus I wont be having the need to handle saving the images and then
> > deleting them.
> > 5) I dont want that page to be asking for an image it has already handled,
> > which might in turn be an image that appears in the very same report several
> > times ... In order to do this I will be turning asp.net cache on in that
> > page, so asp.net will handle saving it temporarily ...
> >
> > The Question:
> > Does that way of handling the image is good enough when talking about
> > performance? ...
> >
> > in the mean time, I will be doing that image page, and testing all this ...
> > I would highly apreciate any comments on this ...|||Thanks for your prompt reply!
Yes, I was being lazy and store the report params in the user session. We
have a boat load of params that are used in a custom DPE and it was a
headache to format them all on the querystring, so I just keep the params
collection in the session and the imageproxy page gets it from there.
Unless someone from the MS team has a better idea, I think I will have to
include a guid. The other really odd thing is that the report has a pie
chart and a stacked bar chart. The pie chart always seems to use the same
stream id, but the stacked bar chart has always created a unique id --so far.
Can anyone from the MS Reporting Services team explain the behavior of how
the streamids are generated for the dynamic images produced by the chart
objects?
Much appreciated, David
"eglasius" wrote:
> Well, my case was a very particular one, since I wasnt using dynamic images
> (it was a static logo) yet, but I did want the image to be grabbed from the
> report. The solution I used also needed to be compatible in case I were to
> use dynamic images.
> The thing is so far it has worked well, but we are using any dynamic image.
> Because of this, I have no clue if I would experience the very same problem
> that is happening to you.
> On the other hand, I do have to say that at the end I didn't have to turn
> asp.net cache on for the image served, since the browser seems to ask for the
> image only once regardless of configuration (what I was worried about was a
> browser with the "every visit to the page" configuration turned on asking for
> a 20 pages report and ending up getting the image 20 times, which at the end
> didn't happen).
> In your case I would check if the drilled down page is actually being asked
> to asp.net (or it is coming from the cache), and if not using a guid sounds
> reasonable. If you have any other "unique" value (that relates to drilling
> down) you are already using at hand, you might as well use that one instead.
> One thing that really grabbed my attention, is that you aren't including
> which report or params in the stream root. Unless your report doesn't have
> parameters, all of them are fixed or your are saving them in some middle
> object, I don't seem to understand how your are doing it.
> I say so, because of this:
> reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> encoding, out mimeType);
> when getting the image one sends the report + streamId+parms.
> "David Swanson" wrote:
> > Eglasius,
> >
> > Did you have success with this? I have done nearly the exact same thing,
> > but have found a couple of problems with chart images.
> >
> > I first wanted (and prefer) to allow the client browser to cache the entire
> > page so that as they drill through the report charts, they can easily go back
> > by using the browser's back button -- requiring no return to the server.
> >
> > However, I found that the streamIDs are NOT unique in some cases. For
> > example, I have a pie chart that with one set of data has a stream id of
> > C_21_S. The user drills through this chart and the chart is now rendered
> > using different data which obviously produces a different looking chart.
> > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > version of the image so the report renders with the wrong chart.
> >
> > I considered a couple of options:
> >
> > 1) Adding something unique to the streamroot in addition to the
> > not-so-unique streamid. Then, the client browser would consider the image
> > url unique even if the streamid is not. I guess I would have to generate a
> > guid to use in the stream root. Perhasps something like this:
> >
> > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > "&imageid=</StreamRoot>"
> >
> > 2) Second option would be to send HTTP headers to prevent caching of just
> > the image elements -- I think this is possible, but wanted to avoid it.
> >
> > Thoughts anyone?
> >
> > "eglasius" wrote:
> >
> > > ok, I have finally made my mind about how I will be doing the displaying
> > > images in my site when I am using soap access ... here is the thread I posted
> > > before:
> > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > >
> > > as long as I understand stream ids are unique, so the way I am doing this is
> > > as follows:
> > > 1) I have an aspx page to render my reports
> > > 2) I have a grid to display the parameters, which definition I grab
> > > dinamically trough soap access ... which gives me nice things, like types,
> > > valid values (which are translated to dropdownlists:P), default values,
> > > dependencies, etc ...
> > > 3) Once the user clicks the view report button (there are others, as export,
> > > ...) and the parameters have been validated I get the report from Reporting
> > > Services, indicating that the streamroot is a special page I will have to
> > > display images, indicating in the query string the parameters values and
> > > related stuff selected by the user ...
> > > 4) As I said I will have a page to display the images. Right at the moment
> > > the user is accesing this page, it will make the call to the reporting
> > > services, thus I wont be having the need to handle saving the images and then
> > > deleting them.
> > > 5) I dont want that page to be asking for an image it has already handled,
> > > which might in turn be an image that appears in the very same report several
> > > times ... In order to do this I will be turning asp.net cache on in that
> > > page, so asp.net will handle saving it temporarily ...
> > >
> > > The Question:
> > > Does that way of handling the image is good enough when talking about
> > > performance? ...
> > >
> > > in the mean time, I will be doing that image page, and testing all this ...
> > > I would highly apreciate any comments on this ...|||FYI: I did add a guid and it works perfectly now. I still would like MS to
explain to the newsgroup how streamids are created and why they would not be
unique for a dynamic chart image. Seems like a bug to me.
"David Swanson" wrote:
> Thanks for your prompt reply!
> Yes, I was being lazy and store the report params in the user session. We
> have a boat load of params that are used in a custom DPE and it was a
> headache to format them all on the querystring, so I just keep the params
> collection in the session and the imageproxy page gets it from there.
> Unless someone from the MS team has a better idea, I think I will have to
> include a guid. The other really odd thing is that the report has a pie
> chart and a stacked bar chart. The pie chart always seems to use the same
> stream id, but the stacked bar chart has always created a unique id --so far.
>
> Can anyone from the MS Reporting Services team explain the behavior of how
> the streamids are generated for the dynamic images produced by the chart
> objects?
> Much appreciated, David
> "eglasius" wrote:
> > Well, my case was a very particular one, since I wasnt using dynamic images
> > (it was a static logo) yet, but I did want the image to be grabbed from the
> > report. The solution I used also needed to be compatible in case I were to
> > use dynamic images.
> >
> > The thing is so far it has worked well, but we are using any dynamic image.
> > Because of this, I have no clue if I would experience the very same problem
> > that is happening to you.
> >
> > On the other hand, I do have to say that at the end I didn't have to turn
> > asp.net cache on for the image served, since the browser seems to ask for the
> > image only once regardless of configuration (what I was worried about was a
> > browser with the "every visit to the page" configuration turned on asking for
> > a 20 pages report and ending up getting the image 20 times, which at the end
> > didn't happen).
> >
> > In your case I would check if the drilled down page is actually being asked
> > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > reasonable. If you have any other "unique" value (that relates to drilling
> > down) you are already using at hand, you might as well use that one instead.
> >
> > One thing that really grabbed my attention, is that you aren't including
> > which report or params in the stream root. Unless your report doesn't have
> > parameters, all of them are fixed or your are saving them in some middle
> > object, I don't seem to understand how your are doing it.
> > I say so, because of this:
> > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > encoding, out mimeType);
> > when getting the image one sends the report + streamId+parms.
> >
> > "David Swanson" wrote:
> >
> > > Eglasius,
> > >
> > > Did you have success with this? I have done nearly the exact same thing,
> > > but have found a couple of problems with chart images.
> > >
> > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > page so that as they drill through the report charts, they can easily go back
> > > by using the browser's back button -- requiring no return to the server.
> > >
> > > However, I found that the streamIDs are NOT unique in some cases. For
> > > example, I have a pie chart that with one set of data has a stream id of
> > > C_21_S. The user drills through this chart and the chart is now rendered
> > > using different data which obviously produces a different looking chart.
> > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > version of the image so the report renders with the wrong chart.
> > >
> > > I considered a couple of options:
> > >
> > > 1) Adding something unique to the streamroot in addition to the
> > > not-so-unique streamid. Then, the client browser would consider the image
> > > url unique even if the streamid is not. I guess I would have to generate a
> > > guid to use in the stream root. Perhasps something like this:
> > >
> > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > "&imageid=</StreamRoot>"
> > >
> > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > the image elements -- I think this is possible, but wanted to avoid it.
> > >
> > > Thoughts anyone?
> > >
> > > "eglasius" wrote:
> > >
> > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > images in my site when I am using soap access ... here is the thread I posted
> > > > before:
> > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > >
> > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > as follows:
> > > > 1) I have an aspx page to render my reports
> > > > 2) I have a grid to display the parameters, which definition I grab
> > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > valid values (which are translated to dropdownlists:P), default values,
> > > > dependencies, etc ...
> > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > ...) and the parameters have been validated I get the report from Reporting
> > > > Services, indicating that the streamroot is a special page I will have to
> > > > display images, indicating in the query string the parameters values and
> > > > related stuff selected by the user ...
> > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > the user is accesing this page, it will make the call to the reporting
> > > > services, thus I wont be having the need to handle saving the images and then
> > > > deleting them.
> > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > which might in turn be an image that appears in the very same report several
> > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > page, so asp.net will handle saving it temporarily ...
> > > >
> > > > The Question:
> > > > Does that way of handling the image is good enough when talking about
> > > > performance? ...
> > > >
> > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > I would highly apreciate any comments on this ...|||> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
As long as the user doesn't open different reports at the same time (it
hardly should happen ...) and you don't have an incredibly large amount of
users, it is ok :)
I also wan't to know if it is a bug or a behavior by design (and why) ...
"David Swanson" wrote:
> FYI: I did add a guid and it works perfectly now. I still would like MS to
> explain to the newsgroup how streamids are created and why they would not be
> unique for a dynamic chart image. Seems like a bug to me.
> "David Swanson" wrote:
> > Thanks for your prompt reply!
> >
> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
> >
> > Unless someone from the MS team has a better idea, I think I will have to
> > include a guid. The other really odd thing is that the report has a pie
> > chart and a stacked bar chart. The pie chart always seems to use the same
> > stream id, but the stacked bar chart has always created a unique id --so far.
> >
> >
> > Can anyone from the MS Reporting Services team explain the behavior of how
> > the streamids are generated for the dynamic images produced by the chart
> > objects?
> >
> > Much appreciated, David
> >
> > "eglasius" wrote:
> >
> > > Well, my case was a very particular one, since I wasnt using dynamic images
> > > (it was a static logo) yet, but I did want the image to be grabbed from the
> > > report. The solution I used also needed to be compatible in case I were to
> > > use dynamic images.
> > >
> > > The thing is so far it has worked well, but we are using any dynamic image.
> > > Because of this, I have no clue if I would experience the very same problem
> > > that is happening to you.
> > >
> > > On the other hand, I do have to say that at the end I didn't have to turn
> > > asp.net cache on for the image served, since the browser seems to ask for the
> > > image only once regardless of configuration (what I was worried about was a
> > > browser with the "every visit to the page" configuration turned on asking for
> > > a 20 pages report and ending up getting the image 20 times, which at the end
> > > didn't happen).
> > >
> > > In your case I would check if the drilled down page is actually being asked
> > > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > > reasonable. If you have any other "unique" value (that relates to drilling
> > > down) you are already using at hand, you might as well use that one instead.
> > >
> > > One thing that really grabbed my attention, is that you aren't including
> > > which report or params in the stream root. Unless your report doesn't have
> > > parameters, all of them are fixed or your are saving them in some middle
> > > object, I don't seem to understand how your are doing it.
> > > I say so, because of this:
> > > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > > encoding, out mimeType);
> > > when getting the image one sends the report + streamId+parms.
> > >
> > > "David Swanson" wrote:
> > >
> > > > Eglasius,
> > > >
> > > > Did you have success with this? I have done nearly the exact same thing,
> > > > but have found a couple of problems with chart images.
> > > >
> > > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > > page so that as they drill through the report charts, they can easily go back
> > > > by using the browser's back button -- requiring no return to the server.
> > > >
> > > > However, I found that the streamIDs are NOT unique in some cases. For
> > > > example, I have a pie chart that with one set of data has a stream id of
> > > > C_21_S. The user drills through this chart and the chart is now rendered
> > > > using different data which obviously produces a different looking chart.
> > > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > > version of the image so the report renders with the wrong chart.
> > > >
> > > > I considered a couple of options:
> > > >
> > > > 1) Adding something unique to the streamroot in addition to the
> > > > not-so-unique streamid. Then, the client browser would consider the image
> > > > url unique even if the streamid is not. I guess I would have to generate a
> > > > guid to use in the stream root. Perhasps something like this:
> > > >
> > > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > > "&imageid=</StreamRoot>"
> > > >
> > > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > > the image elements -- I think this is possible, but wanted to avoid it.
> > > >
> > > > Thoughts anyone?
> > > >
> > > > "eglasius" wrote:
> > > >
> > > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > > images in my site when I am using soap access ... here is the thread I posted
> > > > > before:
> > > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > > >
> > > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > > as follows:
> > > > > 1) I have an aspx page to render my reports
> > > > > 2) I have a grid to display the parameters, which definition I grab
> > > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > > valid values (which are translated to dropdownlists:P), default values,
> > > > > dependencies, etc ...
> > > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > > ...) and the parameters have been validated I get the report from Reporting
> > > > > Services, indicating that the streamroot is a special page I will have to
> > > > > display images, indicating in the query string the parameters values and
> > > > > related stuff selected by the user ...
> > > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > > the user is accesing this page, it will make the call to the reporting
> > > > > services, thus I wont be having the need to handle saving the images and then
> > > > > deleting them.
> > > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > > which might in turn be an image that appears in the very same report several
> > > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > > page, so asp.net will handle saving it temporarily ...
> > > > >
> > > > > The Question:
> > > > > Does that way of handling the image is good enough when talking about
> > > > > performance? ...
> > > > >
> > > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > > I would highly apreciate any comments on this ...|||thanks you guys!.. I have been having a similar problem.
Recently we went live with reporting services. We are showing some charts,
and everything works fine the first time you show a chart. Subsequent charts
all show the image from the first chart. Hitting ctrl-R gets rid of the
problem, but this is undesirable (users would be confused). I took your idea
about slapping a GUID of some sort to the streamroot so that each request the
browser gets the image from the server.
Thanks again you guys!
Happy new years!
images in my site when I am using soap access ... here is the thread I posted
before:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
as long as I understand stream ids are unique, so the way I am doing this is
as follows:
1) I have an aspx page to render my reports
2) I have a grid to display the parameters, which definition I grab
dinamically trough soap access ... which gives me nice things, like types,
valid values (which are translated to dropdownlists:P), default values,
dependencies, etc ...
3) Once the user clicks the view report button (there are others, as export,
...) and the parameters have been validated I get the report from Reporting
Services, indicating that the streamroot is a special page I will have to
display images, indicating in the query string the parameters values and
related stuff selected by the user ...
4) As I said I will have a page to display the images. Right at the moment
the user is accesing this page, it will make the call to the reporting
services, thus I wont be having the need to handle saving the images and then
deleting them.
5) I dont want that page to be asking for an image it has already handled,
which might in turn be an image that appears in the very same report several
times ... In order to do this I will be turning asp.net cache on in that
page, so asp.net will handle saving it temporarily ...
The Question:
Does that way of handling the image is good enough when talking about
performance? ...
in the mean time, I will be doing that image page, and testing all this ...
I would highly apreciate any comments on this ...Eglasius,
Did you have success with this? I have done nearly the exact same thing,
but have found a couple of problems with chart images.
I first wanted (and prefer) to allow the client browser to cache the entire
page so that as they drill through the report charts, they can easily go back
by using the browser's back button -- requiring no return to the server.
However, I found that the streamIDs are NOT unique in some cases. For
example, I have a pie chart that with one set of data has a stream id of
C_21_S. The user drills through this chart and the chart is now rendered
using different data which obviously produces a different looking chart.
BUT! -- the stream id is still C_21_S! The browser of course cached the last
version of the image so the report renders with the wrong chart.
I considered a couple of options:
1) Adding something unique to the streamroot in addition to the
not-so-unique streamid. Then, the client browser would consider the image
url unique even if the streamid is not. I guess I would have to generate a
guid to use in the stream root. Perhasps something like this:
"<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
"&imageid=</StreamRoot>"
2) Second option would be to send HTTP headers to prevent caching of just
the image elements -- I think this is possible, but wanted to avoid it.
Thoughts anyone?
"eglasius" wrote:
> ok, I have finally made my mind about how I will be doing the displaying
> images in my site when I am using soap access ... here is the thread I posted
> before:
> http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> as long as I understand stream ids are unique, so the way I am doing this is
> as follows:
> 1) I have an aspx page to render my reports
> 2) I have a grid to display the parameters, which definition I grab
> dinamically trough soap access ... which gives me nice things, like types,
> valid values (which are translated to dropdownlists:P), default values,
> dependencies, etc ...
> 3) Once the user clicks the view report button (there are others, as export,
> ...) and the parameters have been validated I get the report from Reporting
> Services, indicating that the streamroot is a special page I will have to
> display images, indicating in the query string the parameters values and
> related stuff selected by the user ...
> 4) As I said I will have a page to display the images. Right at the moment
> the user is accesing this page, it will make the call to the reporting
> services, thus I wont be having the need to handle saving the images and then
> deleting them.
> 5) I dont want that page to be asking for an image it has already handled,
> which might in turn be an image that appears in the very same report several
> times ... In order to do this I will be turning asp.net cache on in that
> page, so asp.net will handle saving it temporarily ...
> The Question:
> Does that way of handling the image is good enough when talking about
> performance? ...
> in the mean time, I will be doing that image page, and testing all this ...
> I would highly apreciate any comments on this ...|||Well, my case was a very particular one, since I wasnt using dynamic images
(it was a static logo) yet, but I did want the image to be grabbed from the
report. The solution I used also needed to be compatible in case I were to
use dynamic images.
The thing is so far it has worked well, but we are using any dynamic image.
Because of this, I have no clue if I would experience the very same problem
that is happening to you.
On the other hand, I do have to say that at the end I didn't have to turn
asp.net cache on for the image served, since the browser seems to ask for the
image only once regardless of configuration (what I was worried about was a
browser with the "every visit to the page" configuration turned on asking for
a 20 pages report and ending up getting the image 20 times, which at the end
didn't happen).
In your case I would check if the drilled down page is actually being asked
to asp.net (or it is coming from the cache), and if not using a guid sounds
reasonable. If you have any other "unique" value (that relates to drilling
down) you are already using at hand, you might as well use that one instead.
One thing that really grabbed my attention, is that you aren't including
which report or params in the stream root. Unless your report doesn't have
parameters, all of them are fixed or your are saving them in some middle
object, I don't seem to understand how your are doing it.
I say so, because of this:
reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
encoding, out mimeType);
when getting the image one sends the report + streamId+parms.
"David Swanson" wrote:
> Eglasius,
> Did you have success with this? I have done nearly the exact same thing,
> but have found a couple of problems with chart images.
> I first wanted (and prefer) to allow the client browser to cache the entire
> page so that as they drill through the report charts, they can easily go back
> by using the browser's back button -- requiring no return to the server.
> However, I found that the streamIDs are NOT unique in some cases. For
> example, I have a pie chart that with one set of data has a stream id of
> C_21_S. The user drills through this chart and the chart is now rendered
> using different data which obviously produces a different looking chart.
> BUT! -- the stream id is still C_21_S! The browser of course cached the last
> version of the image so the report renders with the wrong chart.
> I considered a couple of options:
> 1) Adding something unique to the streamroot in addition to the
> not-so-unique streamid. Then, the client browser would consider the image
> url unique even if the streamid is not. I guess I would have to generate a
> guid to use in the stream root. Perhasps something like this:
> "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> "&imageid=</StreamRoot>"
> 2) Second option would be to send HTTP headers to prevent caching of just
> the image elements -- I think this is possible, but wanted to avoid it.
> Thoughts anyone?
> "eglasius" wrote:
> > ok, I have finally made my mind about how I will be doing the displaying
> > images in my site when I am using soap access ... here is the thread I posted
> > before:
> > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> >
> > as long as I understand stream ids are unique, so the way I am doing this is
> > as follows:
> > 1) I have an aspx page to render my reports
> > 2) I have a grid to display the parameters, which definition I grab
> > dinamically trough soap access ... which gives me nice things, like types,
> > valid values (which are translated to dropdownlists:P), default values,
> > dependencies, etc ...
> > 3) Once the user clicks the view report button (there are others, as export,
> > ...) and the parameters have been validated I get the report from Reporting
> > Services, indicating that the streamroot is a special page I will have to
> > display images, indicating in the query string the parameters values and
> > related stuff selected by the user ...
> > 4) As I said I will have a page to display the images. Right at the moment
> > the user is accesing this page, it will make the call to the reporting
> > services, thus I wont be having the need to handle saving the images and then
> > deleting them.
> > 5) I dont want that page to be asking for an image it has already handled,
> > which might in turn be an image that appears in the very same report several
> > times ... In order to do this I will be turning asp.net cache on in that
> > page, so asp.net will handle saving it temporarily ...
> >
> > The Question:
> > Does that way of handling the image is good enough when talking about
> > performance? ...
> >
> > in the mean time, I will be doing that image page, and testing all this ...
> > I would highly apreciate any comments on this ...|||Thanks for your prompt reply!
Yes, I was being lazy and store the report params in the user session. We
have a boat load of params that are used in a custom DPE and it was a
headache to format them all on the querystring, so I just keep the params
collection in the session and the imageproxy page gets it from there.
Unless someone from the MS team has a better idea, I think I will have to
include a guid. The other really odd thing is that the report has a pie
chart and a stacked bar chart. The pie chart always seems to use the same
stream id, but the stacked bar chart has always created a unique id --so far.
Can anyone from the MS Reporting Services team explain the behavior of how
the streamids are generated for the dynamic images produced by the chart
objects?
Much appreciated, David
"eglasius" wrote:
> Well, my case was a very particular one, since I wasnt using dynamic images
> (it was a static logo) yet, but I did want the image to be grabbed from the
> report. The solution I used also needed to be compatible in case I were to
> use dynamic images.
> The thing is so far it has worked well, but we are using any dynamic image.
> Because of this, I have no clue if I would experience the very same problem
> that is happening to you.
> On the other hand, I do have to say that at the end I didn't have to turn
> asp.net cache on for the image served, since the browser seems to ask for the
> image only once regardless of configuration (what I was worried about was a
> browser with the "every visit to the page" configuration turned on asking for
> a 20 pages report and ending up getting the image 20 times, which at the end
> didn't happen).
> In your case I would check if the drilled down page is actually being asked
> to asp.net (or it is coming from the cache), and if not using a guid sounds
> reasonable. If you have any other "unique" value (that relates to drilling
> down) you are already using at hand, you might as well use that one instead.
> One thing that really grabbed my attention, is that you aren't including
> which report or params in the stream root. Unless your report doesn't have
> parameters, all of them are fixed or your are saving them in some middle
> object, I don't seem to understand how your are doing it.
> I say so, because of this:
> reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> encoding, out mimeType);
> when getting the image one sends the report + streamId+parms.
> "David Swanson" wrote:
> > Eglasius,
> >
> > Did you have success with this? I have done nearly the exact same thing,
> > but have found a couple of problems with chart images.
> >
> > I first wanted (and prefer) to allow the client browser to cache the entire
> > page so that as they drill through the report charts, they can easily go back
> > by using the browser's back button -- requiring no return to the server.
> >
> > However, I found that the streamIDs are NOT unique in some cases. For
> > example, I have a pie chart that with one set of data has a stream id of
> > C_21_S. The user drills through this chart and the chart is now rendered
> > using different data which obviously produces a different looking chart.
> > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > version of the image so the report renders with the wrong chart.
> >
> > I considered a couple of options:
> >
> > 1) Adding something unique to the streamroot in addition to the
> > not-so-unique streamid. Then, the client browser would consider the image
> > url unique even if the streamid is not. I guess I would have to generate a
> > guid to use in the stream root. Perhasps something like this:
> >
> > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > "&imageid=</StreamRoot>"
> >
> > 2) Second option would be to send HTTP headers to prevent caching of just
> > the image elements -- I think this is possible, but wanted to avoid it.
> >
> > Thoughts anyone?
> >
> > "eglasius" wrote:
> >
> > > ok, I have finally made my mind about how I will be doing the displaying
> > > images in my site when I am using soap access ... here is the thread I posted
> > > before:
> > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > >
> > > as long as I understand stream ids are unique, so the way I am doing this is
> > > as follows:
> > > 1) I have an aspx page to render my reports
> > > 2) I have a grid to display the parameters, which definition I grab
> > > dinamically trough soap access ... which gives me nice things, like types,
> > > valid values (which are translated to dropdownlists:P), default values,
> > > dependencies, etc ...
> > > 3) Once the user clicks the view report button (there are others, as export,
> > > ...) and the parameters have been validated I get the report from Reporting
> > > Services, indicating that the streamroot is a special page I will have to
> > > display images, indicating in the query string the parameters values and
> > > related stuff selected by the user ...
> > > 4) As I said I will have a page to display the images. Right at the moment
> > > the user is accesing this page, it will make the call to the reporting
> > > services, thus I wont be having the need to handle saving the images and then
> > > deleting them.
> > > 5) I dont want that page to be asking for an image it has already handled,
> > > which might in turn be an image that appears in the very same report several
> > > times ... In order to do this I will be turning asp.net cache on in that
> > > page, so asp.net will handle saving it temporarily ...
> > >
> > > The Question:
> > > Does that way of handling the image is good enough when talking about
> > > performance? ...
> > >
> > > in the mean time, I will be doing that image page, and testing all this ...
> > > I would highly apreciate any comments on this ...|||FYI: I did add a guid and it works perfectly now. I still would like MS to
explain to the newsgroup how streamids are created and why they would not be
unique for a dynamic chart image. Seems like a bug to me.
"David Swanson" wrote:
> Thanks for your prompt reply!
> Yes, I was being lazy and store the report params in the user session. We
> have a boat load of params that are used in a custom DPE and it was a
> headache to format them all on the querystring, so I just keep the params
> collection in the session and the imageproxy page gets it from there.
> Unless someone from the MS team has a better idea, I think I will have to
> include a guid. The other really odd thing is that the report has a pie
> chart and a stacked bar chart. The pie chart always seems to use the same
> stream id, but the stacked bar chart has always created a unique id --so far.
>
> Can anyone from the MS Reporting Services team explain the behavior of how
> the streamids are generated for the dynamic images produced by the chart
> objects?
> Much appreciated, David
> "eglasius" wrote:
> > Well, my case was a very particular one, since I wasnt using dynamic images
> > (it was a static logo) yet, but I did want the image to be grabbed from the
> > report. The solution I used also needed to be compatible in case I were to
> > use dynamic images.
> >
> > The thing is so far it has worked well, but we are using any dynamic image.
> > Because of this, I have no clue if I would experience the very same problem
> > that is happening to you.
> >
> > On the other hand, I do have to say that at the end I didn't have to turn
> > asp.net cache on for the image served, since the browser seems to ask for the
> > image only once regardless of configuration (what I was worried about was a
> > browser with the "every visit to the page" configuration turned on asking for
> > a 20 pages report and ending up getting the image 20 times, which at the end
> > didn't happen).
> >
> > In your case I would check if the drilled down page is actually being asked
> > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > reasonable. If you have any other "unique" value (that relates to drilling
> > down) you are already using at hand, you might as well use that one instead.
> >
> > One thing that really grabbed my attention, is that you aren't including
> > which report or params in the stream root. Unless your report doesn't have
> > parameters, all of them are fixed or your are saving them in some middle
> > object, I don't seem to understand how your are doing it.
> > I say so, because of this:
> > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > encoding, out mimeType);
> > when getting the image one sends the report + streamId+parms.
> >
> > "David Swanson" wrote:
> >
> > > Eglasius,
> > >
> > > Did you have success with this? I have done nearly the exact same thing,
> > > but have found a couple of problems with chart images.
> > >
> > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > page so that as they drill through the report charts, they can easily go back
> > > by using the browser's back button -- requiring no return to the server.
> > >
> > > However, I found that the streamIDs are NOT unique in some cases. For
> > > example, I have a pie chart that with one set of data has a stream id of
> > > C_21_S. The user drills through this chart and the chart is now rendered
> > > using different data which obviously produces a different looking chart.
> > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > version of the image so the report renders with the wrong chart.
> > >
> > > I considered a couple of options:
> > >
> > > 1) Adding something unique to the streamroot in addition to the
> > > not-so-unique streamid. Then, the client browser would consider the image
> > > url unique even if the streamid is not. I guess I would have to generate a
> > > guid to use in the stream root. Perhasps something like this:
> > >
> > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > "&imageid=</StreamRoot>"
> > >
> > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > the image elements -- I think this is possible, but wanted to avoid it.
> > >
> > > Thoughts anyone?
> > >
> > > "eglasius" wrote:
> > >
> > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > images in my site when I am using soap access ... here is the thread I posted
> > > > before:
> > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > >
> > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > as follows:
> > > > 1) I have an aspx page to render my reports
> > > > 2) I have a grid to display the parameters, which definition I grab
> > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > valid values (which are translated to dropdownlists:P), default values,
> > > > dependencies, etc ...
> > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > ...) and the parameters have been validated I get the report from Reporting
> > > > Services, indicating that the streamroot is a special page I will have to
> > > > display images, indicating in the query string the parameters values and
> > > > related stuff selected by the user ...
> > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > the user is accesing this page, it will make the call to the reporting
> > > > services, thus I wont be having the need to handle saving the images and then
> > > > deleting them.
> > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > which might in turn be an image that appears in the very same report several
> > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > page, so asp.net will handle saving it temporarily ...
> > > >
> > > > The Question:
> > > > Does that way of handling the image is good enough when talking about
> > > > performance? ...
> > > >
> > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > I would highly apreciate any comments on this ...|||> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
As long as the user doesn't open different reports at the same time (it
hardly should happen ...) and you don't have an incredibly large amount of
users, it is ok :)
I also wan't to know if it is a bug or a behavior by design (and why) ...
"David Swanson" wrote:
> FYI: I did add a guid and it works perfectly now. I still would like MS to
> explain to the newsgroup how streamids are created and why they would not be
> unique for a dynamic chart image. Seems like a bug to me.
> "David Swanson" wrote:
> > Thanks for your prompt reply!
> >
> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
> >
> > Unless someone from the MS team has a better idea, I think I will have to
> > include a guid. The other really odd thing is that the report has a pie
> > chart and a stacked bar chart. The pie chart always seems to use the same
> > stream id, but the stacked bar chart has always created a unique id --so far.
> >
> >
> > Can anyone from the MS Reporting Services team explain the behavior of how
> > the streamids are generated for the dynamic images produced by the chart
> > objects?
> >
> > Much appreciated, David
> >
> > "eglasius" wrote:
> >
> > > Well, my case was a very particular one, since I wasnt using dynamic images
> > > (it was a static logo) yet, but I did want the image to be grabbed from the
> > > report. The solution I used also needed to be compatible in case I were to
> > > use dynamic images.
> > >
> > > The thing is so far it has worked well, but we are using any dynamic image.
> > > Because of this, I have no clue if I would experience the very same problem
> > > that is happening to you.
> > >
> > > On the other hand, I do have to say that at the end I didn't have to turn
> > > asp.net cache on for the image served, since the browser seems to ask for the
> > > image only once regardless of configuration (what I was worried about was a
> > > browser with the "every visit to the page" configuration turned on asking for
> > > a 20 pages report and ending up getting the image 20 times, which at the end
> > > didn't happen).
> > >
> > > In your case I would check if the drilled down page is actually being asked
> > > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > > reasonable. If you have any other "unique" value (that relates to drilling
> > > down) you are already using at hand, you might as well use that one instead.
> > >
> > > One thing that really grabbed my attention, is that you aren't including
> > > which report or params in the stream root. Unless your report doesn't have
> > > parameters, all of them are fixed or your are saving them in some middle
> > > object, I don't seem to understand how your are doing it.
> > > I say so, because of this:
> > > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > > encoding, out mimeType);
> > > when getting the image one sends the report + streamId+parms.
> > >
> > > "David Swanson" wrote:
> > >
> > > > Eglasius,
> > > >
> > > > Did you have success with this? I have done nearly the exact same thing,
> > > > but have found a couple of problems with chart images.
> > > >
> > > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > > page so that as they drill through the report charts, they can easily go back
> > > > by using the browser's back button -- requiring no return to the server.
> > > >
> > > > However, I found that the streamIDs are NOT unique in some cases. For
> > > > example, I have a pie chart that with one set of data has a stream id of
> > > > C_21_S. The user drills through this chart and the chart is now rendered
> > > > using different data which obviously produces a different looking chart.
> > > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > > version of the image so the report renders with the wrong chart.
> > > >
> > > > I considered a couple of options:
> > > >
> > > > 1) Adding something unique to the streamroot in addition to the
> > > > not-so-unique streamid. Then, the client browser would consider the image
> > > > url unique even if the streamid is not. I guess I would have to generate a
> > > > guid to use in the stream root. Perhasps something like this:
> > > >
> > > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > > "&imageid=</StreamRoot>"
> > > >
> > > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > > the image elements -- I think this is possible, but wanted to avoid it.
> > > >
> > > > Thoughts anyone?
> > > >
> > > > "eglasius" wrote:
> > > >
> > > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > > images in my site when I am using soap access ... here is the thread I posted
> > > > > before:
> > > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > > >
> > > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > > as follows:
> > > > > 1) I have an aspx page to render my reports
> > > > > 2) I have a grid to display the parameters, which definition I grab
> > > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > > valid values (which are translated to dropdownlists:P), default values,
> > > > > dependencies, etc ...
> > > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > > ...) and the parameters have been validated I get the report from Reporting
> > > > > Services, indicating that the streamroot is a special page I will have to
> > > > > display images, indicating in the query string the parameters values and
> > > > > related stuff selected by the user ...
> > > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > > the user is accesing this page, it will make the call to the reporting
> > > > > services, thus I wont be having the need to handle saving the images and then
> > > > > deleting them.
> > > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > > which might in turn be an image that appears in the very same report several
> > > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > > page, so asp.net will handle saving it temporarily ...
> > > > >
> > > > > The Question:
> > > > > Does that way of handling the image is good enough when talking about
> > > > > performance? ...
> > > > >
> > > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > > I would highly apreciate any comments on this ...|||thanks you guys!.. I have been having a similar problem.
Recently we went live with reporting services. We are showing some charts,
and everything works fine the first time you show a chart. Subsequent charts
all show the image from the first chart. Hitting ctrl-R gets rid of the
problem, but this is undesirable (users would be confused). I took your idea
about slapping a GUID of some sort to the streamroot so that each request the
browser gets the image from the server.
Thanks again you guys!
Happy new years!
Images not displaying on reports!
We are trying to create a Report w/ images that are stored in the SQL Server table.
These images are being copied and pasted into an ACCESS application (w/, as said above, a SQL Server back-end)....
All I get on the report is a box with a red 'X'.
(Now, I have tried the routine to remove the OLE header as suggested on other places on the Internet. While this works for the Northwind images, this is not working on our images. Which leads me to guess that the OLE Header on our images may be different than 78. But how do we know or calculate that?)..
My guess would be that some other people have encountered similar problems.
Any help will be highly appreciated.
Thanks..
Were you able to find the solution for this?
I'm encountering the same problem.
Thanks!
sqlImages from SQL Server
I'm populating an Access continuous form with lots of icons from a SQL
Server backend. If I remove the field holding the icons from the
stored procedure, the form loads 5X faster. Is there any sort of trick
to improve the performance of this sort of scheme?
lqHi
Server backend. If I remove the field holding the icons from the
stored procedure, the form loads 5X faster. Is there any sort of trick
to improve the performance of this sort of scheme?
lqHi
The loading of the form is not just the returning of the dataset, but also
the conversion of the data into the icon. You may want to test the speed of
the queries through query analyser. You may also want to validate if the
size and datatype of the column to see if you can cut the size down, another
alternative is to load the icons from disk and only have references to them
in the database.
HTH
John
"Lauren Quantrell" <laurenquantrell@.hotmail.com> wrote in message
news:47e5bd72.0311080647.2655d2f3@.posting.google.c om...
> I'm populating an Access continuous form with lots of icons from a SQL
> Server backend. If I remove the field holding the icons from the
> stored procedure, the form loads 5X faster. Is there any sort of trick
> to improve the performance of this sort of scheme?
> lq
Monday, March 19, 2012
I'm not a SQL programmer but I need help please in sqlserver
Hello
Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we
need? We have approached several companies offering to build a bespoke system
for us based on SQL Server 2003 (as I understand, correct me if I'm wrong).
Another company that seems quite useful uses Visual Fox Pro. Now I've looked
at both these websites. I realise they are both Microsoft programmes. Would
someone tell me what the difference is between the two?
Our business is in the building services industry on the mechanical side;
that is we install heating systems, air conditioning, ventilation and
building controls and we operate around 25 operatives and have around 5
office staff and the business is getting very stretched. The only thing that
is semi automated are our accounts which are done on Sage Line 50 v10.
We do not have even a simple employee table, mobile phone table, etc. An
important area for our business is job costing, adding material costs +
labour costs, and this is something we would be very interested in.
The companies we have spoken to that offer bespoke services whether be by
SQL or Visual Fox Pro say that once a core module is built e.g. An employee
module, other modules could be bolted on at a later stage so that they would
interact.
I would very much appreciate someone who would just spend some time
clarifying some of the points I have made. If I haven't been specific enough,
I would be happy to give you further details.
Thank you in advance
Tim"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:173DEC0A-2ADE-4FA0-AC70-C7C4C4A100DE@.microsoft.com...
> Hello
> Yes, I certainly am not a programmer. Access gives me enough of a
> headache.
> What I'm after is some advice.
> Me and my brother run a small business and we have decided to have a
> database developed specifically for our business. The question is what do
> we
> need? We have approached several companies offering to build a bespoke
> system
> for us based on SQL Server 2003 (as I understand, correct me if I'm
> wrong).
> Another company that seems quite useful uses Visual Fox Pro. Now I've
> looked
> at both these websites. I realise they are both Microsoft programmes.
> Would
> someone tell me what the difference is between the two?
> Our business is in the building services industry on the mechanical side;
> that is we install heating systems, air conditioning, ventilation and
> building controls and we operate around 25 operatives and have around 5
> office staff and the business is getting very stretched. The only thing
> that
> is semi automated are our accounts which are done on Sage Line 50 v10.
> We do not have even a simple employee table, mobile phone table, etc. An
> important area for our business is job costing, adding material costs +
> labour costs, and this is something we would be very interested in.
> The companies we have spoken to that offer bespoke services whether be by
> SQL or Visual Fox Pro say that once a core module is built e.g. An
> employee
> module, other modules could be bolted on at a later stage so that they
> would
> interact.
> I would very much appreciate someone who would just spend some time
> clarifying some of the points I have made. If I haven't been specific
> enough,
> I would be happy to give you further details.
> Thank you in advance
>
> Tim
SQL Server is Microsoft's flagship database engine providing maximum
scalability, high availability and security in the database. FoxPro is not
just a database engine, it's a complete development environment. In
functional terms FoxPro is more like Access than SQL Server. In fact FoxPro
is often used to develop front end applications that run on top of SQL
Server.
Pure FoxPro apps are usually file-server based rather than using the
tiered architecture that SQL Server uses. That means that potentially a
FoxPro database may not be as secure as a SQL Server database because all
the data is exposed to all users over the network. On the availability side,
SQL Server will allow you to backup your data without taking the system
offline and it supports transaction log backups so as to minimise the risk
of data loss in the event of failure.
For a company of your size you probably don't need to worry too much about
the database platform. Bespoke software development (actually building an
application rather than just configuring one that you purchase) can be a big
investment so focus on the ability of the developer to deliver and support
the solution you need.
Ask to see evidence of their past work. Get references from previous
customers. Make sure you get written specifications from the developer
detailing the data, functionality, screens, reports, etc that you need. Get
a task-level project plan and make sure they update you on progress against
that plan at least once or twice a week. Be sure you understand what
commitment is required from your own staff (for data entry and user
acceptance testing for example).
Agree terms and costs for the long-term support of the software BEFORE the
developer starts work. Make sure the contract covers intellectual property
rights and who has access to the source code. You should either have
possession and licence to the source code or you should have some
entitlement to that code in the event that the developer ceases to trade or
can no longer support you.
Consider appointing your own project manager or someone with experience of
software development to oversee the work.
I don't mean this to sound too ominous. There are plenty of good developers
and systems integrators out there, but there are also a lot of failed
development projects and it takes experience to spot problems before they
happen. You can't always rely on the developers to be candid about the
issues and risks.
Do bear in mind that the areas you have mentioned: employee database, job
costing, BOM are already very well supported by off-the-shelf applications.
Chances are that some of those packages meet your needs so it is worth
considering purchasing something ready-to-wear rather than necessarily going
for the tailor-made solution.
--
David Portas
SQL Server MVP
--|||David Portas wrote:
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:173DEC0A-2ADE-4FA0-AC70-C7C4C4A100DE@.microsoft.com...
> > Hello
> >
> > Yes, I certainly am not a programmer. Access gives me enough of a
> > headache.
> > What I'm after is some advice.
> > Me and my brother run a small business and we have decided to have a
> > database developed specifically for our business. The question is what do
> > we
> > need? We have approached several companies offering to build a bespoke
> > system
> > for us based on SQL Server 2003 (as I understand, correct me if I'm
> > wrong).
> > Another company that seems quite useful uses Visual Fox Pro. Now I've
> > looked
> > at both these websites. I realise they are both Microsoft programmes.
> > Would
> > someone tell me what the difference is between the two?
> > Our business is in the building services industry on the mechanical side;
> > that is we install heating systems, air conditioning, ventilation and
> > building controls and we operate around 25 operatives and have around 5
> > office staff and the business is getting very stretched. The only thing
> > that
> > is semi automated are our accounts which are done on Sage Line 50 v10.
> > We do not have even a simple employee table, mobile phone table, etc. An
> > important area for our business is job costing, adding material costs +
> > labour costs, and this is something we would be very interested in.
> > The companies we have spoken to that offer bespoke services whether be by
> > SQL or Visual Fox Pro say that once a core module is built e.g. An
> > employee
> > module, other modules could be bolted on at a later stage so that they
> > would
> > interact.
> >
> > I would very much appreciate someone who would just spend some time
> > clarifying some of the points I have made. If I haven't been specific
> > enough,
> > I would be happy to give you further details.
> >
> > Thank you in advance
> >
> >
> > Tim
> SQL Server is Microsoft's flagship database engine providing maximum
> scalability, high availability and security in the database. FoxPro is not
> just a database engine, it's a complete development environment. In
> functional terms FoxPro is more like Access than SQL Server. In fact FoxPro
> is often used to develop front end applications that run on top of SQL
> Server.
> Pure FoxPro apps are usually file-server based rather than using the
> tiered architecture that SQL Server uses. That means that potentially a
> FoxPro database may not be as secure as a SQL Server database because all
> the data is exposed to all users over the network. On the availability side,
> SQL Server will allow you to backup your data without taking the system
> offline and it supports transaction log backups so as to minimise the risk
> of data loss in the event of failure.
> For a company of your size you probably don't need to worry too much about
> the database platform. Bespoke software development (actually building an
> application rather than just configuring one that you purchase) can be a big
> investment so focus on the ability of the developer to deliver and support
> the solution you need.
> Ask to see evidence of their past work. Get references from previous
> customers. Make sure you get written specifications from the developer
> detailing the data, functionality, screens, reports, etc that you need. Get
> a task-level project plan and make sure they update you on progress against
> that plan at least once or twice a week. Be sure you understand what
> commitment is required from your own staff (for data entry and user
> acceptance testing for example).
> Agree terms and costs for the long-term support of the software BEFORE the
> developer starts work. Make sure the contract covers intellectual property
> rights and who has access to the source code. You should either have
> possession and licence to the source code or you should have some
> entitlement to that code in the event that the developer ceases to trade or
> can no longer support you.
> Consider appointing your own project manager or someone with experience of
> software development to oversee the work.
> I don't mean this to sound too ominous. There are plenty of good developers
> and systems integrators out there, but there are also a lot of failed
> development projects and it takes experience to spot problems before they
> happen. You can't always rely on the developers to be candid about the
> issues and risks.
> Do bear in mind that the areas you have mentioned: employee database, job
> costing, BOM are already very well supported by off-the-shelf applications.
> Chances are that some of those packages meet your needs so it is worth
> considering purchasing something ready-to-wear rather than necessarily going
> for the tailor-made solution.
> --
> David Portas
> SQL Server MVP
> --
Chances are excellent that SOME of those off-the-shelf packages will
meet SOME of your needs. However chances are not so good that ANY of
those packages will meet ALL of your needs. If you are really intent
on something tailored to your exact requirements then check out our
website at www.responsive.co.nz.
We have a very successful track record developing high-quality
customized business applications, we offer a money-back guarantee and
we provide full source code for all our solutions i.e. we eliminate the
risk of developing customized software for our business customers.
Matthew Jenkinson
www.responsive.co.nz
Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we
need? We have approached several companies offering to build a bespoke system
for us based on SQL Server 2003 (as I understand, correct me if I'm wrong).
Another company that seems quite useful uses Visual Fox Pro. Now I've looked
at both these websites. I realise they are both Microsoft programmes. Would
someone tell me what the difference is between the two?
Our business is in the building services industry on the mechanical side;
that is we install heating systems, air conditioning, ventilation and
building controls and we operate around 25 operatives and have around 5
office staff and the business is getting very stretched. The only thing that
is semi automated are our accounts which are done on Sage Line 50 v10.
We do not have even a simple employee table, mobile phone table, etc. An
important area for our business is job costing, adding material costs +
labour costs, and this is something we would be very interested in.
The companies we have spoken to that offer bespoke services whether be by
SQL or Visual Fox Pro say that once a core module is built e.g. An employee
module, other modules could be bolted on at a later stage so that they would
interact.
I would very much appreciate someone who would just spend some time
clarifying some of the points I have made. If I haven't been specific enough,
I would be happy to give you further details.
Thank you in advance
Tim"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:173DEC0A-2ADE-4FA0-AC70-C7C4C4A100DE@.microsoft.com...
> Hello
> Yes, I certainly am not a programmer. Access gives me enough of a
> headache.
> What I'm after is some advice.
> Me and my brother run a small business and we have decided to have a
> database developed specifically for our business. The question is what do
> we
> need? We have approached several companies offering to build a bespoke
> system
> for us based on SQL Server 2003 (as I understand, correct me if I'm
> wrong).
> Another company that seems quite useful uses Visual Fox Pro. Now I've
> looked
> at both these websites. I realise they are both Microsoft programmes.
> Would
> someone tell me what the difference is between the two?
> Our business is in the building services industry on the mechanical side;
> that is we install heating systems, air conditioning, ventilation and
> building controls and we operate around 25 operatives and have around 5
> office staff and the business is getting very stretched. The only thing
> that
> is semi automated are our accounts which are done on Sage Line 50 v10.
> We do not have even a simple employee table, mobile phone table, etc. An
> important area for our business is job costing, adding material costs +
> labour costs, and this is something we would be very interested in.
> The companies we have spoken to that offer bespoke services whether be by
> SQL or Visual Fox Pro say that once a core module is built e.g. An
> employee
> module, other modules could be bolted on at a later stage so that they
> would
> interact.
> I would very much appreciate someone who would just spend some time
> clarifying some of the points I have made. If I haven't been specific
> enough,
> I would be happy to give you further details.
> Thank you in advance
>
> Tim
SQL Server is Microsoft's flagship database engine providing maximum
scalability, high availability and security in the database. FoxPro is not
just a database engine, it's a complete development environment. In
functional terms FoxPro is more like Access than SQL Server. In fact FoxPro
is often used to develop front end applications that run on top of SQL
Server.
Pure FoxPro apps are usually file-server based rather than using the
tiered architecture that SQL Server uses. That means that potentially a
FoxPro database may not be as secure as a SQL Server database because all
the data is exposed to all users over the network. On the availability side,
SQL Server will allow you to backup your data without taking the system
offline and it supports transaction log backups so as to minimise the risk
of data loss in the event of failure.
For a company of your size you probably don't need to worry too much about
the database platform. Bespoke software development (actually building an
application rather than just configuring one that you purchase) can be a big
investment so focus on the ability of the developer to deliver and support
the solution you need.
Ask to see evidence of their past work. Get references from previous
customers. Make sure you get written specifications from the developer
detailing the data, functionality, screens, reports, etc that you need. Get
a task-level project plan and make sure they update you on progress against
that plan at least once or twice a week. Be sure you understand what
commitment is required from your own staff (for data entry and user
acceptance testing for example).
Agree terms and costs for the long-term support of the software BEFORE the
developer starts work. Make sure the contract covers intellectual property
rights and who has access to the source code. You should either have
possession and licence to the source code or you should have some
entitlement to that code in the event that the developer ceases to trade or
can no longer support you.
Consider appointing your own project manager or someone with experience of
software development to oversee the work.
I don't mean this to sound too ominous. There are plenty of good developers
and systems integrators out there, but there are also a lot of failed
development projects and it takes experience to spot problems before they
happen. You can't always rely on the developers to be candid about the
issues and risks.
Do bear in mind that the areas you have mentioned: employee database, job
costing, BOM are already very well supported by off-the-shelf applications.
Chances are that some of those packages meet your needs so it is worth
considering purchasing something ready-to-wear rather than necessarily going
for the tailor-made solution.
--
David Portas
SQL Server MVP
--|||David Portas wrote:
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:173DEC0A-2ADE-4FA0-AC70-C7C4C4A100DE@.microsoft.com...
> > Hello
> >
> > Yes, I certainly am not a programmer. Access gives me enough of a
> > headache.
> > What I'm after is some advice.
> > Me and my brother run a small business and we have decided to have a
> > database developed specifically for our business. The question is what do
> > we
> > need? We have approached several companies offering to build a bespoke
> > system
> > for us based on SQL Server 2003 (as I understand, correct me if I'm
> > wrong).
> > Another company that seems quite useful uses Visual Fox Pro. Now I've
> > looked
> > at both these websites. I realise they are both Microsoft programmes.
> > Would
> > someone tell me what the difference is between the two?
> > Our business is in the building services industry on the mechanical side;
> > that is we install heating systems, air conditioning, ventilation and
> > building controls and we operate around 25 operatives and have around 5
> > office staff and the business is getting very stretched. The only thing
> > that
> > is semi automated are our accounts which are done on Sage Line 50 v10.
> > We do not have even a simple employee table, mobile phone table, etc. An
> > important area for our business is job costing, adding material costs +
> > labour costs, and this is something we would be very interested in.
> > The companies we have spoken to that offer bespoke services whether be by
> > SQL or Visual Fox Pro say that once a core module is built e.g. An
> > employee
> > module, other modules could be bolted on at a later stage so that they
> > would
> > interact.
> >
> > I would very much appreciate someone who would just spend some time
> > clarifying some of the points I have made. If I haven't been specific
> > enough,
> > I would be happy to give you further details.
> >
> > Thank you in advance
> >
> >
> > Tim
> SQL Server is Microsoft's flagship database engine providing maximum
> scalability, high availability and security in the database. FoxPro is not
> just a database engine, it's a complete development environment. In
> functional terms FoxPro is more like Access than SQL Server. In fact FoxPro
> is often used to develop front end applications that run on top of SQL
> Server.
> Pure FoxPro apps are usually file-server based rather than using the
> tiered architecture that SQL Server uses. That means that potentially a
> FoxPro database may not be as secure as a SQL Server database because all
> the data is exposed to all users over the network. On the availability side,
> SQL Server will allow you to backup your data without taking the system
> offline and it supports transaction log backups so as to minimise the risk
> of data loss in the event of failure.
> For a company of your size you probably don't need to worry too much about
> the database platform. Bespoke software development (actually building an
> application rather than just configuring one that you purchase) can be a big
> investment so focus on the ability of the developer to deliver and support
> the solution you need.
> Ask to see evidence of their past work. Get references from previous
> customers. Make sure you get written specifications from the developer
> detailing the data, functionality, screens, reports, etc that you need. Get
> a task-level project plan and make sure they update you on progress against
> that plan at least once or twice a week. Be sure you understand what
> commitment is required from your own staff (for data entry and user
> acceptance testing for example).
> Agree terms and costs for the long-term support of the software BEFORE the
> developer starts work. Make sure the contract covers intellectual property
> rights and who has access to the source code. You should either have
> possession and licence to the source code or you should have some
> entitlement to that code in the event that the developer ceases to trade or
> can no longer support you.
> Consider appointing your own project manager or someone with experience of
> software development to oversee the work.
> I don't mean this to sound too ominous. There are plenty of good developers
> and systems integrators out there, but there are also a lot of failed
> development projects and it takes experience to spot problems before they
> happen. You can't always rely on the developers to be candid about the
> issues and risks.
> Do bear in mind that the areas you have mentioned: employee database, job
> costing, BOM are already very well supported by off-the-shelf applications.
> Chances are that some of those packages meet your needs so it is worth
> considering purchasing something ready-to-wear rather than necessarily going
> for the tailor-made solution.
> --
> David Portas
> SQL Server MVP
> --
Chances are excellent that SOME of those off-the-shelf packages will
meet SOME of your needs. However chances are not so good that ANY of
those packages will meet ALL of your needs. If you are really intent
on something tailored to your exact requirements then check out our
website at www.responsive.co.nz.
We have a very successful track record developing high-quality
customized business applications, we offer a money-back guarantee and
we provide full source code for all our solutions i.e. we eliminate the
risk of developing customized software for our business customers.
Matthew Jenkinson
www.responsive.co.nz
I'm not a SQL programmer but I need help please
Hello
Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we
need? We have approached several companies offering to build a bespoke system
for us based on SQL Server 2003 (as I understand, correct me if I'm wrong).
Another company that seems quite useful uses Visual Fox Pro. Now I've looked
at both these websites. I realise they are both Microsoft programmes. Would
someone tell me what the difference is between the two?
Our business is in the building services industry on the mechanical side;
that is we install heating systems, air conditioning, ventilation and
building controls and we operate around 25 operatives and have around 5
office staff and the business is getting very stretched. The only thing that
is semi automated are our accounts which are done on Sage Line 50 v10.
We do not have even a simple employee table, mobile phone table, etc. An
important area for our business is job costing, adding material costs +
labour costs, and this is something we would be very interested in.
The companies we have spoken to that offer bespoke services whether be by
SQL or Visual Fox Pro say that once a core module is built e.g. An employee
module, other modules could be bolted on at a later stage so that they would
interact.
I would very much appreciate someone who would just spend some time
clarifying some of the points I have made. If I haven't been specific enough,
I would be happy to give you further details.
Thank you in advance
Tim
On Fri, 2 Dec 2005 10:48:02 -0800, Tim wrote:
>Hello
>Yes, I certainly am not a programmer. Access gives me enough of a headache.
>What I'm after is some advice.
(snip)
Hi Tim,
May I suggest that you repost this in microsoft.public.sqlserver.server?
This group (.mseq) is about "English Query" - an add-on to SQL Server
that is used very little. As a result, this group attracts little
traffic and it's only being monitored by a few people.
The group I suggested (.server) is much more active, and is regularly
visited by many experienced SQL Server users. I think that your question
will attract several useful replies by some very knowledgeable people if
you repost in the .server group.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||If not already done so I would look at some off the shelf products as
Bespoke usually means big "'s" (talking from experience)
Many of the companies do job costing modules - as you already use Sage Line
50 - Sage would be my first port of call - Sage MMS or Sage Construct
(specific for the construction industry - CIS etc) but there are others out
there . . . .
Sorry if I am teaching granny to suck eggs - you may have already looked at
off the shelf packages
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:565A8573-FEFD-4AA5-B670-317A3EA752C2@.microsoft.com...
> Hello
> Yes, I certainly am not a programmer. Access gives me enough of a
> headache.
> What I'm after is some advice.
> Me and my brother run a small business and we have decided to have a
> database developed specifically for our business. The question is what do
> we
> need? We have approached several companies offering to build a bespoke
> system
> for us based on SQL Server 2003 (as I understand, correct me if I'm
> wrong).
> Another company that seems quite useful uses Visual Fox Pro. Now I've
> looked
> at both these websites. I realise they are both Microsoft programmes.
> Would
> someone tell me what the difference is between the two?
> Our business is in the building services industry on the mechanical side;
> that is we install heating systems, air conditioning, ventilation and
> building controls and we operate around 25 operatives and have around 5
> office staff and the business is getting very stretched. The only thing
> that
> is semi automated are our accounts which are done on Sage Line 50 v10.
> We do not have even a simple employee table, mobile phone table, etc. An
> important area for our business is job costing, adding material costs +
> labour costs, and this is something we would be very interested in.
> The companies we have spoken to that offer bespoke services whether be by
> SQL or Visual Fox Pro say that once a core module is built e.g. An
> employee
> module, other modules could be bolted on at a later stage so that they
> would
> interact.
> I would very much appreciate someone who would just spend some time
> clarifying some of the points I have made. If I haven't been specific
> enough,
> I would be happy to give you further details.
> Thank you in advance
>
> Tim
Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we
need? We have approached several companies offering to build a bespoke system
for us based on SQL Server 2003 (as I understand, correct me if I'm wrong).
Another company that seems quite useful uses Visual Fox Pro. Now I've looked
at both these websites. I realise they are both Microsoft programmes. Would
someone tell me what the difference is between the two?
Our business is in the building services industry on the mechanical side;
that is we install heating systems, air conditioning, ventilation and
building controls and we operate around 25 operatives and have around 5
office staff and the business is getting very stretched. The only thing that
is semi automated are our accounts which are done on Sage Line 50 v10.
We do not have even a simple employee table, mobile phone table, etc. An
important area for our business is job costing, adding material costs +
labour costs, and this is something we would be very interested in.
The companies we have spoken to that offer bespoke services whether be by
SQL or Visual Fox Pro say that once a core module is built e.g. An employee
module, other modules could be bolted on at a later stage so that they would
interact.
I would very much appreciate someone who would just spend some time
clarifying some of the points I have made. If I haven't been specific enough,
I would be happy to give you further details.
Thank you in advance
Tim
On Fri, 2 Dec 2005 10:48:02 -0800, Tim wrote:
>Hello
>Yes, I certainly am not a programmer. Access gives me enough of a headache.
>What I'm after is some advice.
(snip)
Hi Tim,
May I suggest that you repost this in microsoft.public.sqlserver.server?
This group (.mseq) is about "English Query" - an add-on to SQL Server
that is used very little. As a result, this group attracts little
traffic and it's only being monitored by a few people.
The group I suggested (.server) is much more active, and is regularly
visited by many experienced SQL Server users. I think that your question
will attract several useful replies by some very knowledgeable people if
you repost in the .server group.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||If not already done so I would look at some off the shelf products as
Bespoke usually means big "'s" (talking from experience)
Many of the companies do job costing modules - as you already use Sage Line
50 - Sage would be my first port of call - Sage MMS or Sage Construct
(specific for the construction industry - CIS etc) but there are others out
there . . . .
Sorry if I am teaching granny to suck eggs - you may have already looked at
off the shelf packages
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:565A8573-FEFD-4AA5-B670-317A3EA752C2@.microsoft.com...
> Hello
> Yes, I certainly am not a programmer. Access gives me enough of a
> headache.
> What I'm after is some advice.
> Me and my brother run a small business and we have decided to have a
> database developed specifically for our business. The question is what do
> we
> need? We have approached several companies offering to build a bespoke
> system
> for us based on SQL Server 2003 (as I understand, correct me if I'm
> wrong).
> Another company that seems quite useful uses Visual Fox Pro. Now I've
> looked
> at both these websites. I realise they are both Microsoft programmes.
> Would
> someone tell me what the difference is between the two?
> Our business is in the building services industry on the mechanical side;
> that is we install heating systems, air conditioning, ventilation and
> building controls and we operate around 25 operatives and have around 5
> office staff and the business is getting very stretched. The only thing
> that
> is semi automated are our accounts which are done on Sage Line 50 v10.
> We do not have even a simple employee table, mobile phone table, etc. An
> important area for our business is job costing, adding material costs +
> labour costs, and this is something we would be very interested in.
> The companies we have spoken to that offer bespoke services whether be by
> SQL or Visual Fox Pro say that once a core module is built e.g. An
> employee
> module, other modules could be bolted on at a later stage so that they
> would
> interact.
> I would very much appreciate someone who would just spend some time
> clarifying some of the points I have made. If I haven't been specific
> enough,
> I would be happy to give you further details.
> Thank you in advance
>
> Tim
Monday, March 12, 2012
I'm New & Need Help. Install + Use SQLExpress with Access
I'm totally new to using RDBM's, and have never installed or used SQl. Can someone please tell me how to install SQL Express, do whatever I need to to at the command prompt, etc., and then what I need to do in order to create a database in Access which uses SQL Express as the backend?
I'm using Windows XP
I have .Net framework 2.0 installed and the .Net SDK
Can someone please help a noob out? :)
Thanks.,
James
What do you mean by "then what I need to do in order to create a database in Access which uses SQL Express as the backend?" I do not think that is possible. What are you trying to do?
You can find Express Edition on the Web Site at the following location
http://www.microsoft.com/downloads/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en
Running the install will step you through the installation process.
michelle
I'll be away...
I will be out of the country (and without cell phone, pager, and computer
access) until February 3rd, but that day is Super Bowl Sunday, so make it
February 4th.
I apologize in advance if I abandon any ongoing threads, or if you expect an
answer from me and don't get one. I will have access for another day or so.
I doubt I'll be missed all that much, but I just wanted to have a disclaimer
here just in case.So long as you are at the bar in April :)
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eCDSNaGXIHA.4712@.TK2MSFTNGP04.phx.gbl...
>I will be out of the country (and without cell phone, pager, and computer
>access) until February 3rd, but that day is Super Bowl Sunday, so make it
>February 4th.
> I apologize in advance if I abandon any ongoing threads, or if you expect
> an answer from me and don't get one. I will have access for another day
> or so.
> I doubt I'll be missed all that much, but I just wanted to have a
> disclaimer here just in case.
>|||> So long as you are at the bar in April :)
Wouldn't miss it!|||Where are you at Aaron ?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23X5tKMHXIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> So long as you are at the bar in April :)
> Wouldn't miss it!
>|||> Where are you at Aaron ?
I work out of Boston, MA.
A|||Cool.. Thanks..
I guess nows my chance to annoy everyone else until you get back. Kidding..
I need to get into trying stuff myself or googling for answers before
posting.
Hope to improve over time.
Thanks for all your help.
Enjoy your time off.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
> A
>|||On Jan 21, 3:14 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> > So long as you are at the bar in April :)
> Wouldn't miss it!
likewise|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
>
Bastan? Hop in da cah, head down to da bah, hang a left at da rotary...
access) until February 3rd, but that day is Super Bowl Sunday, so make it
February 4th.
I apologize in advance if I abandon any ongoing threads, or if you expect an
answer from me and don't get one. I will have access for another day or so.
I doubt I'll be missed all that much, but I just wanted to have a disclaimer
here just in case.So long as you are at the bar in April :)
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eCDSNaGXIHA.4712@.TK2MSFTNGP04.phx.gbl...
>I will be out of the country (and without cell phone, pager, and computer
>access) until February 3rd, but that day is Super Bowl Sunday, so make it
>February 4th.
> I apologize in advance if I abandon any ongoing threads, or if you expect
> an answer from me and don't get one. I will have access for another day
> or so.
> I doubt I'll be missed all that much, but I just wanted to have a
> disclaimer here just in case.
>|||> So long as you are at the bar in April :)
Wouldn't miss it!|||Where are you at Aaron ?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23X5tKMHXIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> So long as you are at the bar in April :)
> Wouldn't miss it!
>|||> Where are you at Aaron ?
I work out of Boston, MA.
A|||Cool.. Thanks..
I guess nows my chance to annoy everyone else until you get back. Kidding..
I need to get into trying stuff myself or googling for answers before
posting.
Hope to improve over time.
Thanks for all your help.
Enjoy your time off.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
> A
>|||On Jan 21, 3:14 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> > So long as you are at the bar in April :)
> Wouldn't miss it!
likewise|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
>
Bastan? Hop in da cah, head down to da bah, hang a left at da rotary...
IList as DataSource (NHibernate usage)
Hi Friends,
It is possible to use IList as Data Source in the Reporting Services? I am
using NHibernate for access the data.
Thanks,
Pedro.You would need to write a custom DataExtension that can consume your
DAL.
It is possible to use IList as Data Source in the Reporting Services? I am
using NHibernate for access the data.
Thanks,
Pedro.You would need to write a custom DataExtension that can consume your
DAL.
Friday, March 9, 2012
IIS issue
I just installed IIS on my windows xp pro machine and when I try to access a
website on the local IIS server, I get the following error message:
website on the local IIS server, I get the following error message:
"You are not authorized to view this page"
I have enabled "Anonymous access" inside Directory Security option of IIS
and I also granted full NTFS permissions to all users so that the IIS root
directory is readily accessible. However, I am still not able to access any
website that resides on the localhost.
Please help.
Thanks.
JessIs this a SQL Server question?
Wednesday, March 7, 2012
IIS and SQL 2005
I need to have my web server IIS 6 access our database SQL2005. Our web
server holds other web sites so I would like to leave it in the DMZ and the
SQL in the lan. From what I have heard this is not the best method. Has
anyone done this. Is there a better way.
ThanksHello royst,
> I need to have my web server IIS 6 access our database SQL2005. Our
> web server holds other web sites so I would like to leave it in the
> DMZ and the SQL in the lan. From what I have heard this is not the
> best method. Has anyone done this. Is there a better way.
Sometimes is design is about the only secure method making it work. The prob
lem
with it is that its lower perf that having the SQL Server in DMZ because
of need to connect back through a firewall. You may also have to use standar
d
logins, but as long as you're taking reasonable steps to secure your DMZ
to LAN connection, that's probably an acceptable risk.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Thanks Kent
The performance is not an issue. Security on the other hand is. I have
reservations on opening up SQL ports on my firewall. Just tring to find a
more secure way to do this with IIS in the DMZ and SQL in the local Lan.
"Kent Tegels" wrote:
> Hello royst,
>
> Sometimes is design is about the only secure method making it work. The pr
oblem
> with it is that its lower perf that having the SQL Server in DMZ because
> of need to connect back through a firewall. You may also have to use stand
ard
> logins, but as long as you're taking reasonable steps to secure your DMZ
> to LAN connection, that's probably an acceptable risk.
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
>|||Hello royst,
If you have a decent firewall, you should be able to restrict by address
who can initiate a connection on port 1433. You could also require TLS or
SSL encryption on the connection for good measure with with performance impl
ications.
The alternative would be do some form of replication, but that leaves you
with a port (or set of them) open at some point.
Good luck,
kt
server holds other web sites so I would like to leave it in the DMZ and the
SQL in the lan. From what I have heard this is not the best method. Has
anyone done this. Is there a better way.
ThanksHello royst,
> I need to have my web server IIS 6 access our database SQL2005. Our
> web server holds other web sites so I would like to leave it in the
> DMZ and the SQL in the lan. From what I have heard this is not the
> best method. Has anyone done this. Is there a better way.
Sometimes is design is about the only secure method making it work. The prob
lem
with it is that its lower perf that having the SQL Server in DMZ because
of need to connect back through a firewall. You may also have to use standar
d
logins, but as long as you're taking reasonable steps to secure your DMZ
to LAN connection, that's probably an acceptable risk.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Thanks Kent
The performance is not an issue. Security on the other hand is. I have
reservations on opening up SQL ports on my firewall. Just tring to find a
more secure way to do this with IIS in the DMZ and SQL in the local Lan.
"Kent Tegels" wrote:
> Hello royst,
>
> Sometimes is design is about the only secure method making it work. The pr
oblem
> with it is that its lower perf that having the SQL Server in DMZ because
> of need to connect back through a firewall. You may also have to use stand
ard
> logins, but as long as you're taking reasonable steps to secure your DMZ
> to LAN connection, that's probably an acceptable risk.
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
>|||Hello royst,
If you have a decent firewall, you should be able to restrict by address
who can initiate a connection on port 1433. You could also require TLS or
SSL encryption on the connection for good measure with with performance impl
ications.
The alternative would be do some form of replication, but that leaves you
with a port (or set of them) open at some point.
Good luck,
kt
IIS and Internet Access
Hi All,
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I get
nothing back. I can access my web projects but cant access and display
reports from web. I am using a static ip address to access the website for
now. I don't have a domain name setup for this box yet if that makes a
difference. and internally when I refer to the box in the website I use the
boxs computer name. Any ideas on what could be wrong here?
Thanks,
JJThis topic might help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JJ" <JJ@.discussions.microsoft.com> wrote in message
news:9B7DEDB4-0940-4FED-B6C9-0F05CCDBEF43@.microsoft.com...
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use
> the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi,
Did you arrange security settings for the browsing reports?
You should grant "Browser" Role to Guests or everyone from the Report
Manager to the folder where your reports are.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi eralper,
Man I am so feed up trying to get Reporting Services to be accessed from
the web. I have windows 2003 server running Sql Server 2000 with Reporting
Services sp2 installed. I can see and execute the reports through Report
Manager with no problem internally. But when I have a buddy check out the
website using an IP address. He gets nothing. I have setup roles for
IUSR_Account as browser role and assigned the report trying to access to the
security property under report. In the datasource for report I have included
the user name and password that matchs a windows account mapped to a Sql
server user account. No problem there. How do you have IIS setup under
Directory securities for Report and Report Manager set?
I don't have a domain name setup for this server yet. I am using Static IP
address for the moment. Are you using SSL for Reporting Services? What else
should I check?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Did you arrange security settings for the browsing reports?
> You should grant "Browser" Role to Guests or everyone from the Report
> Manager to the folder where your reports are.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi All,
> >
> > I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web I get
> > nothing back. I can access my web projects but cant access and display
> > reports from web. I am using a static ip address to access the website for
> > now. I don't have a domain name setup for this box yet if that makes a
> > difference. and internally when I refer to the box in the website I use the
> > boxs computer name. Any ideas on what could be wrong here?
> >
> > Thanks,
> >
> > JJ|||Hi JJ,
I tried to give a detailed answer on
http://www.kodyaz.com/ShowPost.aspx?PostID=19
I hope it helps.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi eralper,
> Man I am so feed up trying to get Reporting Services to be accessed from
> the web. I have windows 2003 server running Sql Server 2000 with Reporting
> Services sp2 installed. I can see and execute the reports through Report
> Manager with no problem internally. But when I have a buddy check out the
> website using an IP address. He gets nothing. I have setup roles for
> IUSR_Account as browser role and assigned the report trying to access to the
> security property under report. In the datasource for report I have included
> the user name and password that matchs a windows account mapped to a Sql
> server user account. No problem there. How do you have IIS setup under
> Directory securities for Report and Report Manager set?
> I don't have a domain name setup for this server yet. I am using Static IP
> address for the moment. Are you using SSL for Reporting Services? What else
> should I check?
> Thanks,
> JJ
>
> "eralper" wrote:
> >
> > Hi,
> >
> > Did you arrange security settings for the browsing reports?
> >
> > You should grant "Browser" Role to Guests or everyone from the Report
> > Manager to the folder where your reports are.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi All,
> > >
> > > I have the following going on: A win 2k3 server running sql server and
> > > reporting services. I have IIS configured on it and can run reports
> > > internally on my network but when I try to access a report from the web I get
> > > nothing back. I can access my web projects but cant access and display
> > > reports from web. I am using a static ip address to access the website for
> > > now. I don't have a domain name setup for this box yet if that makes a
> > > difference. and internally when I refer to the box in the website I use the
> > > boxs computer name. Any ideas on what could be wrong here?
> > >
> > > Thanks,
> > >
> > > JJ|||Hi Eralper,
I tried to access your website but I keep on getting Obj ref not set
error. This is happening even when I enter www. kodyak.com.
Thanks,
JJ
"eralper" wrote:
> Hi JJ,
> I tried to give a detailed answer on
> http://www.kodyaz.com/ShowPost.aspx?PostID=19
> I hope it helps.
> Eralper
> http://www.kodyaz.com
>
> "JJ" wrote:
> > Hi eralper,
> >
> > Man I am so feed up trying to get Reporting Services to be accessed from
> > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > Services sp2 installed. I can see and execute the reports through Report
> > Manager with no problem internally. But when I have a buddy check out the
> > website using an IP address. He gets nothing. I have setup roles for
> > IUSR_Account as browser role and assigned the report trying to access to the
> > security property under report. In the datasource for report I have included
> > the user name and password that matchs a windows account mapped to a Sql
> > server user account. No problem there. How do you have IIS setup under
> > Directory securities for Report and Report Manager set?
> >
> > I don't have a domain name setup for this server yet. I am using Static IP
> > address for the moment. Are you using SSL for Reporting Services? What else
> > should I check?
> >
> > Thanks,
> >
> > JJ
> >
> >
> > "eralper" wrote:
> >
> > >
> > > Hi,
> > >
> > > Did you arrange security settings for the browsing reports?
> > >
> > > You should grant "Browser" Role to Guests or everyone from the Report
> > > Manager to the folder where your reports are.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > > "JJ" wrote:
> > >
> > > > Hi All,
> > > >
> > > > I have the following going on: A win 2k3 server running sql server and
> > > > reporting services. I have IIS configured on it and can run reports
> > > > internally on my network but when I try to access a report from the web I get
> > > > nothing back. I can access my web projects but cant access and display
> > > > reports from web. I am using a static ip address to access the website for
> > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > difference. and internally when I refer to the box in the website I use the
> > > > boxs computer name. Any ideas on what could be wrong here?
> > > >
> > > > Thanks,
> > > >
> > > > JJ|||Hi,
Actually my configuration differs from yours with my web server is IIS5
working on Win2k. But I believe this will not cause a problem for anonymous
access to reports after the steps I'll try to summarize below.
Considering the site security, I'm not sure this is the best practice for
reporting services application but it seems working.
First you can view and run reports without problem because default
authentication method for virtual directories "Reports" and "ReportServer" is
window authentication. And I think you browse the reports with an admin group
user.
With these default configurations of the setup of Reporting Services, your
buddy should be able to get the username and password screen for windows
authentication when he calls http://YourIPComesHere/Reports
If you change IIS permissions for these two virtual directories (Reports &
ReportServer), your buddy should see an empty page because the internet guest
account has no browser role permission on none of the folders below home
(pointing VS.Net Reporting Services projects) or the individual reports in
those folders.
So before switching to anonymous access on these virtual directories, you
should grant Browser role permission to "everyone" in approtiate folders and
reports.
I used "everyone", I do not know if it makes sense for IUSR_ComputerName
So first go to Home directory (http://YourServer/Reports). Select Properties
tab for Home and hit the "New Role Assignment" button to add "everyone" as
Browser. By doing this, anonymous users will be able to list contents of the
Reports folder.
Second, select "Detailed View" and "Edit" the report folder where your
reports are deployed. Go to Security tab and add "everyone" as Browser.
I'm not sure but you may need to repeat a similar step (adding everyone as
Browser) for the reports.
You should hide the datasources in the list by editing their properties.
Check the "hide in list view" option in General tab.
One important note: you must edit RSWebApplication config file in
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager" folder (default place for this configuration file)
Update ReportServerURL by changing the computer name with your IP. Otherwise
users will be able reach the report but will not be able to see it processing.
Now is time for changing the permissions of the two virtual directories
Reports and ReportServer via IIS Manager. Go to properties of the virtual
directories then select directory security tab. And allow anonymous access.
This configuration works for me. I hope you may find something useful within
my notes.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi Eralper,
> I tried to access your website but I keep on getting Obj ref not set
> error. This is happening even when I enter www. kodyak.com.
> Thanks,
> JJ
> "eralper" wrote:
> > Hi JJ,
> >
> > I tried to give a detailed answer on
> > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> >
> > I hope it helps.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> > "JJ" wrote:
> >
> > > Hi eralper,
> > >
> > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > Services sp2 installed. I can see and execute the reports through Report
> > > Manager with no problem internally. But when I have a buddy check out the
> > > website using an IP address. He gets nothing. I have setup roles for
> > > IUSR_Account as browser role and assigned the report trying to access to the
> > > security property under report. In the datasource for report I have included
> > > the user name and password that matchs a windows account mapped to a Sql
> > > server user account. No problem there. How do you have IIS setup under
> > > Directory securities for Report and Report Manager set?
> > >
> > > I don't have a domain name setup for this server yet. I am using Static IP
> > > address for the moment. Are you using SSL for Reporting Services? What else
> > > should I check?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> > > "eralper" wrote:
> > >
> > > >
> > > > Hi,
> > > >
> > > > Did you arrange security settings for the browsing reports?
> > > >
> > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > Manager to the folder where your reports are.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > reporting services. I have IIS configured on it and can run reports
> > > > > internally on my network but when I try to access a report from the web I get
> > > > > nothing back. I can access my web projects but cant access and display
> > > > > reports from web. I am using a static ip address to access the website for
> > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > difference. and internally when I refer to the box in the website I use the
> > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ|||When you mean grant access to everyone do you mean use IUSR_Compname account
and assign to folders.
By the way I really like your website! Any ideas on what's causing the
error? Would like to access it again. Did you build it yourself?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Actually my configuration differs from yours with my web server is IIS5
> working on Win2k. But I believe this will not cause a problem for anonymous
> access to reports after the steps I'll try to summarize below.
> Considering the site security, I'm not sure this is the best practice for
> reporting services application but it seems working.
> First you can view and run reports without problem because default
> authentication method for virtual directories "Reports" and "ReportServer" is
> window authentication. And I think you browse the reports with an admin group
> user.
> With these default configurations of the setup of Reporting Services, your
> buddy should be able to get the username and password screen for windows
> authentication when he calls http://YourIPComesHere/Reports
> If you change IIS permissions for these two virtual directories (Reports &
> ReportServer), your buddy should see an empty page because the internet guest
> account has no browser role permission on none of the folders below home
> (pointing VS.Net Reporting Services projects) or the individual reports in
> those folders.
> So before switching to anonymous access on these virtual directories, you
> should grant Browser role permission to "everyone" in approtiate folders and
> reports.
> I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> So first go to Home directory (http://YourServer/Reports). Select Properties
> tab for Home and hit the "New Role Assignment" button to add "everyone" as
> Browser. By doing this, anonymous users will be able to list contents of the
> Reports folder.
> Second, select "Detailed View" and "Edit" the report folder where your
> reports are deployed. Go to Security tab and add "everyone" as Browser.
> I'm not sure but you may need to repeat a similar step (adding everyone as
> Browser) for the reports.
> You should hide the datasources in the list by editing their properties.
> Check the "hide in list view" option in General tab.
> One important note: you must edit RSWebApplication config file in
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager" folder (default place for this configuration file)
> Update ReportServerURL by changing the computer name with your IP. Otherwise
> users will be able reach the report but will not be able to see it processing.
> Now is time for changing the permissions of the two virtual directories
> Reports and ReportServer via IIS Manager. Go to properties of the virtual
> directories then select directory security tab. And allow anonymous access.
>
> This configuration works for me. I hope you may find something useful within
> my notes.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi Eralper,
> >
> > I tried to access your website but I keep on getting Obj ref not set
> > error. This is happening even when I enter www. kodyak.com.
> >
> > Thanks,
> >
> > JJ
> >
> > "eralper" wrote:
> >
> > > Hi JJ,
> > >
> > > I tried to give a detailed answer on
> > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > >
> > > I hope it helps.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > > "JJ" wrote:
> > >
> > > > Hi eralper,
> > > >
> > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > Services sp2 installed. I can see and execute the reports through Report
> > > > Manager with no problem internally. But when I have a buddy check out the
> > > > website using an IP address. He gets nothing. I have setup roles for
> > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > security property under report. In the datasource for report I have included
> > > > the user name and password that matchs a windows account mapped to a Sql
> > > > server user account. No problem there. How do you have IIS setup under
> > > > Directory securities for Report and Report Manager set?
> > > >
> > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > should I check?
> > > >
> > > > Thanks,
> > > >
> > > > JJ
> > > >
> > > >
> > > > "eralper" wrote:
> > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > Did you arrange security settings for the browsing reports?
> > > > >
> > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > Manager to the folder where your reports are.
> > > > >
> > > > > Eralper
> > > > > http://www.kodyaz.com
> > > > >
> > > > > "JJ" wrote:
> > > > >
> > > > > > Hi All,
> > > > > >
> > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > JJ|||Hi,
I wrote "everyone" which will include "IUSR_Compname" also in the textbox
while defining a new role for folders. But I believe "IUSR_Compname" will
also work.
Thanks for your appreciation. One of my friends also said he had a problem
after the first use of the site. I will be checking what is going on and
inform you :)
"JJ" wrote:
> When you mean grant access to everyone do you mean use IUSR_Compname account
> and assign to folders.
> By the way I really like your website! Any ideas on what's causing the
> error? Would like to access it again. Did you build it yourself?
> Thanks,
> JJ
> "eralper" wrote:
> > Hi,
> >
> > Actually my configuration differs from yours with my web server is IIS5
> > working on Win2k. But I believe this will not cause a problem for anonymous
> > access to reports after the steps I'll try to summarize below.
> >
> > Considering the site security, I'm not sure this is the best practice for
> > reporting services application but it seems working.
> >
> > First you can view and run reports without problem because default
> > authentication method for virtual directories "Reports" and "ReportServer" is
> > window authentication. And I think you browse the reports with an admin group
> > user.
> >
> > With these default configurations of the setup of Reporting Services, your
> > buddy should be able to get the username and password screen for windows
> > authentication when he calls http://YourIPComesHere/Reports
> >
> > If you change IIS permissions for these two virtual directories (Reports &
> > ReportServer), your buddy should see an empty page because the internet guest
> > account has no browser role permission on none of the folders below home
> > (pointing VS.Net Reporting Services projects) or the individual reports in
> > those folders.
> >
> > So before switching to anonymous access on these virtual directories, you
> > should grant Browser role permission to "everyone" in approtiate folders and
> > reports.
> > I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> >
> > So first go to Home directory (http://YourServer/Reports). Select Properties
> > tab for Home and hit the "New Role Assignment" button to add "everyone" as
> > Browser. By doing this, anonymous users will be able to list contents of the
> > Reports folder.
> >
> > Second, select "Detailed View" and "Edit" the report folder where your
> > reports are deployed. Go to Security tab and add "everyone" as Browser.
> >
> > I'm not sure but you may need to repeat a similar step (adding everyone as
> > Browser) for the reports.
> >
> > You should hide the datasources in the list by editing their properties.
> > Check the "hide in list view" option in General tab.
> >
> > One important note: you must edit RSWebApplication config file in
> > "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportManager" folder (default place for this configuration file)
> > Update ReportServerURL by changing the computer name with your IP. Otherwise
> > users will be able reach the report but will not be able to see it processing.
> >
> > Now is time for changing the permissions of the two virtual directories
> > Reports and ReportServer via IIS Manager. Go to properties of the virtual
> > directories then select directory security tab. And allow anonymous access.
> >
> >
> > This configuration works for me. I hope you may find something useful within
> > my notes.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi Eralper,
> > >
> > > I tried to access your website but I keep on getting Obj ref not set
> > > error. This is happening even when I enter www. kodyak.com.
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > > "eralper" wrote:
> > >
> > > > Hi JJ,
> > > >
> > > > I tried to give a detailed answer on
> > > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > > >
> > > > I hope it helps.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi eralper,
> > > > >
> > > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > > Services sp2 installed. I can see and execute the reports through Report
> > > > > Manager with no problem internally. But when I have a buddy check out the
> > > > > website using an IP address. He gets nothing. I have setup roles for
> > > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > > security property under report. In the datasource for report I have included
> > > > > the user name and password that matchs a windows account mapped to a Sql
> > > > > server user account. No problem there. How do you have IIS setup under
> > > > > Directory securities for Report and Report Manager set?
> > > > >
> > > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > > should I check?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ
> > > > >
> > > > >
> > > > > "eralper" wrote:
> > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Did you arrange security settings for the browsing reports?
> > > > > >
> > > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > > Manager to the folder where your reports are.
> > > > > >
> > > > > > Eralper
> > > > > > http://www.kodyaz.com
> > > > > >
> > > > > > "JJ" wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > JJ
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I get
nothing back. I can access my web projects but cant access and display
reports from web. I am using a static ip address to access the website for
now. I don't have a domain name setup for this box yet if that makes a
difference. and internally when I refer to the box in the website I use the
boxs computer name. Any ideas on what could be wrong here?
Thanks,
JJThis topic might help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JJ" <JJ@.discussions.microsoft.com> wrote in message
news:9B7DEDB4-0940-4FED-B6C9-0F05CCDBEF43@.microsoft.com...
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use
> the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi,
Did you arrange security settings for the browsing reports?
You should grant "Browser" Role to Guests or everyone from the Report
Manager to the folder where your reports are.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi eralper,
Man I am so feed up trying to get Reporting Services to be accessed from
the web. I have windows 2003 server running Sql Server 2000 with Reporting
Services sp2 installed. I can see and execute the reports through Report
Manager with no problem internally. But when I have a buddy check out the
website using an IP address. He gets nothing. I have setup roles for
IUSR_Account as browser role and assigned the report trying to access to the
security property under report. In the datasource for report I have included
the user name and password that matchs a windows account mapped to a Sql
server user account. No problem there. How do you have IIS setup under
Directory securities for Report and Report Manager set?
I don't have a domain name setup for this server yet. I am using Static IP
address for the moment. Are you using SSL for Reporting Services? What else
should I check?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Did you arrange security settings for the browsing reports?
> You should grant "Browser" Role to Guests or everyone from the Report
> Manager to the folder where your reports are.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi All,
> >
> > I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web I get
> > nothing back. I can access my web projects but cant access and display
> > reports from web. I am using a static ip address to access the website for
> > now. I don't have a domain name setup for this box yet if that makes a
> > difference. and internally when I refer to the box in the website I use the
> > boxs computer name. Any ideas on what could be wrong here?
> >
> > Thanks,
> >
> > JJ|||Hi JJ,
I tried to give a detailed answer on
http://www.kodyaz.com/ShowPost.aspx?PostID=19
I hope it helps.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi eralper,
> Man I am so feed up trying to get Reporting Services to be accessed from
> the web. I have windows 2003 server running Sql Server 2000 with Reporting
> Services sp2 installed. I can see and execute the reports through Report
> Manager with no problem internally. But when I have a buddy check out the
> website using an IP address. He gets nothing. I have setup roles for
> IUSR_Account as browser role and assigned the report trying to access to the
> security property under report. In the datasource for report I have included
> the user name and password that matchs a windows account mapped to a Sql
> server user account. No problem there. How do you have IIS setup under
> Directory securities for Report and Report Manager set?
> I don't have a domain name setup for this server yet. I am using Static IP
> address for the moment. Are you using SSL for Reporting Services? What else
> should I check?
> Thanks,
> JJ
>
> "eralper" wrote:
> >
> > Hi,
> >
> > Did you arrange security settings for the browsing reports?
> >
> > You should grant "Browser" Role to Guests or everyone from the Report
> > Manager to the folder where your reports are.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi All,
> > >
> > > I have the following going on: A win 2k3 server running sql server and
> > > reporting services. I have IIS configured on it and can run reports
> > > internally on my network but when I try to access a report from the web I get
> > > nothing back. I can access my web projects but cant access and display
> > > reports from web. I am using a static ip address to access the website for
> > > now. I don't have a domain name setup for this box yet if that makes a
> > > difference. and internally when I refer to the box in the website I use the
> > > boxs computer name. Any ideas on what could be wrong here?
> > >
> > > Thanks,
> > >
> > > JJ|||Hi Eralper,
I tried to access your website but I keep on getting Obj ref not set
error. This is happening even when I enter www. kodyak.com.
Thanks,
JJ
"eralper" wrote:
> Hi JJ,
> I tried to give a detailed answer on
> http://www.kodyaz.com/ShowPost.aspx?PostID=19
> I hope it helps.
> Eralper
> http://www.kodyaz.com
>
> "JJ" wrote:
> > Hi eralper,
> >
> > Man I am so feed up trying to get Reporting Services to be accessed from
> > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > Services sp2 installed. I can see and execute the reports through Report
> > Manager with no problem internally. But when I have a buddy check out the
> > website using an IP address. He gets nothing. I have setup roles for
> > IUSR_Account as browser role and assigned the report trying to access to the
> > security property under report. In the datasource for report I have included
> > the user name and password that matchs a windows account mapped to a Sql
> > server user account. No problem there. How do you have IIS setup under
> > Directory securities for Report and Report Manager set?
> >
> > I don't have a domain name setup for this server yet. I am using Static IP
> > address for the moment. Are you using SSL for Reporting Services? What else
> > should I check?
> >
> > Thanks,
> >
> > JJ
> >
> >
> > "eralper" wrote:
> >
> > >
> > > Hi,
> > >
> > > Did you arrange security settings for the browsing reports?
> > >
> > > You should grant "Browser" Role to Guests or everyone from the Report
> > > Manager to the folder where your reports are.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > > "JJ" wrote:
> > >
> > > > Hi All,
> > > >
> > > > I have the following going on: A win 2k3 server running sql server and
> > > > reporting services. I have IIS configured on it and can run reports
> > > > internally on my network but when I try to access a report from the web I get
> > > > nothing back. I can access my web projects but cant access and display
> > > > reports from web. I am using a static ip address to access the website for
> > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > difference. and internally when I refer to the box in the website I use the
> > > > boxs computer name. Any ideas on what could be wrong here?
> > > >
> > > > Thanks,
> > > >
> > > > JJ|||Hi,
Actually my configuration differs from yours with my web server is IIS5
working on Win2k. But I believe this will not cause a problem for anonymous
access to reports after the steps I'll try to summarize below.
Considering the site security, I'm not sure this is the best practice for
reporting services application but it seems working.
First you can view and run reports without problem because default
authentication method for virtual directories "Reports" and "ReportServer" is
window authentication. And I think you browse the reports with an admin group
user.
With these default configurations of the setup of Reporting Services, your
buddy should be able to get the username and password screen for windows
authentication when he calls http://YourIPComesHere/Reports
If you change IIS permissions for these two virtual directories (Reports &
ReportServer), your buddy should see an empty page because the internet guest
account has no browser role permission on none of the folders below home
(pointing VS.Net Reporting Services projects) or the individual reports in
those folders.
So before switching to anonymous access on these virtual directories, you
should grant Browser role permission to "everyone" in approtiate folders and
reports.
I used "everyone", I do not know if it makes sense for IUSR_ComputerName
So first go to Home directory (http://YourServer/Reports). Select Properties
tab for Home and hit the "New Role Assignment" button to add "everyone" as
Browser. By doing this, anonymous users will be able to list contents of the
Reports folder.
Second, select "Detailed View" and "Edit" the report folder where your
reports are deployed. Go to Security tab and add "everyone" as Browser.
I'm not sure but you may need to repeat a similar step (adding everyone as
Browser) for the reports.
You should hide the datasources in the list by editing their properties.
Check the "hide in list view" option in General tab.
One important note: you must edit RSWebApplication config file in
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager" folder (default place for this configuration file)
Update ReportServerURL by changing the computer name with your IP. Otherwise
users will be able reach the report but will not be able to see it processing.
Now is time for changing the permissions of the two virtual directories
Reports and ReportServer via IIS Manager. Go to properties of the virtual
directories then select directory security tab. And allow anonymous access.
This configuration works for me. I hope you may find something useful within
my notes.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi Eralper,
> I tried to access your website but I keep on getting Obj ref not set
> error. This is happening even when I enter www. kodyak.com.
> Thanks,
> JJ
> "eralper" wrote:
> > Hi JJ,
> >
> > I tried to give a detailed answer on
> > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> >
> > I hope it helps.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> > "JJ" wrote:
> >
> > > Hi eralper,
> > >
> > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > Services sp2 installed. I can see and execute the reports through Report
> > > Manager with no problem internally. But when I have a buddy check out the
> > > website using an IP address. He gets nothing. I have setup roles for
> > > IUSR_Account as browser role and assigned the report trying to access to the
> > > security property under report. In the datasource for report I have included
> > > the user name and password that matchs a windows account mapped to a Sql
> > > server user account. No problem there. How do you have IIS setup under
> > > Directory securities for Report and Report Manager set?
> > >
> > > I don't have a domain name setup for this server yet. I am using Static IP
> > > address for the moment. Are you using SSL for Reporting Services? What else
> > > should I check?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> > > "eralper" wrote:
> > >
> > > >
> > > > Hi,
> > > >
> > > > Did you arrange security settings for the browsing reports?
> > > >
> > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > Manager to the folder where your reports are.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > reporting services. I have IIS configured on it and can run reports
> > > > > internally on my network but when I try to access a report from the web I get
> > > > > nothing back. I can access my web projects but cant access and display
> > > > > reports from web. I am using a static ip address to access the website for
> > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > difference. and internally when I refer to the box in the website I use the
> > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ|||When you mean grant access to everyone do you mean use IUSR_Compname account
and assign to folders.
By the way I really like your website! Any ideas on what's causing the
error? Would like to access it again. Did you build it yourself?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Actually my configuration differs from yours with my web server is IIS5
> working on Win2k. But I believe this will not cause a problem for anonymous
> access to reports after the steps I'll try to summarize below.
> Considering the site security, I'm not sure this is the best practice for
> reporting services application but it seems working.
> First you can view and run reports without problem because default
> authentication method for virtual directories "Reports" and "ReportServer" is
> window authentication. And I think you browse the reports with an admin group
> user.
> With these default configurations of the setup of Reporting Services, your
> buddy should be able to get the username and password screen for windows
> authentication when he calls http://YourIPComesHere/Reports
> If you change IIS permissions for these two virtual directories (Reports &
> ReportServer), your buddy should see an empty page because the internet guest
> account has no browser role permission on none of the folders below home
> (pointing VS.Net Reporting Services projects) or the individual reports in
> those folders.
> So before switching to anonymous access on these virtual directories, you
> should grant Browser role permission to "everyone" in approtiate folders and
> reports.
> I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> So first go to Home directory (http://YourServer/Reports). Select Properties
> tab for Home and hit the "New Role Assignment" button to add "everyone" as
> Browser. By doing this, anonymous users will be able to list contents of the
> Reports folder.
> Second, select "Detailed View" and "Edit" the report folder where your
> reports are deployed. Go to Security tab and add "everyone" as Browser.
> I'm not sure but you may need to repeat a similar step (adding everyone as
> Browser) for the reports.
> You should hide the datasources in the list by editing their properties.
> Check the "hide in list view" option in General tab.
> One important note: you must edit RSWebApplication config file in
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager" folder (default place for this configuration file)
> Update ReportServerURL by changing the computer name with your IP. Otherwise
> users will be able reach the report but will not be able to see it processing.
> Now is time for changing the permissions of the two virtual directories
> Reports and ReportServer via IIS Manager. Go to properties of the virtual
> directories then select directory security tab. And allow anonymous access.
>
> This configuration works for me. I hope you may find something useful within
> my notes.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi Eralper,
> >
> > I tried to access your website but I keep on getting Obj ref not set
> > error. This is happening even when I enter www. kodyak.com.
> >
> > Thanks,
> >
> > JJ
> >
> > "eralper" wrote:
> >
> > > Hi JJ,
> > >
> > > I tried to give a detailed answer on
> > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > >
> > > I hope it helps.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > > "JJ" wrote:
> > >
> > > > Hi eralper,
> > > >
> > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > Services sp2 installed. I can see and execute the reports through Report
> > > > Manager with no problem internally. But when I have a buddy check out the
> > > > website using an IP address. He gets nothing. I have setup roles for
> > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > security property under report. In the datasource for report I have included
> > > > the user name and password that matchs a windows account mapped to a Sql
> > > > server user account. No problem there. How do you have IIS setup under
> > > > Directory securities for Report and Report Manager set?
> > > >
> > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > should I check?
> > > >
> > > > Thanks,
> > > >
> > > > JJ
> > > >
> > > >
> > > > "eralper" wrote:
> > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > Did you arrange security settings for the browsing reports?
> > > > >
> > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > Manager to the folder where your reports are.
> > > > >
> > > > > Eralper
> > > > > http://www.kodyaz.com
> > > > >
> > > > > "JJ" wrote:
> > > > >
> > > > > > Hi All,
> > > > > >
> > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > JJ|||Hi,
I wrote "everyone" which will include "IUSR_Compname" also in the textbox
while defining a new role for folders. But I believe "IUSR_Compname" will
also work.
Thanks for your appreciation. One of my friends also said he had a problem
after the first use of the site. I will be checking what is going on and
inform you :)
"JJ" wrote:
> When you mean grant access to everyone do you mean use IUSR_Compname account
> and assign to folders.
> By the way I really like your website! Any ideas on what's causing the
> error? Would like to access it again. Did you build it yourself?
> Thanks,
> JJ
> "eralper" wrote:
> > Hi,
> >
> > Actually my configuration differs from yours with my web server is IIS5
> > working on Win2k. But I believe this will not cause a problem for anonymous
> > access to reports after the steps I'll try to summarize below.
> >
> > Considering the site security, I'm not sure this is the best practice for
> > reporting services application but it seems working.
> >
> > First you can view and run reports without problem because default
> > authentication method for virtual directories "Reports" and "ReportServer" is
> > window authentication. And I think you browse the reports with an admin group
> > user.
> >
> > With these default configurations of the setup of Reporting Services, your
> > buddy should be able to get the username and password screen for windows
> > authentication when he calls http://YourIPComesHere/Reports
> >
> > If you change IIS permissions for these two virtual directories (Reports &
> > ReportServer), your buddy should see an empty page because the internet guest
> > account has no browser role permission on none of the folders below home
> > (pointing VS.Net Reporting Services projects) or the individual reports in
> > those folders.
> >
> > So before switching to anonymous access on these virtual directories, you
> > should grant Browser role permission to "everyone" in approtiate folders and
> > reports.
> > I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> >
> > So first go to Home directory (http://YourServer/Reports). Select Properties
> > tab for Home and hit the "New Role Assignment" button to add "everyone" as
> > Browser. By doing this, anonymous users will be able to list contents of the
> > Reports folder.
> >
> > Second, select "Detailed View" and "Edit" the report folder where your
> > reports are deployed. Go to Security tab and add "everyone" as Browser.
> >
> > I'm not sure but you may need to repeat a similar step (adding everyone as
> > Browser) for the reports.
> >
> > You should hide the datasources in the list by editing their properties.
> > Check the "hide in list view" option in General tab.
> >
> > One important note: you must edit RSWebApplication config file in
> > "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportManager" folder (default place for this configuration file)
> > Update ReportServerURL by changing the computer name with your IP. Otherwise
> > users will be able reach the report but will not be able to see it processing.
> >
> > Now is time for changing the permissions of the two virtual directories
> > Reports and ReportServer via IIS Manager. Go to properties of the virtual
> > directories then select directory security tab. And allow anonymous access.
> >
> >
> > This configuration works for me. I hope you may find something useful within
> > my notes.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi Eralper,
> > >
> > > I tried to access your website but I keep on getting Obj ref not set
> > > error. This is happening even when I enter www. kodyak.com.
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > > "eralper" wrote:
> > >
> > > > Hi JJ,
> > > >
> > > > I tried to give a detailed answer on
> > > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > > >
> > > > I hope it helps.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi eralper,
> > > > >
> > > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > > Services sp2 installed. I can see and execute the reports through Report
> > > > > Manager with no problem internally. But when I have a buddy check out the
> > > > > website using an IP address. He gets nothing. I have setup roles for
> > > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > > security property under report. In the datasource for report I have included
> > > > > the user name and password that matchs a windows account mapped to a Sql
> > > > > server user account. No problem there. How do you have IIS setup under
> > > > > Directory securities for Report and Report Manager set?
> > > > >
> > > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > > should I check?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ
> > > > >
> > > > >
> > > > > "eralper" wrote:
> > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Did you arrange security settings for the browsing reports?
> > > > > >
> > > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > > Manager to the folder where your reports are.
> > > > > >
> > > > > > Eralper
> > > > > > http://www.kodyaz.com
> > > > > >
> > > > > > "JJ" wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > JJ
Friday, February 24, 2012
IIF,ISNULL in transact sql
I have this query in ACCESS VBA:
SELECT DISTINCT qryRCP.RCP_VendorID, Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1))
AS fldNbrRcpts,
Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
fldNbrRejScrap
FROM qryRCP
WHERE qryRCP.RCP_ReceiptQty >=0
GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
qryRCP.VEN_StatusCode
Can anyone help to convert it in sql?
I tried to change nz to isnull, but still hitting syntaz error.
I need to run in sql query analyzer first to find out the problem.
Thanks lotCheck out the ISNULL() and COALESCE functions in BooksOnLine.
Andrew J. Kelly SQL MVP
"Sql Fren" <SqlFren@.discussions.microsoft.com> wrote in message
news:16728166-FF7F-4BEB-86E1-D045B4801F0F@.microsoft.com...
>I have this query in ACCESS VBA:
> SELECT DISTINCT qryRCP.RCP_VendorID,
> Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1))
> AS fldNbrRcpts,
> Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
> fldNbrRejScrap
> FROM qryRCP
> WHERE qryRCP.RCP_ReceiptQty >=0
> GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
> qryRCP.VEN_StatusCode
> Can anyone help to convert it in sql?
> I tried to change nz to isnull, but still hitting syntaz error.
> I need to run in sql query analyzer first to find out the problem.
> Thanks lot|||
SELECT
RCP_VendorID,
SUM(RCP_ReceiptQty), -- because of WHERE clause,
-- this can't possibly be NULL
SUM(COALESCE(SumOfRCQ_RejectQty,0) + COALESCE(SumOfRCQ_ScrapQty,0))
FROM qryRCP
WHERE RCP_ReceiptQty >= 0
GROUP BY RCP_VendorID
-- your other GROUP BY columns are illegal here, since they're
-- not part of the query at all!
On 3/17/05 10:49 PM, in article
16728166-FF7F-4BEB-86E1-D045B4801F0F@.microsoft.com, "Sql Fren"
<SqlFren@.discussions.microsoft.com> wrote:
> SELECT DISTINCT qryRCP.RCP_VendorID, Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1
))
> AS fldNbrRcpts,
> Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
> fldNbrRejScrap
> FROM qryRCP
> WHERE qryRCP.RCP_ReceiptQty >=0
> GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
> qryRCP.VEN_StatusCode|||On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
(snip)
>-- your other GROUP BY columns are illegal here, since they're
>-- not part of the query at all!
Hi Aaron,
That doesn't make them illegal. There's no requirement to include all
group by columns in the select list (though omitting then might make the
output of the query useless - I have a hard time imagining a scenario
where it'd be useful).
use pubs
go
select max(zip)
from authors
group by state
go
95688
46403
66044
20853
48105
97330
37215
84152
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
> -- your other GROUP BY columns are illegal here, since they're
> -- not part of the query at all!
Say what?
From SQL2K Books Online:
|| GROUP BY Clause
|| Specifies the groups into which output rows are to be placed and, if
|| aggregate functions are included in the SELECT clause <select list>,
|| calculates a summary value for each group. When GROUP BY is specified,
|| either each column in any non-aggregate expression in the select list
|| should be included in the GROUP BY list, or the GROUP BY expression
|| must match exactly the select list expression.
I read this as saying that you can't have a non-aggregate expression in the
SELECT list that isn't in the GROUP BY clause - but it says nothing about
having an expression in the GROUP BY clause that isn't in the SELECT list!
Of course, the result isn't very meaningful - how can you tell which rows
correspond to which group by value if the group by value isn't returned -
but I just ran this in query analyzer
select job, count(map) maps, sum(qty) qtys
from ttOrdClubItem
group by job,club
and got the same result as this:
select job, maps, qtys
from (
select job, club, count(map) maps, sum(qty) qtys
from ttOrdClubItem
group by job,club
)
so the construction is definitely "legal", at least|||Oh gosh, semantics. Sorry, I should have said useless, stupid, meaningless,
bizarre, weird, unexpected... any others I'm missing?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:7jql31po7vvbvsu0q5eo2bgdmmus870567@.
4ax.com...
> On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
> (snip)
> Hi Aaron,
> That doesn't make them illegal. There's no requirement to include all
> group by columns in the select list (though omitting then might make the
> output of the query useless - I have a hard time imagining a scenario
> where it'd be useful).
> use pubs
> go
> select max(zip)
> from authors
> group by state
> go
>
> --
> 95688
> 46403
> 66044
> 20853
> 48105
> 97330
> 37215
> 84152
>
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
SELECT DISTINCT qryRCP.RCP_VendorID, Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1))
AS fldNbrRcpts,
Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
fldNbrRejScrap
FROM qryRCP
WHERE qryRCP.RCP_ReceiptQty >=0
GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
qryRCP.VEN_StatusCode
Can anyone help to convert it in sql?
I tried to change nz to isnull, but still hitting syntaz error.
I need to run in sql query analyzer first to find out the problem.
Thanks lotCheck out the ISNULL() and COALESCE functions in BooksOnLine.
Andrew J. Kelly SQL MVP
"Sql Fren" <SqlFren@.discussions.microsoft.com> wrote in message
news:16728166-FF7F-4BEB-86E1-D045B4801F0F@.microsoft.com...
>I have this query in ACCESS VBA:
> SELECT DISTINCT qryRCP.RCP_VendorID,
> Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1))
> AS fldNbrRcpts,
> Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
> fldNbrRejScrap
> FROM qryRCP
> WHERE qryRCP.RCP_ReceiptQty >=0
> GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
> qryRCP.VEN_StatusCode
> Can anyone help to convert it in sql?
> I tried to change nz to isnull, but still hitting syntaz error.
> I need to run in sql query analyzer first to find out the problem.
> Thanks lot|||
SELECT
RCP_VendorID,
SUM(RCP_ReceiptQty), -- because of WHERE clause,
-- this can't possibly be NULL
SUM(COALESCE(SumOfRCQ_RejectQty,0) + COALESCE(SumOfRCQ_ScrapQty,0))
FROM qryRCP
WHERE RCP_ReceiptQty >= 0
GROUP BY RCP_VendorID
-- your other GROUP BY columns are illegal here, since they're
-- not part of the query at all!
On 3/17/05 10:49 PM, in article
16728166-FF7F-4BEB-86E1-D045B4801F0F@.microsoft.com, "Sql Fren"
<SqlFren@.discussions.microsoft.com> wrote:
> SELECT DISTINCT qryRCP.RCP_VendorID, Sum(IIf(nz([RCP_ReceiptQty],0)=0,0,1
))
> AS fldNbrRcpts,
> Sum(IIf(nz([SumOfRCQ_RejectQty]+[SumOfRC
Q_ScrapQty],0)=0,0,1)) AS
> fldNbrRejScrap
> FROM qryRCP
> WHERE qryRCP.RCP_ReceiptQty >=0
> GROUP BY qryRCP.RCP_VendorID, qryRCP.POM_PayName, qryRCP.VEN_PerfRating,
> qryRCP.VEN_StatusCode|||On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
(snip)
>-- your other GROUP BY columns are illegal here, since they're
>-- not part of the query at all!
Hi Aaron,
That doesn't make them illegal. There's no requirement to include all
group by columns in the select list (though omitting then might make the
output of the query useless - I have a hard time imagining a scenario
where it'd be useful).
use pubs
go
select max(zip)
from authors
group by state
go
95688
46403
66044
20853
48105
97330
37215
84152
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
> -- your other GROUP BY columns are illegal here, since they're
> -- not part of the query at all!
Say what?
From SQL2K Books Online:
|| GROUP BY Clause
|| Specifies the groups into which output rows are to be placed and, if
|| aggregate functions are included in the SELECT clause <select list>,
|| calculates a summary value for each group. When GROUP BY is specified,
|| either each column in any non-aggregate expression in the select list
|| should be included in the GROUP BY list, or the GROUP BY expression
|| must match exactly the select list expression.
I read this as saying that you can't have a non-aggregate expression in the
SELECT list that isn't in the GROUP BY clause - but it says nothing about
having an expression in the GROUP BY clause that isn't in the SELECT list!
Of course, the result isn't very meaningful - how can you tell which rows
correspond to which group by value if the group by value isn't returned -
but I just ran this in query analyzer
select job, count(map) maps, sum(qty) qtys
from ttOrdClubItem
group by job,club
and got the same result as this:
select job, maps, qtys
from (
select job, club, count(map) maps, sum(qty) qtys
from ttOrdClubItem
group by job,club
)
so the construction is definitely "legal", at least|||Oh gosh, semantics. Sorry, I should have said useless, stupid, meaningless,
bizarre, weird, unexpected... any others I'm missing?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:7jql31po7vvbvsu0q5eo2bgdmmus870567@.
4ax.com...
> On Thu, 17 Mar 2005 23:06:08 -0500, Aaron [SQL Server MVP] wrote:
> (snip)
> Hi Aaron,
> That doesn't make them illegal. There's no requirement to include all
> group by columns in the select list (though omitting then might make the
> output of the query useless - I have a hard time imagining a scenario
> where it'd be useful).
> use pubs
> go
> select max(zip)
> from authors
> group by state
> go
>
> --
> 95688
> 46403
> 66044
> 20853
> 48105
> 97330
> 37215
> 84152
>
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
Subscribe to:
Posts (Atom)