Can any third party charting tools be embedded within SQL Reports?
If so, is the Enterprise version of SQL Reporting required? We are
interested in developing a ASP.NET web site which has SQL Reports in it.
Those reports need charts embedded in them and the charts go beyond the
default charts shipped with the Standard Edition of SQL Reporting Services.Have a look at the following sites and go through their documentation. You
may have to research on pricing, development time etc...
http://www.cizer.com/portalcsvs/DesktopDefault.aspx
http://www.dundas.com/products/casestudies/index.aspx?Section=CaseStudies&Campaign=ReportingServi
Good luck!
Rajesh Meenrajan
MCSD.NET
http://meenrajan.blogspot.com
"bteclt" wrote:
> Can any third party charting tools be embedded within SQL Reports?
> If so, is the Enterprise version of SQL Reporting required? We are
> interested in developing a ASP.NET web site which has SQL Reports in it.
> Those reports need charts embedded in them and the charts go beyond the
> default charts shipped with the Standard Edition of SQL Reporting Services.
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Images rendering poorly?
Has anyone else out there had any problems with images rendering improperly
in the reports? When I add our company logo (a gif) to a report, it looks
fine in the development environment. Also, when I export the reports (say,
to a pdf) the images are fine, but when I view the report in a browser
(through the reporting services) the image is slightly skewed. Has anyone
else run across this, and if so, any idea on how to fix this?
Thanks for any help offered.Yes Hammer I have also had this problem for some time now. I have tried all
forms of image input into the report (embedded, project, database, and web)
and all have the same results; a lower quality image.
Anyone else?
"The Hammer" <david.hamilton@.datashapers.com> wrote in message
news:OCHYNpw1EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Has anyone else out there had any problems with images rendering
> improperly
> in the reports? When I add our company logo (a gif) to a report, it looks
> fine in the development environment. Also, when I export the reports (say,
> to a pdf) the images are fine, but when I view the report in a browser
> (through the reporting services) the image is slightly skewed. Has anyone
> else run across this, and if so, any idea on how to fix this?
> Thanks for any help offered.
>
in the reports? When I add our company logo (a gif) to a report, it looks
fine in the development environment. Also, when I export the reports (say,
to a pdf) the images are fine, but when I view the report in a browser
(through the reporting services) the image is slightly skewed. Has anyone
else run across this, and if so, any idea on how to fix this?
Thanks for any help offered.Yes Hammer I have also had this problem for some time now. I have tried all
forms of image input into the report (embedded, project, database, and web)
and all have the same results; a lower quality image.
Anyone else?
"The Hammer" <david.hamilton@.datashapers.com> wrote in message
news:OCHYNpw1EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Has anyone else out there had any problems with images rendering
> improperly
> in the reports? When I add our company logo (a gif) to a report, it looks
> fine in the development environment. Also, when I export the reports (say,
> to a pdf) the images are fine, but when I view the report in a browser
> (through the reporting services) the image is slightly skewed. Has anyone
> else run across this, and if so, any idea on how to fix this?
> Thanks for any help offered.
>
images not showing up on server
I am serving up reports using the web service using the render method.
The reports have images on them. The following scenarios work
.Net application and Reporting Services are all on the same
workstation. Images show up and everything works well.
.Net application on same workstation and I point to Reporting Services
which is on Test environment server A. Images show up and everthing
works well.
This is not working
.Net application is on server B and Reporting Services is on the same
server A. The report shows up but all images show up with the red x.
What can be different between the code on my local workstation and the
code on the server? I have copied all the neccessary files out there.
Is there something on my workstation which has Visual Studio installed
that is not on the server B which only has IIS installed? Or is there
something else I could be missing in the migration to the server
environment?We have found that the report comes up just fine in the server
environment but the image is using different credentials than the user
that is logged in. If we run impersonate as user ABC, all reports come
up fine under ABC, but the image prompts a login box. The image wants
to load under the users that logged in and not the user we use to
impersonate. Any thoughts on how to get around this?
The reports have images on them. The following scenarios work
.Net application and Reporting Services are all on the same
workstation. Images show up and everything works well.
.Net application on same workstation and I point to Reporting Services
which is on Test environment server A. Images show up and everthing
works well.
This is not working
.Net application is on server B and Reporting Services is on the same
server A. The report shows up but all images show up with the red x.
What can be different between the code on my local workstation and the
code on the server? I have copied all the neccessary files out there.
Is there something on my workstation which has Visual Studio installed
that is not on the server B which only has IIS installed? Or is there
something else I could be missing in the migration to the server
environment?We have found that the report comes up just fine in the server
environment but the image is using different credentials than the user
that is logged in. If we run impersonate as user ABC, all reports come
up fine under ABC, but the image prompts a login box. The image wants
to load under the users that logged in and not the user we use to
impersonate. Any thoughts on how to get around this?
Images not lining up with text box
In several of my reports, within the header, I use a small, square, image as a navigation widget to drill through to a related report. Within VS, the report displays fine in both the layout and preview windows; the image is in complete alignment with the textbox on both the right and bottom edge. When I open the report in IE, the right edge remains in perfect alignment, but the bottom edge is 1px higher than the textbox to the left. I have assigned both the textbox and the image a 1pt border and the images are not overlapped. Is it possible to make the textbox line up with the navigation widget on the bottom, or will I need to come up with some workaround. Thanks
This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|
This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|
Thanks
|||
Hey Dude,
Dunno if you have found a fix for this but i found using rectangles a huge help in aligning multi text boxes... maybe the same can help here
Stephen
Images not lining up with text box
In several of my reports, within the header, I use a small, square, image as a navigation widget to drill through to a related report. Within VS, the report displays fine in both the layout and preview windows; the image is in complete alignment with the textbox on both the right and bottom edge. When I open the report in IE, the right edge remains in perfect alignment, but the bottom edge is 1px higher than the textbox to the left. I have assigned both the textbox and the image a 1pt border and the images are not overlapped. Is it possible to make the textbox line up with the navigation widget on the bottom, or will I need to come up with some workaround. Thanks
This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|
This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|
Thanks
|||
Hey Dude,
Dunno if you have found a fix for this but i found using rectangles a huge help in aligning multi text boxes... maybe the same can help here
Stephen
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 in reports . . . .TIFs?
I am trying to embed images within the detail line of my report. It appearse
that this should be easy, the primary problem is the images are .tif . From
everything I am seeing .tifs do not appear to be supported. Is this the case
or am I selecting the wrong option somehow along the way? I find this odd as
Tifs seem to be very common!
The path to each image is stored in a field in my datavbase, so I am trying
to insert the path to the image somewhere in my images properties.
Thanks in advance.I had the almost same problem like you. Actually RS2000 doesn't support to
show Tiff format images in a report, just export is ok. In my case, I created
a web app to convert tiff to jpg, and then used external source to get images
from the web developed. Maybe it'll be fixed later.
Dave
"Rick" wrote:
> I am trying to embed images within the detail line of my report. It appearse
> that this should be easy, the primary problem is the images are .tif . From
> everything I am seeing .tifs do not appear to be supported. Is this the case
> or am I selecting the wrong option somehow along the way? I find this odd as
> Tifs seem to be very common!
> The path to each image is stored in a field in my datavbase, so I am trying
> to insert the path to the image somewhere in my images properties.
> Thanks in advance.|||Actually in rereading I am NOT trying to imbed, but it does not appear to
make a difference.
I am trying to link them to an image control dynamically.
Unfortunately a report could contain THOUSANDS of tifs. Converting them to
jpg's or something else compatable would not be a viable option. I can do
what I need to do in Crystal, but I wanted to keep all of my reporting
together in one interface. This is the only report that I can not do through
reporting services.
Rick
"Rick" wrote:
> I am trying to embed images within the detail line of my report. It appearse
> that this should be easy, the primary problem is the images are .tif . From
> everything I am seeing .tifs do not appear to be supported. Is this the case
> or am I selecting the wrong option somehow along the way? I find this odd as
> Tifs seem to be very common!
> The path to each image is stored in a field in my datavbase, so I am trying
> to insert the path to the image somewhere in my images properties.
> Thanks in advance.
that this should be easy, the primary problem is the images are .tif . From
everything I am seeing .tifs do not appear to be supported. Is this the case
or am I selecting the wrong option somehow along the way? I find this odd as
Tifs seem to be very common!
The path to each image is stored in a field in my datavbase, so I am trying
to insert the path to the image somewhere in my images properties.
Thanks in advance.I had the almost same problem like you. Actually RS2000 doesn't support to
show Tiff format images in a report, just export is ok. In my case, I created
a web app to convert tiff to jpg, and then used external source to get images
from the web developed. Maybe it'll be fixed later.
Dave
"Rick" wrote:
> I am trying to embed images within the detail line of my report. It appearse
> that this should be easy, the primary problem is the images are .tif . From
> everything I am seeing .tifs do not appear to be supported. Is this the case
> or am I selecting the wrong option somehow along the way? I find this odd as
> Tifs seem to be very common!
> The path to each image is stored in a field in my datavbase, so I am trying
> to insert the path to the image somewhere in my images properties.
> Thanks in advance.|||Actually in rereading I am NOT trying to imbed, but it does not appear to
make a difference.
I am trying to link them to an image control dynamically.
Unfortunately a report could contain THOUSANDS of tifs. Converting them to
jpg's or something else compatable would not be a viable option. I can do
what I need to do in Crystal, but I wanted to keep all of my reporting
together in one interface. This is the only report that I can not do through
reporting services.
Rick
"Rick" wrote:
> I am trying to embed images within the detail line of my report. It appearse
> that this should be easy, the primary problem is the images are .tif . From
> everything I am seeing .tifs do not appear to be supported. Is this the case
> or am I selecting the wrong option somehow along the way? I find this odd as
> Tifs seem to be very common!
> The path to each image is stored in a field in my datavbase, so I am trying
> to insert the path to the image somewhere in my images properties.
> Thanks in advance.
images in HTML reports
How to render image in HTML reports?
I have a webapp which invokes Reporting Services web service to generate
reports in HTML format. The reports are for internet users - the image is not
accessible to these internet users because they cannot access the report
server directly which is in the intranet. Is there a solution to this problem
at all?
Thanks
SanjayYes, although it is not simple. You need to use the RenderStream method to
get the image and put it in a place where it is available to the Internet
users. You need to pass this path into the initial Render() call using the
<StreamRoot> deviceInfo.
For what it is worth, this will be much easier in SQL 2005 RS.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> How to render image in HTML reports?
> I have a webapp which invokes Reporting Services web service to generate
> reports in HTML format. The reports are for internet users - the image is
> not
> accessible to these internet users because they cannot access the report
> server directly which is in the intranet. Is there a solution to this
> problem
> at all?
> Thanks
> Sanjay|||That works for me for the intranet users but not for the internet users
because the location where I can generate the image with RenderStream is not
available on internet.
Including an External Web image could work for me because I'm including the
same banner image in my reports, but when I tried to include an External Web
Image like
http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
in my report in report designer, I got message 'Invalid Image'. Is that
expected or is it because of some restrictions in my environment?
Thanks
Sanjay
"Brian Welcker [MS]" wrote:
> Yes, although it is not simple. You need to use the RenderStream method to
> get the image and put it in a place where it is available to the Internet
> users. You need to pass this path into the initial Render() call using the
> <StreamRoot> deviceInfo.
> For what it is worth, this will be much easier in SQL 2005 RS.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> > How to render image in HTML reports?
> > I have a webapp which invokes Reporting Services web service to generate
> > reports in HTML format. The reports are for internet users - the image is
> > not
> > accessible to these internet users because they cannot access the report
> > server directly which is in the intranet. Is there a solution to this
> > problem
> > at all?
> >
> > Thanks
> > Sanjay
>
>|||All images in the reports are effectively "internal". URL only means that
the Report Server retrieves the image from a URL. We need to actually store
the image for consistency (caching, snapshots, etc.). We don't have a 'late
bound' image.
I don't understand why you can't copy the image to a directory on the
external web site.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> That works for me for the intranet users but not for the internet users
> because the location where I can generate the image with RenderStream is
> not
> available on internet.
> Including an External Web image could work for me because I'm including
> the
> same banner image in my reports, but when I tried to include an External
> Web
> Image like
> http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> in my report in report designer, I got message 'Invalid Image'. Is that
> expected or is it because of some restrictions in my environment?
> Thanks
> Sanjay
> "Brian Welcker [MS]" wrote:
>> Yes, although it is not simple. You need to use the RenderStream method
>> to
>> get the image and put it in a place where it is available to the Internet
>> users. You need to pass this path into the initial Render() call using
>> the
>> <StreamRoot> deviceInfo.
>> For what it is worth, this will be much easier in SQL 2005 RS.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> > How to render image in HTML reports?
>> > I have a webapp which invokes Reporting Services web service to
>> > generate
>> > reports in HTML format. The reports are for internet users - the image
>> > is
>> > not
>> > accessible to these internet users because they cannot access the
>> > report
>> > server directly which is in the intranet. Is there a solution to this
>> > problem
>> > at all?
>> >
>> > Thanks
>> > Sanjay
>>|||I can't copy the image to a directory on the external web site because I
don't have access to the report server from the external web site machine as
a result of which I have an intermediate ReportsGeneratorService sitting in
the intranet which generates the reports. In addition I don't have access to
create image files on the external web site machine from the intranet-sitting
ReportsGeneratorService. For Security Reasons. Any suggestions?
Can I manipulate the HTML on the external web-site to pick up the images
from a location in the external web-site?
"Brian Welcker [MS]" wrote:
> All images in the reports are effectively "internal". URL only means that
> the Report Server retrieves the image from a URL. We need to actually store
> the image for consistency (caching, snapshots, etc.). We don't have a 'late
> bound' image.
> I don't understand why you can't copy the image to a directory on the
> external web site.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> > That works for me for the intranet users but not for the internet users
> > because the location where I can generate the image with RenderStream is
> > not
> > available on internet.
> > Including an External Web image could work for me because I'm including
> > the
> > same banner image in my reports, but when I tried to include an External
> > Web
> > Image like
> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> > in my report in report designer, I got message 'Invalid Image'. Is that
> > expected or is it because of some restrictions in my environment?
> >
> > Thanks
> > Sanjay
> > "Brian Welcker [MS]" wrote:
> >
> >> Yes, although it is not simple. You need to use the RenderStream method
> >> to
> >> get the image and put it in a place where it is available to the Internet
> >> users. You need to pass this path into the initial Render() call using
> >> the
> >> <StreamRoot> deviceInfo.
> >>
> >> For what it is worth, this will be much easier in SQL 2005 RS.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> >> > How to render image in HTML reports?
> >> > I have a webapp which invokes Reporting Services web service to
> >> > generate
> >> > reports in HTML format. The reports are for internet users - the image
> >> > is
> >> > not
> >> > accessible to these internet users because they cannot access the
> >> > report
> >> > server directly which is in the intranet. Is there a solution to this
> >> > problem
> >> > at all?
> >> >
> >> > Thanks
> >> > Sanjay
> >>
> >>
> >>
>
>|||Yes, this is what StreamRoot is for. You can put whatever location you want
for picking up the images in the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:23B5C014-89AB-41AA-8A33-C9CA8381D0AB@.microsoft.com...
>I can't copy the image to a directory on the external web site because I
> don't have access to the report server from the external web site machine
> as
> a result of which I have an intermediate ReportsGeneratorService sitting
> in
> the intranet which generates the reports. In addition I don't have access
> to
> create image files on the external web site machine from the
> intranet-sitting
> ReportsGeneratorService. For Security Reasons. Any suggestions?
> Can I manipulate the HTML on the external web-site to pick up the images
> from a location in the external web-site?
> "Brian Welcker [MS]" wrote:
>> All images in the reports are effectively "internal". URL only means that
>> the Report Server retrieves the image from a URL. We need to actually
>> store
>> the image for consistency (caching, snapshots, etc.). We don't have a
>> 'late
>> bound' image.
>> I don't understand why you can't copy the image to a directory on the
>> external web site.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
>> > That works for me for the intranet users but not for the internet users
>> > because the location where I can generate the image with RenderStream
>> > is
>> > not
>> > available on internet.
>> > Including an External Web image could work for me because I'm including
>> > the
>> > same banner image in my reports, but when I tried to include an
>> > External
>> > Web
>> > Image like
>> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
>> > in my report in report designer, I got message 'Invalid Image'. Is that
>> > expected or is it because of some restrictions in my environment?
>> >
>> > Thanks
>> > Sanjay
>> > "Brian Welcker [MS]" wrote:
>> >
>> >> Yes, although it is not simple. You need to use the RenderStream
>> >> method
>> >> to
>> >> get the image and put it in a place where it is available to the
>> >> Internet
>> >> users. You need to pass this path into the initial Render() call using
>> >> the
>> >> <StreamRoot> deviceInfo.
>> >>
>> >> For what it is worth, this will be much easier in SQL 2005 RS.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> >> > How to render image in HTML reports?
>> >> > I have a webapp which invokes Reporting Services web service to
>> >> > generate
>> >> > reports in HTML format. The reports are for internet users - the
>> >> > image
>> >> > is
>> >> > not
>> >> > accessible to these internet users because they cannot access the
>> >> > report
>> >> > server directly which is in the intranet. Is there a solution to
>> >> > this
>> >> > problem
>> >> > at all?
>> >> >
>> >> > Thanks
>> >> > Sanjay
>> >>
>> >>
>> >>
>>
I have a webapp which invokes Reporting Services web service to generate
reports in HTML format. The reports are for internet users - the image is not
accessible to these internet users because they cannot access the report
server directly which is in the intranet. Is there a solution to this problem
at all?
Thanks
SanjayYes, although it is not simple. You need to use the RenderStream method to
get the image and put it in a place where it is available to the Internet
users. You need to pass this path into the initial Render() call using the
<StreamRoot> deviceInfo.
For what it is worth, this will be much easier in SQL 2005 RS.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> How to render image in HTML reports?
> I have a webapp which invokes Reporting Services web service to generate
> reports in HTML format. The reports are for internet users - the image is
> not
> accessible to these internet users because they cannot access the report
> server directly which is in the intranet. Is there a solution to this
> problem
> at all?
> Thanks
> Sanjay|||That works for me for the intranet users but not for the internet users
because the location where I can generate the image with RenderStream is not
available on internet.
Including an External Web image could work for me because I'm including the
same banner image in my reports, but when I tried to include an External Web
Image like
http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
in my report in report designer, I got message 'Invalid Image'. Is that
expected or is it because of some restrictions in my environment?
Thanks
Sanjay
"Brian Welcker [MS]" wrote:
> Yes, although it is not simple. You need to use the RenderStream method to
> get the image and put it in a place where it is available to the Internet
> users. You need to pass this path into the initial Render() call using the
> <StreamRoot> deviceInfo.
> For what it is worth, this will be much easier in SQL 2005 RS.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> > How to render image in HTML reports?
> > I have a webapp which invokes Reporting Services web service to generate
> > reports in HTML format. The reports are for internet users - the image is
> > not
> > accessible to these internet users because they cannot access the report
> > server directly which is in the intranet. Is there a solution to this
> > problem
> > at all?
> >
> > Thanks
> > Sanjay
>
>|||All images in the reports are effectively "internal". URL only means that
the Report Server retrieves the image from a URL. We need to actually store
the image for consistency (caching, snapshots, etc.). We don't have a 'late
bound' image.
I don't understand why you can't copy the image to a directory on the
external web site.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> That works for me for the intranet users but not for the internet users
> because the location where I can generate the image with RenderStream is
> not
> available on internet.
> Including an External Web image could work for me because I'm including
> the
> same banner image in my reports, but when I tried to include an External
> Web
> Image like
> http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> in my report in report designer, I got message 'Invalid Image'. Is that
> expected or is it because of some restrictions in my environment?
> Thanks
> Sanjay
> "Brian Welcker [MS]" wrote:
>> Yes, although it is not simple. You need to use the RenderStream method
>> to
>> get the image and put it in a place where it is available to the Internet
>> users. You need to pass this path into the initial Render() call using
>> the
>> <StreamRoot> deviceInfo.
>> For what it is worth, this will be much easier in SQL 2005 RS.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> > How to render image in HTML reports?
>> > I have a webapp which invokes Reporting Services web service to
>> > generate
>> > reports in HTML format. The reports are for internet users - the image
>> > is
>> > not
>> > accessible to these internet users because they cannot access the
>> > report
>> > server directly which is in the intranet. Is there a solution to this
>> > problem
>> > at all?
>> >
>> > Thanks
>> > Sanjay
>>|||I can't copy the image to a directory on the external web site because I
don't have access to the report server from the external web site machine as
a result of which I have an intermediate ReportsGeneratorService sitting in
the intranet which generates the reports. In addition I don't have access to
create image files on the external web site machine from the intranet-sitting
ReportsGeneratorService. For Security Reasons. Any suggestions?
Can I manipulate the HTML on the external web-site to pick up the images
from a location in the external web-site?
"Brian Welcker [MS]" wrote:
> All images in the reports are effectively "internal". URL only means that
> the Report Server retrieves the image from a URL. We need to actually store
> the image for consistency (caching, snapshots, etc.). We don't have a 'late
> bound' image.
> I don't understand why you can't copy the image to a directory on the
> external web site.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> > That works for me for the intranet users but not for the internet users
> > because the location where I can generate the image with RenderStream is
> > not
> > available on internet.
> > Including an External Web image could work for me because I'm including
> > the
> > same banner image in my reports, but when I tried to include an External
> > Web
> > Image like
> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> > in my report in report designer, I got message 'Invalid Image'. Is that
> > expected or is it because of some restrictions in my environment?
> >
> > Thanks
> > Sanjay
> > "Brian Welcker [MS]" wrote:
> >
> >> Yes, although it is not simple. You need to use the RenderStream method
> >> to
> >> get the image and put it in a place where it is available to the Internet
> >> users. You need to pass this path into the initial Render() call using
> >> the
> >> <StreamRoot> deviceInfo.
> >>
> >> For what it is worth, this will be much easier in SQL 2005 RS.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> >> > How to render image in HTML reports?
> >> > I have a webapp which invokes Reporting Services web service to
> >> > generate
> >> > reports in HTML format. The reports are for internet users - the image
> >> > is
> >> > not
> >> > accessible to these internet users because they cannot access the
> >> > report
> >> > server directly which is in the intranet. Is there a solution to this
> >> > problem
> >> > at all?
> >> >
> >> > Thanks
> >> > Sanjay
> >>
> >>
> >>
>
>|||Yes, this is what StreamRoot is for. You can put whatever location you want
for picking up the images in the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:23B5C014-89AB-41AA-8A33-C9CA8381D0AB@.microsoft.com...
>I can't copy the image to a directory on the external web site because I
> don't have access to the report server from the external web site machine
> as
> a result of which I have an intermediate ReportsGeneratorService sitting
> in
> the intranet which generates the reports. In addition I don't have access
> to
> create image files on the external web site machine from the
> intranet-sitting
> ReportsGeneratorService. For Security Reasons. Any suggestions?
> Can I manipulate the HTML on the external web-site to pick up the images
> from a location in the external web-site?
> "Brian Welcker [MS]" wrote:
>> All images in the reports are effectively "internal". URL only means that
>> the Report Server retrieves the image from a URL. We need to actually
>> store
>> the image for consistency (caching, snapshots, etc.). We don't have a
>> 'late
>> bound' image.
>> I don't understand why you can't copy the image to a directory on the
>> external web site.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
>> > That works for me for the intranet users but not for the internet users
>> > because the location where I can generate the image with RenderStream
>> > is
>> > not
>> > available on internet.
>> > Including an External Web image could work for me because I'm including
>> > the
>> > same banner image in my reports, but when I tried to include an
>> > External
>> > Web
>> > Image like
>> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
>> > in my report in report designer, I got message 'Invalid Image'. Is that
>> > expected or is it because of some restrictions in my environment?
>> >
>> > Thanks
>> > Sanjay
>> > "Brian Welcker [MS]" wrote:
>> >
>> >> Yes, although it is not simple. You need to use the RenderStream
>> >> method
>> >> to
>> >> get the image and put it in a place where it is available to the
>> >> Internet
>> >> users. You need to pass this path into the initial Render() call using
>> >> the
>> >> <StreamRoot> deviceInfo.
>> >>
>> >> For what it is worth, this will be much easier in SQL 2005 RS.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> >> > How to render image in HTML reports?
>> >> > I have a webapp which invokes Reporting Services web service to
>> >> > generate
>> >> > reports in HTML format. The reports are for internet users - the
>> >> > image
>> >> > is
>> >> > not
>> >> > accessible to these internet users because they cannot access the
>> >> > report
>> >> > server directly which is in the intranet. Is there a solution to
>> >> > this
>> >> > problem
>> >> > at all?
>> >> >
>> >> > Thanks
>> >> > Sanjay
>> >>
>> >>
>> >>
>>
Monday, March 26, 2012
Images aren't being displayed in deployed Reports
Hi everybody,Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!
When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.
But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!
I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!
Does anybody have any idea about what might be happening?
Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.
To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.
Actually, view the properties of the image was the first step I took ...
The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b
when I copy the link in IE, I get this error:
Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.
So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!
Regards!|||
Hi Rodrigo,
I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.
Can you please provide me some approach for solving this problem
Regards,
Vikas Khandpur
|||Just change the IP address to the computer name and it will work
Images aren't being displayed in deployed Reports
Hi everybody,Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!
When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.
But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!
I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!
Does anybody have any idea about what might be happening?
Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.
To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.
Actually, view the properties of the image was the first step I took ...
The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b
when I copy the link in IE, I get this error:
Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.
So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!
Regards!|||
Hi Rodrigo,
I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.
Can you please provide me some approach for solving this problem
Regards,
Vikas Khandpur
|||Just change the IP address to the computer name and it will work
Images aren't being displayed in deployed Reports
Hi everybody,Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!
When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.
But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!
I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!
Does anybody have any idea about what might be happening?
Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.
To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.
Actually, view the properties of the image was the first step I took ...
The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b
when I copy the link in IE, I get this error:
Reporting Services Error
The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.
So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!
Regards!|||
Hi Rodrigo,
I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.
Can you please provide me some approach for solving this problem
Regards,
Vikas Khandpur
|||Just change the IP address to the computer name and it will work
Images are not showing...
Hi,
I have two different reports and in these two reports one contains images which is working fine at development site as well as server site but when same report is called from another report using linking facility given in sql report images disappears on server site at development site it is working fine.
Can any one help me out.
Thanks in advance.
Wasim.
Is this is SQL 2005 ?
Did you install SP1 ?
|||Yes, SP1 is installed on my server.|||Is the image embedded on the report or come from URL ?|||Images are embedded.Images and PDF Export POST SP2
After installing RS SP2, images included in my reports display fine in HTML
View, Excel View and TIFF View, but when exported to PDF they are not
displaying properly (they appear garbled, much like a scrambled TV signal).
Any ideas or thoughts?On Follow Up.. this appears to be images other than JPEG's, which according
to documentation are all rendered as PNG's.
"Rob Johnson" wrote:
> After installing RS SP2, images included in my reports display fine in HTML
> View, Excel View and TIFF View, but when exported to PDF they are not
> displaying properly (they appear garbled, much like a scrambled TV signal).
> Any ideas or thoughts?
View, Excel View and TIFF View, but when exported to PDF they are not
displaying properly (they appear garbled, much like a scrambled TV signal).
Any ideas or thoughts?On Follow Up.. this appears to be images other than JPEG's, which according
to documentation are all rendered as PNG's.
"Rob Johnson" wrote:
> After installing RS SP2, images included in my reports display fine in HTML
> View, Excel View and TIFF View, but when exported to PDF they are not
> displaying properly (they appear garbled, much like a scrambled TV signal).
> Any ideas or thoughts?
Friday, March 23, 2012
Image rendering in IE
Hi All,
I cannot get any of my images to display in reports. I have tried all type
of image storage..embedded, external and database and they preview ok but
when i display the report through report manager or URL, the images will not
show. Any ideas?
regardsIt wouldn't be security settings preventing the display of images would it?
"ACC365" <ACC365@.discussions.microsoft.com> wrote in message
news:A865D853-BA28-4FAE-8EC9-14B305F02A3B@.microsoft.com...
> Hi All,
> I cannot get any of my images to display in reports. I have tried all type
> of image storage..embedded, external and database and they preview ok but
> when i display the report through report manager or URL, the images will
not
> show. Any ideas?
> regards|||Well I have found the solution. It is to do with the name of the
server...there is an underscore in it. IE doesn't view an underscore as a
valid charecter so it cannot resolve the pictures. The solution was to either
rename the server or change the "UseSessioncookies" flag in the reporting
services db. In the table configurationInfo I changes the flag to false and
lo and behold it worked.
much happier.
Andy
I cannot get any of my images to display in reports. I have tried all type
of image storage..embedded, external and database and they preview ok but
when i display the report through report manager or URL, the images will not
show. Any ideas?
regardsIt wouldn't be security settings preventing the display of images would it?
"ACC365" <ACC365@.discussions.microsoft.com> wrote in message
news:A865D853-BA28-4FAE-8EC9-14B305F02A3B@.microsoft.com...
> Hi All,
> I cannot get any of my images to display in reports. I have tried all type
> of image storage..embedded, external and database and they preview ok but
> when i display the report through report manager or URL, the images will
not
> show. Any ideas?
> regards|||Well I have found the solution. It is to do with the name of the
server...there is an underscore in it. IE doesn't view an underscore as a
valid charecter so it cannot resolve the pictures. The solution was to either
rename the server or change the "UseSessioncookies" flag in the reporting
services db. In the table configurationInfo I changes the flag to false and
lo and behold it worked.
much happier.
Andy
Image not displaying webform reportviewer
Hi ,
I am using SQL server reports thru web services to display that in web form . Charts are not dispalying coming with [x] image.
I am using VS .NET 2003 . Text is coming properly only problem with the image.
Can anyone suggest me the possible solution for that.
thanx in advance
I'm having this issue as well. Did you ever get it resovled?
Anyone?
Wednesday, March 21, 2012
image files
I've uploaded a gif file to RS using Reports Manager, but when I go to view
the image in RS/RM, it does not display. Only a red X displays.
I'm using RS 2000 with Form based authentication.
Please Help!!!!On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> I've uploaded a gif file to RS using Reports Manager, but when I go to view
> the image in RS/RM, it does not display. Only a red X displays.
> I'm using RS 2000 with Form based authentication.
> Please Help!!!!
I would suggest embedding the image in the report itself. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||how do I embed an image?
"EMartinez" wrote:
> On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> > I've uploaded a gif file to RS using Reports Manager, but when I go to view
> > the image in RS/RM, it does not display. Only a red X displays.
> >
> > I'm using RS 2000 with Form based authentication.
> >
> > Please Help!!!!
> I would suggest embedding the image in the report itself. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>
the image in RS/RM, it does not display. Only a red X displays.
I'm using RS 2000 with Form based authentication.
Please Help!!!!On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> I've uploaded a gif file to RS using Reports Manager, but when I go to view
> the image in RS/RM, it does not display. Only a red X displays.
> I'm using RS 2000 with Form based authentication.
> Please Help!!!!
I would suggest embedding the image in the report itself. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||how do I embed an image?
"EMartinez" wrote:
> On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> > I've uploaded a gif file to RS using Reports Manager, but when I go to view
> > the image in RS/RM, it does not display. Only a red X displays.
> >
> > I'm using RS 2000 with Form based authentication.
> >
> > Please Help!!!!
> I would suggest embedding the image in the report itself. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>
Monday, March 12, 2012
Ill try this again
The 'when run' column of the report manager website is blank. the reports
have been run. i can also look in the ExecutionLog table of the reporting
database and it is properly reflecting the dates and times that a report is
run. it is not as important that i can see the times and dates run there,
but they are also not displaying in sharepoint webpart. Im assuming for the
same reason.
Can some one help me understand why the times are not being displayed on the
website.
TIA
MattThis may be a bug. While you are waiting for a closure on this, consider
changing the GetAllReportProperties stored procedure to get the last
execution time from table ExecutionLog. In general, you should abstain from
making changes to the report catalog, but when there is a will, there is a
way...
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Matt" <Matt@.matt.com> wrote in message
news:uowTZGU6FHA.2176@.TK2MSFTNGP14.phx.gbl...
> The 'when run' column of the report manager website is blank. the reports
> have been run. i can also look in the ExecutionLog table of the reporting
> database and it is properly reflecting the dates and times that a report
> is
> run. it is not as important that i can see the times and dates run there,
> but they are also not displaying in sharepoint webpart. Im assuming for
> the
> same reason.
> Can some one help me understand why the times are not being displayed on
> the
> website.
> TIA
> Matt
>
have been run. i can also look in the ExecutionLog table of the reporting
database and it is properly reflecting the dates and times that a report is
run. it is not as important that i can see the times and dates run there,
but they are also not displaying in sharepoint webpart. Im assuming for the
same reason.
Can some one help me understand why the times are not being displayed on the
website.
TIA
MattThis may be a bug. While you are waiting for a closure on this, consider
changing the GetAllReportProperties stored procedure to get the last
execution time from table ExecutionLog. In general, you should abstain from
making changes to the report catalog, but when there is a will, there is a
way...
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Matt" <Matt@.matt.com> wrote in message
news:uowTZGU6FHA.2176@.TK2MSFTNGP14.phx.gbl...
> The 'when run' column of the report manager website is blank. the reports
> have been run. i can also look in the ExecutionLog table of the reporting
> database and it is properly reflecting the dates and times that a report
> is
> run. it is not as important that i can see the times and dates run there,
> but they are also not displaying in sharepoint webpart. Im assuming for
> the
> same reason.
> Can some one help me understand why the times are not being displayed on
> the
> website.
> TIA
> Matt
>
Friday, March 9, 2012
IIS Virtual Directory Settings
Hi and hopefully thanks for the help.
I have some issues with regard to deploying reports that I can design and
preview.
When I try to deploy I get the 'no report server found' at the directory I
have created in IIS.
Is this to do with settings in the virtual directory or something else?
The Report Server service is running. I am using this on a demo machine with
everything on one machine, sql etc.
ThanksAlso when I try to open report manager, I get an error/welcome page for IIS
as well as the IIS page. Any ideas would be welcome.
Thanks
"Are friends electric?" wrote:
> Hi and hopefully thanks for the help.
> I have some issues with regard to deploying reports that I can design and
> preview.
> When I try to deploy I get the 'no report server found' at the directory I
> have created in IIS.
> Is this to do with settings in the virtual directory or something else?
> The Report Server service is running. I am using this on a demo machine with
> everything on one machine, sql etc.
> Thanks
>
I have some issues with regard to deploying reports that I can design and
preview.
When I try to deploy I get the 'no report server found' at the directory I
have created in IIS.
Is this to do with settings in the virtual directory or something else?
The Report Server service is running. I am using this on a demo machine with
everything on one machine, sql etc.
ThanksAlso when I try to open report manager, I get an error/welcome page for IIS
as well as the IIS page. Any ideas would be welcome.
Thanks
"Are friends electric?" wrote:
> Hi and hopefully thanks for the help.
> I have some issues with regard to deploying reports that I can design and
> preview.
> When I try to deploy I get the 'no report server found' at the directory I
> have created in IIS.
> Is this to do with settings in the virtual directory or something else?
> The Report Server service is running. I am using this on a demo machine with
> everything on one machine, sql etc.
> Thanks
>
IIS Server
I have a SQL Database that is used for storage for an application located on a IIS server.
The users are having a hard time running reports, and automatically assume that it is the SQL Database. I have look in all of the logs, I have done a dbcc checkdb and everything looks fine.
However when I go to the IIS server itself in the event logs there are all sorts of error like the one below:
Error occurred in file:
'D:\teamtrack\Source\Servers\NotificationServer\NS ServerEvents.cpp', line 611.
Resource Msg Id = 474
An error occurred while connecting to
the server.
Message id 38340 could not be sent to (email_address.com.
Does this seems like a sql problem?
Please advise.
LystraSQL Server and IIS do not play well on the same server. You may have to throttle SQL Server's use of memory on the box so that IIS is not memory starved. Search the KnowledgeBase site or Google the microsoft.public.* groups with IIS , SQL Server, and memory keywords.
This sounds reminiscent of a question in the microsoft admin test that I took years ago.
HTH
Tom|||Thanks Tom,
It is not on the same server. I am getting error like below:
Exception occurred in file:
'D:\teamtrack\Source\Db\AppRecord.cpp', line 2827.
Resource Msg Id = 451
The '' record could not be updated in the 'Support Services' database table.
No rows were affected by the update or delete operation.
It looks like a update issue. How should I go about troubleshooting this problem???
Lystra|||In order to narrow down if this is a SQL server problem, or an IIS/Application problem, you coudl get profiler running on the SQL Server to trace all error events. The output will be somewhat confusing, as Profiler will not give you the text of the error message, and some of the messages are actually "normal". I never knew how many "Object not found" errors Enterprise manager could throw.
With this trace, you will find any overt SQL error that the database may be having. Things like the application having timeout issues would be missed by this, as Profiler will only trace server side events.
In order to catch possible timeouts, you could trace for any statement that takes more than 30,000 ms. If you see a lot of these, then you could have either poor database performance, or lock contention.|||I will try using the profiler.
I ran across an article form MS Knowledge base entitled:
There many not be enought virtual memory with large number of database.
Currently the database size is 1.40 GB, and log size is 208MB.
For the server properties on the memory tab it have User a fixed memory size 1494 and the minimun query memory is fixed at 1024.
Is there a way to check to see if memory is okay for the server itself?
Thanks
Lystra|||HELPPPP!!!
Does anyone have any ideas?
The users are having a hard time running reports, and automatically assume that it is the SQL Database. I have look in all of the logs, I have done a dbcc checkdb and everything looks fine.
However when I go to the IIS server itself in the event logs there are all sorts of error like the one below:
Error occurred in file:
'D:\teamtrack\Source\Servers\NotificationServer\NS ServerEvents.cpp', line 611.
Resource Msg Id = 474
An error occurred while connecting to
the server.
Message id 38340 could not be sent to (email_address.com.
Does this seems like a sql problem?
Please advise.
LystraSQL Server and IIS do not play well on the same server. You may have to throttle SQL Server's use of memory on the box so that IIS is not memory starved. Search the KnowledgeBase site or Google the microsoft.public.* groups with IIS , SQL Server, and memory keywords.
This sounds reminiscent of a question in the microsoft admin test that I took years ago.
HTH
Tom|||Thanks Tom,
It is not on the same server. I am getting error like below:
Exception occurred in file:
'D:\teamtrack\Source\Db\AppRecord.cpp', line 2827.
Resource Msg Id = 451
The '' record could not be updated in the 'Support Services' database table.
No rows were affected by the update or delete operation.
It looks like a update issue. How should I go about troubleshooting this problem???
Lystra|||In order to narrow down if this is a SQL server problem, or an IIS/Application problem, you coudl get profiler running on the SQL Server to trace all error events. The output will be somewhat confusing, as Profiler will not give you the text of the error message, and some of the messages are actually "normal". I never knew how many "Object not found" errors Enterprise manager could throw.
With this trace, you will find any overt SQL error that the database may be having. Things like the application having timeout issues would be missed by this, as Profiler will only trace server side events.
In order to catch possible timeouts, you could trace for any statement that takes more than 30,000 ms. If you see a lot of these, then you could have either poor database performance, or lock contention.|||I will try using the profiler.
I ran across an article form MS Knowledge base entitled:
There many not be enought virtual memory with large number of database.
Currently the database size is 1.40 GB, and log size is 208MB.
For the server properties on the memory tab it have User a fixed memory size 1494 and the minimun query memory is fixed at 1024.
Is there a way to check to see if memory is okay for the server itself?
Thanks
Lystra|||HELPPPP!!!
Does anyone have any ideas?
IIS required for SQL Express Adv
I'm trying to install SQL Express Adv and it warns me I need IIS to support certain features for Reports. Despite hours of searching through the MS website, I can not figure out what features those are to determine if I want put in IIS. Furthermore, I can not even figure out how to get IIS on my system. I need to do this for my laptop, which is XP Pro 2002 SP2. I also need to do this for my desktop, which is XP Home 2002 SP2. Neither of them have IIS installed that I can tell (and according to the initial install check done by SQL Express Adv it is not installed).
XP Pro comes with IIS, but does not install it, you need to select it from the list of options in add/remove programs/add/remove windows components. XP Home does not support IIS at all, ever.
I would guess that unless you want to serve data over the web, you don't need IIS.
Subscribe to:
Posts (Atom)