3G ram for SQL server: services

Showing posts with label services. Show all posts

Sunday, March 25, 2012

A couple of beginner's questions about reporting services

I'm writing my first RS report.
1. Is there any way to program a field to clear, or even hide, under certain
conditions?
2. Is there any way to simulate a check box, to display boolean values? (I
don't see anything in the toolbox.)On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
wrote:
> I'm writing my first RS report.
> 1. Is there any way to program a field to clear, or even hide, under certain
> conditions?
> 2. Is there any way to simulate a check box, to display boolean values? (I
> don't see anything in the toolbox.)
1. Yes. Many of the controls on SSRS are expression based. In your
scenario, expressions can be used to manipulate the Hidden property of
a textbox based on other data, constants, etc.
2. Assuming you're talking about the body of the report. I have used
images in the past to simulate an X or a checkmark.|||I don't think I really understand what you mean by expressions yet. Are you
talking about writing what appears to be a vb command in the format field?
If so, I haven't been able to get that to work yet. What I'd like to do is
something like this:
iif(instr(Fields!SomeValue.Value, "A String") > 0,"",Fields!SomeValue.Value)
In other words, if the value of the incoming string does contain a
particular pattern, blank the box, otherwise display it. Or have I
completely misunderstood the concept?
"Potter" wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> >
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> >
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
>
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
>|||On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
hi there
In the properties box - there is a visibility property - you can use
this and toggle it depending on other fields.
hope that helps
jewel|||Actually no, I need a way to program the visibility based on content.
Clicking on a field won't do.
"jewelfire" wrote:
> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> > wrote:
> >
> > > I'm writing my first RS report.
> >
> > > 1. Is there any way to program a field to clear, or even hide, under certain
> > > conditions?
> >
> > > 2. Is there any way to simulate a check box, to display boolean values? (I
> > > don't see anything in the toolbox.)
> >
> > 1. Yes. Many of the controls on SSRS are expression based. In your
> > scenario, expressions can be used to manipulate the Hidden property of
> > a textbox based on other data, constants, etc.
> > 2. Assuming you're talking about the body of the report. I have used
> > images in the past to simulate an X or a checkmark.
> hi there
> In the properties box - there is a visibility property - you can use
> this and toggle it depending on other fields.
> hope that helps
> jewel
>|||In the visibility property, hidden can be set to true, false or expression.
Pick expression and put the appropriate expression there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> Actually no, I need a way to program the visibility based on content.
> Clicking on a field won't do.
> "jewelfire" wrote:
>> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> > wrote:
>> >
>> > > I'm writing my first RS report.
>> >
>> > > 1. Is there any way to program a field to clear, or even hide, under
>> > > certain
>> > > conditions?
>> >
>> > > 2. Is there any way to simulate a check box, to display boolean
>> > > values? (I
>> > > don't see anything in the toolbox.)
>> >
>> > 1. Yes. Many of the controls on SSRS are expression based. In your
>> > scenario, expressions can be used to manipulate the Hidden property of
>> > a textbox based on other data, constants, etc.
>> > 2. Assuming you're talking about the body of the report. I have used
>> > images in the past to simulate an X or a checkmark.
>> hi there
>> In the properties box - there is a visibility property - you can use
>> this and toggle it depending on other fields.
>> hope that helps
>> jewel
>>|||Missed that! That's what I was looking for.
Just to play safe, here is my code.
=IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
I'm assuming that 'Me' in this context, refers to the current text field.
As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
blank date. (No nulls, period. Company rules.)
"Bruce L-C [MVP]" wrote:
> In the visibility property, hidden can be set to true, false or expression.
> Pick expression and put the appropriate expression there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> > Actually no, I need a way to program the visibility based on content.
> > Clicking on a field won't do.
> >
> > "jewelfire" wrote:
> >
> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> >> > wrote:
> >> >
> >> > > I'm writing my first RS report.
> >> >
> >> > > 1. Is there any way to program a field to clear, or even hide, under
> >> > > certain
> >> > > conditions?
> >> >
> >> > > 2. Is there any way to simulate a check box, to display boolean
> >> > > values? (I
> >> > > don't see anything in the toolbox.)
> >> >
> >> > 1. Yes. Many of the controls on SSRS are expression based. In your
> >> > scenario, expressions can be used to manipulate the Hidden property of
> >> > a textbox based on other data, constants, etc.
> >> > 2. Assuming you're talking about the body of the report. I have used
> >> > images in the past to simulate an X or a checkmark.
> >>
> >> hi there
> >>
> >> In the properties box - there is a visibility property - you can use
> >> this and toggle it depending on other fields.
> >>
> >> hope that helps
> >> jewel
> >>
> >>
>
>|||I haven't used Me in RS (I've used it in VB). It is easy to test. Most
errors are picked up when you try to preview it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:52FB048B-27B0-436A-A269-8B1CC83E12AA@.microsoft.com...
> Missed that! That's what I was looking for.
> Just to play safe, here is my code.
> =IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
> I'm assuming that 'Me' in this context, refers to the current text field.
> As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
> blank date. (No nulls, period. Company rules.)
> "Bruce L-C [MVP]" wrote:
>> In the visibility property, hidden can be set to true, false or
>> expression.
>> Pick expression and put the appropriate expression there.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
>> > Actually no, I need a way to program the visibility based on content.
>> > Clicking on a field won't do.
>> >
>> > "jewelfire" wrote:
>> >
>> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> >> > wrote:
>> >> >
>> >> > > I'm writing my first RS report.
>> >> >
>> >> > > 1. Is there any way to program a field to clear, or even hide,
>> >> > > under
>> >> > > certain
>> >> > > conditions?
>> >> >
>> >> > > 2. Is there any way to simulate a check box, to display boolean
>> >> > > values? (I
>> >> > > don't see anything in the toolbox.)
>> >> >
>> >> > 1. Yes. Many of the controls on SSRS are expression based. In
>> >> > your
>> >> > scenario, expressions can be used to manipulate the Hidden property
>> >> > of
>> >> > a textbox based on other data, constants, etc.
>> >> > 2. Assuming you're talking about the body of the report. I have
>> >> > used
>> >> > images in the past to simulate an X or a checkmark.
>> >>
>> >> hi there
>> >>
>> >> In the properties box - there is a visibility property - you can use
>> >> this and toggle it depending on other fields.
>> >>
>> >> hope that helps
>> >> jewel
>> >>
>> >>
>>|||You can also hide the field using an expression like this (instead of an iif statement):
Click your field, go to your properties box and scroll down to Visibility. Under that you have a hidden option--select Expression.
In the expression paste in a TRUE statement for what you want hidden
=Fields!Dates.Value= "1753"
That will hide the field just under certain conditions.
Hope that also gives you some flexibility
From http://www.developmentnow.com/g/115_2007_5_0_0_968676/A-couple-of-beginners-questions-about-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

a connection error

Hi,
I have an error on my Application Server, it uses
analysis services and a SQL Server databases.
When I try to obtain information from the OLAP databases
it send me the next error:
Error Type:
ADODB.Connection(0x800A0E7A)
Provider cannot be found, It may not be properly
installed
Do you help me?
ThanksCheck to make sure you have MDAC installed properly on your app server

A connection could not be made with report server ...

I just installed SQL Server 2005 (Reporting Services) on my collegues laptop
(Windows XP, SP2) and when we try to deploy the reports we get the message:
"A connection could not be made with report server at
http://localhost/ReportServer"
Everything is running (green checks) in the Reporting Services configuration
manager. We get the error, "Page not found." when we just try to open
http://<machinename>/Reports or http://localhost/Reports. I see the virtual
directories in IIS, all services seem to be running correctly.
Please help! I have installed reporting services about 10 times and have
not run into this problem before. The only issue that we had initially was
that the IIS default web site would not run because there was a conflict on
TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
problem should it.
Thank you,
Laurie
--
LaurieTWhat happens when you try going to http://localhost/?
Have you tried http://localhost:81/Reports, since that's what you changed
the port to?
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>I just installed SQL Server 2005 (Reporting Services) on my collegues
>laptop
> (Windows XP, SP2) and when we try to deploy the reports we get the
> message:
> "A connection could not be made with report server at
> http://localhost/ReportServer"
> Everything is running (green checks) in the Reporting Services
> configuration
> manager. We get the error, "Page not found." when we just try to open
> http://<machinename>/Reports or http://localhost/Reports. I see the
> virtual
> directories in IIS, all services seem to be running correctly.
> Please help! I have installed reporting services about 10 times and have
> not run into this problem before. The only issue that we had initially
> was
> that the IIS default web site would not run because there was a conflict
> on
> TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> problem should it.
> Thank you,
> Laurie
> --
> LaurieT|||Clint -- Thanks, I tried this and still got some errors (although different
than I was seeing before).
I got this error when trying http://localhost:81/Reports
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
----
A name was started with an invalid character. Error processing resource
'http://localhost:81/Reports'. Line 1, Position 2
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag..."
Any ideas?
Thank you.
--
LaurieT
"Clint" wrote:
> What happens when you try going to http://localhost/?
> Have you tried http://localhost:81/Reports, since that's what you changed
> the port to?
> Clint
> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> >I just installed SQL Server 2005 (Reporting Services) on my collegues
> >laptop
> > (Windows XP, SP2) and when we try to deploy the reports we get the
> > message:
> > "A connection could not be made with report server at
> > http://localhost/ReportServer"
> >
> > Everything is running (green checks) in the Reporting Services
> > configuration
> > manager. We get the error, "Page not found." when we just try to open
> > http://<machinename>/Reports or http://localhost/Reports. I see the
> > virtual
> > directories in IIS, all services seem to be running correctly.
> >
> > Please help! I have installed reporting services about 10 times and have
> > not run into this problem before. The only issue that we had initially
> > was
> > that the IIS default web site would not run because there was a conflict
> > on
> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > problem should it.
> >
> > Thank you,
> > Laurie
> > --
> > LaurieT
>
>|||Sorry, I got nothing else. :) I'm pretty much an RS newbie. Hopefully
someone else can chime in for you.
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:71DB89B9-F5F4-445E-A480-95A635B73ECB@.microsoft.com...
> Clint -- Thanks, I tried this and still got some errors (although
> different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
>> What happens when you try going to http://localhost/?
>> Have you tried http://localhost:81/Reports, since that's what you changed
>> the port to?
>> Clint
>> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
>> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>> >I just installed SQL Server 2005 (Reporting Services) on my collegues
>> >laptop
>> > (Windows XP, SP2) and when we try to deploy the reports we get the
>> > message:
>> > "A connection could not be made with report server at
>> > http://localhost/ReportServer"
>> >
>> > Everything is running (green checks) in the Reporting Services
>> > configuration
>> > manager. We get the error, "Page not found." when we just try to open
>> > http://<machinename>/Reports or http://localhost/Reports. I see the
>> > virtual
>> > directories in IIS, all services seem to be running correctly.
>> >
>> > Please help! I have installed reporting services about 10 times and
>> > have
>> > not run into this problem before. The only issue that we had initially
>> > was
>> > that the IIS default web site would not run because there was a
>> > conflict
>> > on
>> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't
>> > be a
>> > problem should it.
>> >
>> > Thank you,
>> > Laurie
>> > --
>> > LaurieT
>>|||laurie,
I had the same problem and Now it has been fixed.i looked online and
here is what i found:
1)The FIX
For IIS MMC: Right click My Computer...then click manage...under
services and applications....expand IIS
then right click the "reports" virtual directory, select property and
then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2.something. For some reason, after you installed reporting
services,
the version of the ASP.NET was removed from the asp.net tab. click ok
2)New Problem
Then you get this new problem when you go to http://localhost/Reports/
--my comment Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException:
Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the
IIS metabase (e.g. IIS://servername/W3SVC). For information on
modifying metabase permissions, please see
http://support.microsoft.com/?kbid=267904 .
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
+3609369 System.Web.CachedPathData.GetPathData(String path) +406
System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
(String sectionName, Type type, ResultsIndex index) +134
2) The FIX
To correct the problem To repair IIS mappings for ASP.NET, run the
Aspnet_regiis.exe utlity. To do so, follow these steps:
Click Start, and then click Run.
Type cmd, and then click OK.
At the command prompt, type the following command, and then press
ENTER:
"\<Windows folder>\Microsoft.NET\Framework\<Version
Number>\aspnet_regiis.exe" -i
NOTE:Replace <Windows folder> with the name of the directory where the
operating system is installed and replace <Version Number> with the
.NET Framework version installed on your computer. Or you could do a
seach for the .exe file and locate the directory
You can find the above reference at
http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
Now try going to http://computername/reports/
Hope it helps,
Sharan Doddakashi
LaurieT wrote:
> Clint -- Thanks, I tried this and still got some errors (although different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
> > What happens when you try going to http://localhost/?
> >
> > Have you tried http://localhost:81/Reports, since that's what you changed
> > the port to?
> >
> > Clint
> >
> > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > >laptop
> > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > message:
> > > "A connection could not be made with report server at
> > > http://localhost/ReportServer"
> > >
> > > Everything is running (green checks) in the Reporting Services
> > > configuration
> > > manager. We get the error, "Page not found." when we just try to open
> > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > virtual
> > > directories in IIS, all services seem to be running correctly.
> > >
> > > Please help! I have installed reporting services about 10 times and have
> > > not run into this problem before. The only issue that we had initially
> > > was
> > > that the IIS default web site would not run because there was a conflict
> > > on
> > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > problem should it.
> > >
> > > Thank you,
> > > Laurie
> > > --
> > > LaurieT
> >
> >
> >|||Sharan,
Thanks for the valuable solution. That was very helpful, precisely to
the point and it solved the issue.
Good Work!
Shailesh
HELP wrote:
> laurie,
> I had the same problem and Now it has been fixed.i looked online and
> here is what i found:
> 1)The FIX
> For IIS MMC: Right click My Computer...then click manage...under
> services and applications....expand IIS
> then right click the "reports" virtual directory, select property and
> then under the
> ASP.NET tab select asp.net version that belongs to the .NET framework
> version 2.something. For some reason, after you installed reporting
> services,
> the version of the ASP.NET was removed from the asp.net tab. click ok
> 2)New Problem
> Then you get this new problem when you go to http://localhost/Reports/
> --my comment Failed to access IIS metabase.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
> Exception Details: System.Web.Hosting.HostingEnvironmentException:
> Failed to access IIS metabase.
> The process account used to run ASP.NET must have read access to the
> IIS metabase (e.g. IIS://servername/W3SVC). For information on
> modifying metabase permissions, please see
> http://support.microsoft.com/?kbid=267904 .
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Stack Trace:
> [HostingEnvironmentException: Failed to access IIS metabase.]
> System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
> +3609369 System.Web.CachedPathData.GetPathData(String path) +406
> System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
> (String sectionName, Type type, ResultsIndex index) +134
>
> 2) The FIX
> To correct the problem To repair IIS mappings for ASP.NET, run the
> Aspnet_regiis.exe utlity. To do so, follow these steps:
> Click Start, and then click Run.
> Type cmd, and then click OK.
> At the command prompt, type the following command, and then press
> ENTER:
> "\<Windows folder>\Microsoft.NET\Framework\<Version
> Number>\aspnet_regiis.exe" -i
> NOTE:Replace <Windows folder> with the name of the directory where the
> operating system is installed and replace <Version Number> with the
> .NET Framework version installed on your computer. Or you could do a
> seach for the .exe file and locate the directory
> You can find the above reference at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
> Now try going to http://computername/reports/
> Hope it helps,
> Sharan Doddakashi
>
> LaurieT wrote:
> > Clint -- Thanks, I tried this and still got some errors (although different
> > than I was seeing before).
> >
> > I got this error when trying http://localhost:81/Reports
> >
> > "The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://localhost:81/Reports'. Line 1, Position 2
> >
> > <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.HomePag..."
> >
> > Any ideas?
> >
> > Thank you.
> > --
> > LaurieT
> >
> >
> > "Clint" wrote:
> >
> > > What happens when you try going to http://localhost/?
> > >
> > > Have you tried http://localhost:81/Reports, since that's what you changed
> > > the port to?
> > >
> > > Clint
> > >
> > > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > > >laptop
> > > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > > message:
> > > > "A connection could not be made with report server at
> > > > http://localhost/ReportServer"
> > > >
> > > > Everything is running (green checks) in the Reporting Services
> > > > configuration
> > > > manager. We get the error, "Page not found." when we just try to open
> > > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > > virtual
> > > > directories in IIS, all services seem to be running correctly.
> > > >
> > > > Please help! I have installed reporting services about 10 times and have
> > > > not run into this problem before. The only issue that we had initially
> > > > was
> > > > that the IIS default web site would not run because there was a conflict
> > > > on
> > > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > > problem should it.
> > > >
> > > > Thank you,
> > > > Laurie
> > > > --
> > > > LaurieT
> > >
> > >
> > >

A connection could not be made with report server

I am new in SQL Server 2005. I am practicing report services and I got
following error:
"A connection could not be made with report server at
https://localhost/ReportServer "
Can anyone help?
DarrenIs SSL set up for the ReportServer virtual directory? What happens
when you connect to http://localhost/reportserver? What happens when
you navigate to http://<machinename>/ReportServer?
Andy Pottersql

A connection could not be made to the report server http://localhost/Reports.

hi all,
i have been trying to Deploy my report and it keeps giving me this
error.
When i go to IIS and browse on reports the Reporting Services page
comes on fine.
And typing http://localhost/Reports renders the Reporting Services
page too. The problem is when i try to deploy, i keep getting this
error.
Please Help!!
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server http://localhost/Reports.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Reports is the portal. ReportServer is reporting services. Try
http://servername/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepali" <dchikkam@.gmail.com> wrote in message
news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
> hi all,
> i have been trying to Deploy my report and it keeps giving me this
> error.
> When i go to IIS and browse on reports the Reporting Services page
> comes on fine.
> And typing http://localhost/Reports renders the Reporting Services
> page too. The problem is when i try to deploy, i keep getting this
> error.
> Please Help!!
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/Reports.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>|||On typing http://localhost/ReportServer,
it renders one of the folders that i had created on the portals.
localhost/ReportServer - /
----
Friday, July 27, 2007 2:01 PM <dir> Practice
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any help is greatly appreciated.
On Jul 27, 3:50 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Reports is the portal. ReportServer is reporting services. Tryhttp://servername/ReportServer
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Deepali" <dchik...@.gmail.com> wrote in message
> news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
>
> > hi all,
> > i have been trying to Deploy my report and it keeps giving me this
> > error.
> > When i go to IIS and browse on reports the Reporting Services page
> > comes on fine.
> > And typinghttp://localhost/Reports renders the Reporting Services
> > page too. The problem is when i try to deploy, i keep getting this
> > error.
> > Please Help!!
> > TITLE: Microsoft Report Designer
> > --
> > A connection could not be made to the report server
> >http://localhost/Reports.
> > --
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > --
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> > --
> > BUTTONS:
> > OK
> > -- Hide quoted text -
> - Show quoted text -|||ok figured it out. the TargetServerURL was pointing to http://localhost/Reports
and changed it to
http://localhost/ReportServer and it started working perfectly.
thanks Bruce .

Thursday, March 22, 2012

A connection could not be made to the report server

installed MS SQL 2005 Express Advanced (with Reporting services). I built a
sample report using the wizard. When i click on 'deploy' i get the error as
below. There is an application with virtual name as 'ReportServer' in the
IIS 5.1 . What could be the possible reasons for this error ?
Regards,
Chak.
:-
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server
http://localhost/ReportServer.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--I re-installed the Reporting server after checking the 'Apply default
settings' check box. Now the report seems to be deployable.
Regards.
"Chakravarthy" <r_chakravarthy@.hotmail.com> wrote in message
news:OHGSa16uGHA.2224@.TK2MSFTNGP06.phx.gbl...
> installed MS SQL 2005 Express Advanced (with Reporting services). I built
> a sample report using the wizard. When i click on 'deploy' i get the error
> as below. There is an application with virtual name as 'ReportServer' in
> the IIS 5.1 . What could be the possible reasons for this error ?
> Regards,
> Chak.
> :-
>
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/ReportServer.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>

A connection cannot be made to Analysis Services 2005

Please help!

I have been trying to deploy an Analysis Services 2005 cube to a server from a local PC. I have had no luck. This was working yesterday and I cannot work out what might be different. This is the error message I am getting:

The project could not be deployed to the 'qccatsvr1' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

By the way this works on another PC that is set up the same way...the only thing I can see different is the Novell user account I used to log in to the PC.

This is what I have tried so far:

Checked that the Analysis Services service is running on the server - it is. Check the target server - this is ok. Re-install Analysis Services 2005 - no problems occurred during this Tried all different changes to the security log on in the Analysis Services service - nothing worked. Tried to open the AS solution file from the actual server and deploy - no luck.

So you can see that I am now getting quite frustrated. I know (hope) it is something simple that I have missed.

Does anyone have any ideas/solutions for me.

Thanks in advance!!!

Steve

SSAS uses windows authentication exclusively. It will not authenticate using a Novell account, but there should be a setting in your Novell client which controls how the user is logged on to the local machine. It is the local windows account that needs to have administrator priviledges in SSAS in order to be able to deploy a new database.

Were you using the same user account when you logged on to the server and tried to deploy the solution? If you use the same account that was used to install SSAS you should not have any issues.

If you want to deploy a solution from a remote machine on a Novell network you will need to setup a local account on the remote workstation which is set to log on to the local machine when the Novell user logs in and then you will need to set up an identical local account (with an identical password) on the server machine and assign the account on the server to the server administration role in SSAS.

|||

I have setup exactly the same account on the server as the windows username used to logon to the remote PC. The account also has exactyl the same password and has been given full access to SSAS. However this does not work either.

The things that has got me confused is that this user was able to deploy a few days before I posted this thread with no problems...that was without a username and password set up on the server with access to SSAS.

Do you have any aother ideas?

|||

I thought you mentioned in your original post that you were now using a different user account. Which is what made me think that it must be something to do with the Novell account/local account connection.

You could have a look at the following link, it contains information on troubleshooting SSAS connection issues: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

|||

Darren,

Thank-you for your advice. I got onto that document and tried a couple of things. The one that helped the most was the SQL Server Profiler. This showed me what was happening with particular accounts and I was able to change the account permission accordingly.

Everything is now ok.

Thanks again for your help with this one...

A connection cannot be made to Analysis Services 2005

Please help!

By the way this works on another PC that is set up the same way...the only thing I can see different is the Novell user account I used to log in to the PC.

This is what I have tried so far:

Checked that the Analysis Services service is running on the server - it is.

Check the target server - this is ok.

Re-install Analysis Services 2005 - no problems occurred during this

Tried all different changes to the security log on in the Analysis Services service - nothing worked.

Tried to open the AS solution file from the actual server and deploy - no luck.

So you can see that I am now getting quite frustrated. I know (hope) it is something simple that I have missed.

Does anyone have any ideas/solutions for me.

Thanks in advance!!!

Steve

Were you using the same user account when you logged on to the server and tried to deploy the solution? If you use the same account that was used to install SSAS you should not have any issues.

|||

Do you have any aother ideas?

|||

You could have a look at the following link, it contains information on troubleshooting SSAS connection issues: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

|||

Darren,

Everything is now ok.

Thanks again for your help with this one...

Monday, March 19, 2012

9MB of errors in log file each time RS report is run

I have a report that is running extremely slowly. The Reporting
Services log files seem to generate 9MB of errors each time I run the
report. The error is the text below repeated over and over. Can anyone
help?
Thanks,
Burt
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__07_01_2004_11_38_28.log</Path>
<SystemName>SFCMSREPORTS</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
aspnet_wp!processing!1c24!7/1/2004-11:38:28:: a ASSERT: Assertion
failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IndexedExprHost.get_Item(Int32
index)
Microsoft.ReportingServices.ReportProcessing.be.a(e A_0, ObjectType
A_1, String A_2, String A_3)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.a(e
A_0, String A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.c()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.e()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.h()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.c()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ac.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.d()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.g()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.a(a5
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.f()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Boolean&
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Object
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a(Object
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+bb.a(ParameterInfoCollection
A_0, Boolean A_1, GetReportChunk A_2)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, ax A_4,
DateTime A_5, z& A_6)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot,
DataSourceInfoCollection thisReportDataSources, Boolean
cachingRequested, Warning[]& warnings, ReportSnapshot&
resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext
context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32
iWRType)Hi Burt, could you please send report definition?
"Burt" burt_5920@.yahoo.com wrote in message
news:19e5f39f.0407011047.ccfd350@.posting.google.com...
> I have a report that is running extremely slowly. The Reporting
> Services log files seem to generate 9MB of errors each time I run the
> report. The error is the text below repeated over and over. Can anyone
> help?
> Thanks,
> Burt
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__07_01_2004_11_38_28.log</Path>
> <SystemName>SFCMSREPORTS</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> aspnet_wp!processing!1c24!7/1/2004-11:38:28:: a ASSERT: Assertion
> failed! Call stack:
>
Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IndexedExpr
Host.get_Item(Int32
> index)
> Microsoft.ReportingServices.ReportProcessing.be.a(e A_0, ObjectType
> A_1, String A_2, String A_3)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.a(e
> A_0, String A_1)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.c()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.e()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.h()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.c()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ac.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.d()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.g()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.a(a5
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.f()
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Boolean&
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Object
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a(Object
> A_0)
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+bb.a(Parameter
InfoCollection
> A_0, Boolean A_1, GetReportChunk A_2)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, ax A_4,
> DateTime A_5, z& A_6)
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(D
ateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
>
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContex
t
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot,
> DataSourceInfoCollection thisReportDataSources, Boolean
> cachingRequested, Warning[]& warnings, ReportSnapshot&
> resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session,
> JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
> effectiveParameters, String[]& secondaryStreamNames)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(
HttpResponseStreamFactory
> streamFactory)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(
)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(It
emType
> itemType)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessReques
t(HttpContext
> context)
>
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplicati
on+IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
>
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(
HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32
> iWRType)

9GB log file generated

Hi
The reporting services is generating large log files of 9GB daily and using
all the virtual memory that all applications on my win2003 server stop
running. Application is running on sql server 2000 and Microsoft Report
Server SP1.
How do I go about trouble-shooting this?
--
Regards PatsyWhich report server log is getting up to 9GB?
Is it the ReportServerTempDB log or ReportServer log? (it better not be the
ReportServer log...)
Or do you mean the actual LOG files in the reportserver directory? (these
are text files)
One thing you can check quickly, make sure the ReportServerTempDB database
is set to simple recovery mode.
=-Chris
"Patsy" <Patsy@.discussions.microsoft.com> wrote in message
news:12B3FCC9-60A3-4F48-B1F0-385B5C2DA7D4@.microsoft.com...
> Hi
> The reporting services is generating large log files of 9GB daily and
> using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy|||This is a known issue. You could search this group for -- log hotfix.
One reply from MS said:
Ask product support for the fix associated with KB 885286.
I believe this is fixed in sp2
Patsy wrote:
> Hi
> The reporting services is generating large log files of 9GB daily and using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy

8GB RAM in SQL Server

Hi,
I'm just designing a server... What can I do with 8GB RAM in the Box?
Analysis Services is limited to 8GB. The Enterprise Edition of SQL Server
can use max.8GB RAM. Windows 2003 Enterprise Edition can use 8GB, too.
So I can use 3GB for Analysis Services and the remaining 5GB are used for
SQL Server and the OS? Is this right?
Thanks
ThomasActually, there is no direct answer for this. It depends
on how much memory the analysis server requires for cubes
and memory required for SQL Server.
It also depends on any other applications running on the
same box.
In General, You have to allocate for OS,SQLServer,analysis
Server and then for other applications.
Please read this to get some idea on how SQL Server memory
works. http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_config_9zfy.asp
Also , read "memory architecture" from BOL.
To allocate memory for Analysis Server, stop and start the
analysis services and open the task manager and look for
memory used by the processess "msmdsrv.exe"
and "msmdvldm.exe". The sum of these memory is minimum
required for analysis services to start.
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>Hi,
>I'm just designing a server... What can I do with 8GB RAM
in the Box?
>Analysis Services is limited to 8GB. The Enterprise
Edition of SQL Server
>can use max.8GB RAM. Windows 2003 Enterprise Edition can
use 8GB, too.
>So I can use 3GB for Analysis Services and the remaining
5GB are used for
>SQL Server and the OS? Is this right?
>
>Thanks
>
>Thomas
>
>.
>|||Hi,
thanks, that pointed me in the right direction...
Thomas
"SQLVarad" <SQLVarad@.hotmail.com> schrieb im Newsbeitrag
news:010c01c3a3d4$6cc8f790$a601280a@.phx.gbl...
> Actually, there is no direct answer for this. It depends
> on how much memory the analysis server requires for cubes
> and memory required for SQL Server.
> It also depends on any other applications running on the
> same box.
> In General, You have to allocate for OS,SQLServer,analysis
> Server and then for other applications.
> Please read this to get some idea on how SQL Server memory
> works. http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_config_9zfy.asp
> Also , read "memory architecture" from BOL.
> To allocate memory for Analysis Server, stop and start the
> analysis services and open the task manager and look for
> memory used by the processess "msmdsrv.exe"
> and "msmdvldm.exe". The sum of these memory is minimum
> required for analysis services to start.
> SQLVarad (MCDBA-1999,MCSE-1999)
>
> >--Original Message--
> >Hi,
> >
> >I'm just designing a server... What can I do with 8GB RAM
> in the Box?
> >Analysis Services is limited to 8GB. The Enterprise
> Edition of SQL Server
> >can use max.8GB RAM. Windows 2003 Enterprise Edition can
> use 8GB, too.
> >So I can use 3GB for Analysis Services and the remaining
> 5GB are used for
> >SQL Server and the OS? Is this right?
> >
> >
> >Thanks
> >
> >
> >Thomas
> >
> >
> >.
> >

8gb of log files - how to i stop ?

Hi,
Reporting services has been running for a couple of months. I noticed today
that I had 8GB of log files. Is there anything I can do to stop so much
being logged ? i don't really need it.
Thanks
ScottThis is a known issue (Bug #: 304241 -
http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
SP2 http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-130...
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"scott" <nospamscott@.yahoo.com> wrote in message
news:uConQxBlFHA.708@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Reporting services has been running for a couple of months. I noticed
> today that I had 8GB of log files. Is there anything I can do to stop so
> much being logged ? i don't really need it.
> Thanks
> Scott
>|||many thanks
scott

Tuesday, March 6, 2012

64-bit SQL Server 2005 Installation (Reporting Services)

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server. The Reporting services is not getting installed or the option is disabled. The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. The server also has SQL Server 2000 (32bit).

Is the 32-bit SQL Server 2000 (32 bit) a problem ? But, it was working fine with the SQL Server 2005 CTP.

Can anyone help/suggest ?

Thanks in advance.remove other reporting services from your machine. and try again

64-bit Reporting Services 2005 single-threading?

We're running on an AMD 8-core Opteron, with Enterprise RS 2005 64-bit.
It seems that when we have multiple users running reports at the same time,
the mdx queries get executed in parallel to the AS database, but the
processing of the data by reporting services is done in a single-thread mode.
E.g. a report run by itself takes 15 seconds. Same report run by 5 people can
take 3:30 to return (with the w3wp taking up the equivalent of only 1 core).
My laptop running RS 2005 processes these simultaneous report faster than our
Opteron!!!
We played with setting the # of workers on the IIS Appl Pool, and it does
seem to cause multiple reports to be processed simultaneously, but I don't
think this is the best solution. I think we are running the equivalent of 8
copies of reporting services on the box in this configuration -- I see 8 RS
logs being generated.
Is there a setting in either IIS or RS 2005 to make it process requests in
parallel?
SteveHi Steve,
Me too, interested to know the answer to your question. If you find out -
please update.
Thanks,
Al
"SteveIrwin" wrote:
...
> Is there a setting in either IIS or RS 2005 to make it process requests in
> parallel?
> Steve|||It looks like the App Pool that gets created for RS has CPUAffinity assign to
it, I think. When you create another App Pool in IIS, and switch the
Reporting Services vdir to use the new pool, then it behaves like a regular
website -- one worker process that answers all requests that come to it,
spawning multiple threads if necessary.
So it comes down to how you want to have RS to work: do you want one worker
that spawns threads to handle requests, or have multiple workers that will
each take up only one cpu/core for each request, then move on to the next
request. It would be interested to see any whitepapers on this subject.
Steve
"TheTechie" wrote:
> Hi Steve,
> Me too, interested to know the answer to your question. If you find out -
> please update.
> Thanks,
> Al
> "SteveIrwin" wrote:
> ...
> > Is there a setting in either IIS or RS 2005 to make it process requests in
> > parallel?
> >
> > Steve

Saturday, February 25, 2012

64-Bit Edition for RS Database

I am attempting to install Reporting Services on a 32-bit application server
with the database on another box running SQL Server 2000 "Enterprise Edition
(64-bit)" . I am receiving the following error:
"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose ..."
The version I am attempting to install is "Reporting Services Enterprise
Edition". I've verified in the install window that it is the Enterprise
Edition of Reporting Services that I am trying to install. I have verified
that I can connect to the 64-bit server from my application server and my SQL
Login Account has SysAdmin permissions. I ran the SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition') command that I read in another thread and it
returned the following information:
8.00.760 SP3 Enterprise Edition (64-bit)
I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
anyone installed Reporting Services using 64-bit SQL Server 2000 for the
database repository?
Thanks in advance...Setup will not allow you to install using a 64 bit version of SQL. There
are manual steps you can perform to get this to work, but it would require a
32 bit version of SQL.
1) Install RS pointing to the 32 bit version of SQL.
2) move both the ReportServer DB and the ReportServerTemp DB to the 64 bit
version (I don't know what the exact steps are to move a database from a 32
bit to a 64 bit sql, you would have to investigate this)
3) use rsconfig.exe to point RS to the 64 bit version of the catalog
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Malinda Jepsen" <Malinda Jepsen@.discussions.microsoft.com> wrote in message
news:E3DE691A-4A16-46CD-BE89-9964EE0FDCBA@.microsoft.com...
> I am attempting to install Reporting Services on a 32-bit application
server
> with the database on another box running SQL Server 2000 "Enterprise
Edition
> (64-bit)" . I am receiving the following error:
> "This edition of the Report Server Database is not supported on the
edition
> of SQL Server 2000 you have chosen. Please choose ..."
> The version I am attempting to install is "Reporting Services Enterprise
> Edition". I've verified in the install window that it is the Enterprise
> Edition of Reporting Services that I am trying to install. I have
verified
> that I can connect to the 64-bit server from my application server and my
SQL
> Login Account has SysAdmin permissions. I ran the SELECT
> SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
> SERVERPROPERTY ('edition') command that I read in another thread and it
> returned the following information:
> 8.00.760 SP3 Enterprise Edition (64-bit)
> I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
> anyone installed Reporting Services using 64-bit SQL Server 2000 for the
> database repository?
> Thanks in advance...|||Finally success!
What I found was that I couldn't pull a database from another install of
Reporting Services. Since I had already installed it in our lab environment
on a 32-bit server, I first tried to attach that database. But when I did
that, Reporting Services thought I wanted to join a web farm. Then when I
tried to install it with the .ini file with SQL authentication to create the
database (RSSETUPACCOUNT/RSSETUPPASSWORD), it was not creating the database
(even though the SQL user I was using had SysAdmin permissions). I finally
gave my NT account SysAdmin rights and then it would create the database
(using the default install without an .ini file). Once that was complete,
sure enough, I could just move it to the 64-bit server (using standard
detach/attach). One final step was to give the SQL (or NT) user permissions
in the database (I started with datareader and datawriter).
"Daniel Reib [MSFT]" wrote:
> Setup will not allow you to install using a 64 bit version of SQL. There
> are manual steps you can perform to get this to work, but it would require a
> 32 bit version of SQL.
> 1) Install RS pointing to the 32 bit version of SQL.
> 2) move both the ReportServer DB and the ReportServerTemp DB to the 64 bit
> version (I don't know what the exact steps are to move a database from a 32
> bit to a 64 bit sql, you would have to investigate this)
> 3) use rsconfig.exe to point RS to the 64 bit version of the catalog
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Malinda Jepsen" <Malinda Jepsen@.discussions.microsoft.com> wrote in message
> news:E3DE691A-4A16-46CD-BE89-9964EE0FDCBA@.microsoft.com...
> > I am attempting to install Reporting Services on a 32-bit application
> server
> > with the database on another box running SQL Server 2000 "Enterprise
> Edition
> > (64-bit)" . I am receiving the following error:
> > "This edition of the Report Server Database is not supported on the
> edition
> > of SQL Server 2000 you have chosen. Please choose ..."
> >
> > The version I am attempting to install is "Reporting Services Enterprise
> > Edition". I've verified in the install window that it is the Enterprise
> > Edition of Reporting Services that I am trying to install. I have
> verified
> > that I can connect to the 64-bit server from my application server and my
> SQL
> > Login Account has SysAdmin permissions. I ran the SELECT
> > SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
> > SERVERPROPERTY ('edition') command that I read in another thread and it
> > returned the following information:
> > 8.00.760 SP3 Enterprise Edition (64-bit)
> >
> > I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
> > anyone installed Reporting Services using 64-bit SQL Server 2000 for the
> > database repository?
> >
> > Thanks in advance...
>
>

Friday, February 24, 2012

64 bit ODBC Datasource

Hello together
I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
Datasource for my reports. I configured and tested the ODBC connection
successfully using the odbcad32.exe in the windows\syswow64 folder.
But when I deploy a report which I designed on my 32 bit development machine
where all is running correctly, and I run the report on the server, it
cannot find the datasource.
I think it has the same reason why I cannot see the MyODBC driver in the
normal ODBC Configuration Manager in the Administrative Tools.
Is there a possiblity to do that anyway'
Thank you and greetings from Switzerland
ThomasHi Thomas,
Did you get a response to this question? I'm not using MySQL, but
I've spent most of today chasing this exact problem. I can tell you
that hacking the registry doesn't work, but I'd really like to know if
you heard from someone that had solved it, or if you found the answer
yourself.
Thanks in advance.
Dan
Thomas Bolt wrote:
> Hello together
> I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
> installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
> Datasource for my reports. I configured and tested the ODBC connection
> successfully using the odbcad32.exe in the windows\syswow64 folder.
> But when I deploy a report which I designed on my 32 bit development machine
> where all is running correctly, and I run the report on the server, it
> cannot find the datasource.
> I think it has the same reason why I cannot see the MyODBC driver in the
> normal ODBC Configuration Manager in the Administrative Tools.
> Is there a possiblity to do that anyway'
> Thank you and greetings from Switzerland
> Thomas|||Hi Dan,
Did you get anywhere with this? I'm in exactly the same position that you
were in August!
Any help would be very much appreciated.
Rob
"barnetted@.michigan.gov" wrote:
> Hi Thomas,
> Did you get a response to this question? I'm not using MySQL, but
> I've spent most of today chasing this exact problem. I can tell you
> that hacking the registry doesn't work, but I'd really like to know if
> you heard from someone that had solved it, or if you found the answer
> yourself.
> Thanks in advance.
> Dan
> Thomas Bolt wrote:
> > Hello together
> >
> > I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
> > installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
> > Datasource for my reports. I configured and tested the ODBC connection
> > successfully using the odbcad32.exe in the windows\syswow64 folder.
> > But when I deploy a report which I designed on my 32 bit development machine
> > where all is running correctly, and I run the report on the server, it
> > cannot find the datasource.
> >
> > I think it has the same reason why I cannot see the MyODBC driver in the
> > normal ODBC Configuration Manager in the Administrative Tools.
> > Is there a possiblity to do that anyway'
> >
> > Thank you and greetings from Switzerland
> > Thomas
>

Thursday, February 16, 2012

50% BLOAT in the Excel files created by Reporting Services.

First, I have SP1.
Microsoft SQL Server Reporting Services Version 8.00.878.00
I created a snapshot - to ensure the db query is not the cause.
I am working on the production hardware (beefy) - and I am the only
one on it.
The HTML version is quite fast off the snapshot (maybe 20 second).
The resulting table is 11k rows spread over 17 pages in HTML.
When I click export to Excel, it's a good 4-7 minutes before it
prompts me to OPEN or SAVE and then another minute or more to SAVE.
The resulting file is 7.8MB. The resulting file takes a good 3 minutes
to load in Excel.
Here's the problem.
The original spreadsheet (created by Business Objects) I am replacing
with RS is only 3.xMB and it has MORE tabs than the one I am creating!
It opens much faster - and is basically the same on the inside.
When I try SAVE AS and select Office 95 - it is still 5.5MB - the same
size I get when I SAVE AS to 2003 but with a different file name. **
This alone tells me there is 50% BLOAT in the Excel files created by
Reporting Services. **
Someone help me.
Why is it so slow?
Why is it so large?
What can I do to make this better? (and don't say SP2, ;))
Thanks in advance, JerryFirst, you can't compare the first page in HTML to the Excel output. You
could compare the MHTML output as it is also a single stream. I'm not sure
how BO's export works so you might not be comparing apples to apples if the
feature set (formatting, etc.) isn't the same. There are also style
duplication optimizations that we can't really do because of our current
flexibility. You might see what happens if you format your entire report as
a single style.
That being said, we are always looking to improve the size and speed of the
exports. If you can isolate what you think might be the root cause, we will
take a look.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410151234.1b184eb0@.posting.google.com...
> First, I have SP1.
> Microsoft SQL Server Reporting Services Version 8.00.878.00
> I created a snapshot - to ensure the db query is not the cause.
> I am working on the production hardware (beefy) - and I am the only
> one on it.
> The HTML version is quite fast off the snapshot (maybe 20 second).
> The resulting table is 11k rows spread over 17 pages in HTML.
> When I click export to Excel, it's a good 4-7 minutes before it
> prompts me to OPEN or SAVE and then another minute or more to SAVE.
> The resulting file is 7.8MB. The resulting file takes a good 3 minutes
> to load in Excel.
> Here's the problem.
> The original spreadsheet (created by Business Objects) I am replacing
> with RS is only 3.xMB and it has MORE tabs than the one I am creating!
> It opens much faster - and is basically the same on the inside.
> When I try SAVE AS and select Office 95 - it is still 5.5MB - the same
> size I get when I SAVE AS to 2003 but with a different file name. **
> This alone tells me there is 50% BLOAT in the Excel files created by
> Reporting Services. **
> Someone help me.
> Why is it so slow?
> Why is it so large?
> What can I do to make this better? (and don't say SP2, ;))
> Thanks in advance, Jerry|||I am comparing apples to apples. I am not comparing to HTML.
My solution, finally, was to export as CSV and use Excel's Web Query -
that saves tons of space and time as the export is WAY faster than to
Excel. Thanks for your response, I have abandoned the Excel export
function as it was too slow.
This line from Books Online sealed the dealf for me:
"Excel / Renders a report in Microsoft Excel. / This format is useful
for report data that you want to manipulate offline or in Microsoft
Excel. Avoid this format for large reports."
BR//Jerry

Monday, February 13, 2012

48folderopen.jpg

A couple of days ago, I asked about changing the Reporting Services web page.
I asked about changing the "SQL Server Reporting Services" text, and
including a company logo where the folder icon now resides. I got a response
that I could change the text by clicking the Site Settings in the upper right
corner, and to look for the css under Program Files\Microsoft SQL Server.
Great start.
It turns out the name of the folder graphic is 48folderopen.jpg. I searched
inside every file on my hard drive, but could not find a reference to that
file name. I did find 48folderopen.jpg in a Microsoft SQL Server subdirectory
(images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see my
logo on the Reporting Services web page, but the sizing is all wrong and it
looks terrible.
Any pointers on where to find the sizing dimensions of 48folderopen.jpg so I
can resize to my logo size? It would also be nice to use my own file name
instead of 48folderopen.jpg, but that's not ciritical.
Thanks,
--
RandyIt is in Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\images
--
"Everyone knows something you don't know"
"randy1200" wrote:
> A couple of days ago, I asked about changing the Reporting Services web page.
> I asked about changing the "SQL Server Reporting Services" text, and
> including a company logo where the folder icon now resides. I got a response
> that I could change the text by clicking the Site Settings in the upper right
> corner, and to look for the css under Program Files\Microsoft SQL Server.
> Great start.
> It turns out the name of the folder graphic is 48folderopen.jpg. I searched
> inside every file on my hard drive, but could not find a reference to that
> file name. I did find 48folderopen.jpg in a Microsoft SQL Server subdirectory
> (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see my
> logo on the Reporting Services web page, but the sizing is all wrong and it
> looks terrible.
> Any pointers on where to find the sizing dimensions of 48folderopen.jpg so I
> can resize to my logo size? It would also be nice to use my own file name
> instead of 48folderopen.jpg, but that's not ciritical.
> Thanks,
> --
> Randy|||Your logo needs to be 48x48 pixels... :)
Unless you update the CSS sheet to size it correctly.
=-Chris
"randy1200" <randy1200@.newsgroups.nospam> wrote in message
news:39551613-4AA2-4D50-9AFA-00C9346C0487@.microsoft.com...
>A couple of days ago, I asked about changing the Reporting Services web
>page.
> I asked about changing the "SQL Server Reporting Services" text, and
> including a company logo where the folder icon now resides. I got a
> response
> that I could change the text by clicking the Site Settings in the upper
> right
> corner, and to look for the css under Program Files\Microsoft SQL Server.
> Great start.
> It turns out the name of the folder graphic is 48folderopen.jpg. I
> searched
> inside every file on my hard drive, but could not find a reference to that
> file name. I did find 48folderopen.jpg in a Microsoft SQL Server
> subdirectory
> (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see
> my
> logo on the Reporting Services web page, but the sizing is all wrong and
> it
> looks terrible.
> Any pointers on where to find the sizing dimensions of 48folderopen.jpg so
> I
> can resize to my logo size? It would also be nice to use my own file name
> instead of 48folderopen.jpg, but that's not ciritical.
> Thanks,
> --
> Randy|||I see nothing in the ReportingServices.css that relates to an image size. Any
pointers here?
I was hoping to find something that said 48x48, and change it to 151x60,
which would work perfectly for me.
--
Randy
"Chris Conner" wrote:
> Your logo needs to be 48x48 pixels... :)
> Unless you update the CSS sheet to size it correctly.
> =-Chris
> "randy1200" <randy1200@.newsgroups.nospam> wrote in message
> news:39551613-4AA2-4D50-9AFA-00C9346C0487@.microsoft.com...
> >A couple of days ago, I asked about changing the Reporting Services web
> >page.
> > I asked about changing the "SQL Server Reporting Services" text, and
> > including a company logo where the folder icon now resides. I got a
> > response
> > that I could change the text by clicking the Site Settings in the upper
> > right
> > corner, and to look for the css under Program Files\Microsoft SQL Server.
> > Great start.
> >
> > It turns out the name of the folder graphic is 48folderopen.jpg. I
> > searched
> > inside every file on my hard drive, but could not find a reference to that
> > file name. I did find 48folderopen.jpg in a Microsoft SQL Server
> > subdirectory
> > (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see
> > my
> > logo on the Reporting Services web page, but the sizing is all wrong and
> > it
> > looks terrible.
> >
> > Any pointers on where to find the sizing dimensions of 48folderopen.jpg so
> > I
> > can resize to my logo size? It would also be nice to use my own file name
> > instead of 48folderopen.jpg, but that's not ciritical.
> >
> > Thanks,
> > --
> > Randy
>
>|||Hello Randy,
Unfortunately, the picture size is hard-coded in the Report Manager, you
could not change it directly.
I looked inside the report manager code and found that it create a HTML
image and hard code the size to be 48 pixel.
You may send the feedback to the product team:
http://connect.microsoft.com/sqlserver.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

48 Second Query Takes 40+ minutes To Display in Report Manager

I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
limitation, but here's the situation.
I have a report based on a single query that accepts 3 parameters:
1) Company (0/1)
2) Month (Date)
3) Retrieve either YTD or Monthly values (0/1)
Executing the query in Query Analyzer using parameters that would be the
worst case scenario from a processing stand point, it takes 48 seconds to
execute, and returns 2,054 rows (by 15 columns). Using parameters for the
best case scenario, it takes about 2-4 seconds, and returns 38 rows.
I can easily execute the best case scenario in SRS to display the report,
and it takes about 5-7 seconds to render as a web page. I continue to
time-out on the worst case scenario report, even after setting the timeout
value to 40 minutes in Site Settings in Report Manager.
Help! We've recommended the SRS architecture to the customer as a solution
over Crystal Reports. It now appears that large (even though it's only 2000
rows) result sets using 2+ groupings is causing SRS to seize in rendering the
report.
Any ideas or suggestions as to how to troubleshoot this?
Thanks!please post ddl, your query etc to give us an idea on how to replicate your
problem. you don't give us much to go on. returning 2,000 + rows is not an
issue in reporting services.
"Smit-Dog" wrote:
> I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> limitation, but here's the situation.
> I have a report based on a single query that accepts 3 parameters:
> 1) Company (0/1)
> 2) Month (Date)
> 3) Retrieve either YTD or Monthly values (0/1)
> Executing the query in Query Analyzer using parameters that would be the
> worst case scenario from a processing stand point, it takes 48 seconds to
> execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> I can easily execute the best case scenario in SRS to display the report,
> and it takes about 5-7 seconds to render as a web page. I continue to
> time-out on the worst case scenario report, even after setting the timeout
> value to 40 minutes in Site Settings in Report Manager.
> Help! We've recommended the SRS architecture to the customer as a solution
> over Crystal Reports. It now appears that large (even though it's only 2000
> rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> report.
> Any ideas or suggestions as to how to troubleshoot this?
> Thanks!|||OK, thanks Mike. I'll include the RDL file, the script for the source tables,
and the query. If you offer any tips for trouble shooting this, that would be
great. I can't believe that a 48 second query takes 40 minutes with SRS.
Link To Download Here (very small file):
http://home.comcast.net/~wcsmith/KM/SRS.zip
Thanks!!!
"mike" wrote:
> please post ddl, your query etc to give us an idea on how to replicate your
> problem. you don't give us much to go on. returning 2,000 + rows is not an
> issue in reporting services.
> "Smit-Dog" wrote:
> > I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> > limitation, but here's the situation.
> >
> > I have a report based on a single query that accepts 3 parameters:
> >
> > 1) Company (0/1)
> > 2) Month (Date)
> > 3) Retrieve either YTD or Monthly values (0/1)
> >
> > Executing the query in Query Analyzer using parameters that would be the
> > worst case scenario from a processing stand point, it takes 48 seconds to
> > execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> > best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> >
> > I can easily execute the best case scenario in SRS to display the report,
> > and it takes about 5-7 seconds to render as a web page. I continue to
> > time-out on the worst case scenario report, even after setting the timeout
> > value to 40 minutes in Site Settings in Report Manager.
> >
> > Help! We've recommended the SRS architecture to the customer as a solution
> > over Crystal Reports. It now appears that large (even though it's only 2000
> > rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> > report.
> >
> > Any ideas or suggestions as to how to troubleshoot this?
> >
> > Thanks!|||Hi SmitDog,
Could you please try something? Hard code the values of the parameters in
your query. See if this improves the performance. If it does, please send
me a good repro and I will find out why this is happening. I tried to repro
in house but not been able to yet.
--
| Thread-Topic: 48 Second Query Takes 40+ minutes To Display in Report
Manager
| thread-index: AcUFWClju0gpbyR3SsGjzN0z7PcJMQ==| X-WBNR-Posting-Host: 68.61.30.192
| From: "=?Utf-8?B?U21pdC1Eb2c=?=" <SmitDog@.discussions.microsoft.com>
| Subject: 48 Second Query Takes 40+ minutes To Display in Report Manager
| Date: Fri, 28 Jan 2005 08:41:05 -0800
| Lines: 27
| Message-ID: <EABFFAF9-25FC-4F39-8EEB-DAF43A60C0F4@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41210
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I don't know if I've quickly hit a SQL Reporting Services (SRS)
architecture
| limitation, but here's the situation.
|
| I have a report based on a single query that accepts 3 parameters:
|
| 1) Company (0/1)
| 2) Month (Date)
| 3) Retrieve either YTD or Monthly values (0/1)
|
| Executing the query in Query Analyzer using parameters that would be the
| worst case scenario from a processing stand point, it takes 48 seconds to
| execute, and returns 2,054 rows (by 15 columns). Using parameters for the
| best case scenario, it takes about 2-4 seconds, and returns 38 rows.
|
| I can easily execute the best case scenario in SRS to display the report,
| and it takes about 5-7 seconds to render as a web page. I continue to
| time-out on the worst case scenario report, even after setting the
timeout
| value to 40 minutes in Site Settings in Report Manager.
|
| Help! We've recommended the SRS architecture to the customer as a
solution
| over Crystal Reports. It now appears that large (even though it's only
2000
| rows) result sets using 2+ groupings is causing SRS to seize in rendering
the
| report.
|
| Any ideas or suggestions as to how to troubleshoot this?
|
| Thanks!
||||BTW, here is the query I'm using as a benchmark. You won't have the data, but
it basically takes 1-3 seconds when using Company = 1 (returning about 40
rows), and about 50 seconds when going against Company = 0 (returning about
2000 rows) in Query Analyzer.
Company = 1 in Report Manager renders in about 5-7 seconds. Company = 0
takes about 45 minutes. FWIW, this is on a 1.3GHz laptop with 512MB RAM,
using SQL Server 2000 (SP3).
Also, the big difference is that Company = 1 only has 59,000 records it's
going against, whereas Company=0 has 2,000,000 records it has to query
against.
exec sp_GetKeyJobSiteIndicatorsData 0, '2004-06-01', 0
"Smit-Dog" wrote:
> OK, thanks Mike. I'll include the RDL file, the script for the source tables,
> and the query. If you offer any tips for trouble shooting this, that would be
> great. I can't believe that a 48 second query takes 40 minutes with SRS.
> Link To Download Here (very small file):
> http://home.comcast.net/~wcsmith/KM/SRS.zip
> Thanks!!!
> "mike" wrote:
> > please post ddl, your query etc to give us an idea on how to replicate your
> > problem. you don't give us much to go on. returning 2,000 + rows is not an
> > issue in reporting services.
> >
> > "Smit-Dog" wrote:
> >
> > > I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> > > limitation, but here's the situation.
> > >
> > > I have a report based on a single query that accepts 3 parameters:
> > >
> > > 1) Company (0/1)
> > > 2) Month (Date)
> > > 3) Retrieve either YTD or Monthly values (0/1)
> > >
> > > Executing the query in Query Analyzer using parameters that would be the
> > > worst case scenario from a processing stand point, it takes 48 seconds to
> > > execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> > > best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> > >
> > > I can easily execute the best case scenario in SRS to display the report,
> > > and it takes about 5-7 seconds to render as a web page. I continue to
> > > time-out on the worst case scenario report, even after setting the timeout
> > > value to 40 minutes in Site Settings in Report Manager.
> > >
> > > Help! We've recommended the SRS architecture to the customer as a solution
> > > over Crystal Reports. It now appears that large (even though it's only 2000
> > > rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> > > report.
> > >
> > > Any ideas or suggestions as to how to troubleshoot this?
> > >
> > > Thanks!|||Hey Brad,
I posted a link to the basic files involved a couple of posts up. It's
missing the data, and that may be the deal-breaker in reproducing the
problem. I can supply a link to a DB backup if that would help, or perhaps
you can see something in my query, table structure, or RDL that would cause
this severe degradation in performance.
I'll try hardcoding the parameters and see if that helps.
""Brad Syputa - MS"" wrote:
> Hi SmitDog,
> Could you please try something? Hard code the values of the parameters in
> your query. See if this improves the performance. If it does, please send
> me a good repro and I will find out why this is happening. I tried to repro
> in house but not been able to yet.
> --
> | Thread-Topic: 48 Second Query Takes 40+ minutes To Display in Report
> Manager
> | thread-index: AcUFWClju0gpbyR3SsGjzN0z7PcJMQ==> | X-WBNR-Posting-Host: 68.61.30.192
> | From: "=?Utf-8?B?U21pdC1Eb2c=?=" <SmitDog@.discussions.microsoft.com>
> | Subject: 48 Second Query Takes 40+ minutes To Display in Report Manager
> | Date: Fri, 28 Jan 2005 08:41:05 -0800
> | Lines: 27
> | Message-ID: <EABFFAF9-25FC-4F39-8EEB-DAF43A60C0F4@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41210
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I don't know if I've quickly hit a SQL Reporting Services (SRS)
> architecture
> | limitation, but here's the situation.
> |
> | I have a report based on a single query that accepts 3 parameters:
> |
> | 1) Company (0/1)
> | 2) Month (Date)
> | 3) Retrieve either YTD or Monthly values (0/1)
> |
> | Executing the query in Query Analyzer using parameters that would be the
> | worst case scenario from a processing stand point, it takes 48 seconds to
> | execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> | best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> |
> | I can easily execute the best case scenario in SRS to display the report,
> | and it takes about 5-7 seconds to render as a web page. I continue to
> | time-out on the worst case scenario report, even after setting the
> timeout
> | value to 40 minutes in Site Settings in Report Manager.
> |
> | Help! We've recommended the SRS architecture to the customer as a
> solution
> | over Crystal Reports. It now appears that large (even though it's only
> 2000
> | rows) result sets using 2+ groupings is causing SRS to seize in rendering
> the
> | report.
> |
> | Any ideas or suggestions as to how to troubleshoot this?
> |
> | Thanks!
> |
>|||One other weird thing that may be related...
Every few days, when running the query in QA using parameters for a worst
case scenerio, it would take 30-35 mintues to run the query. For some reason
it went from under a minute to 30x longer. To find the bottleneck, I
commented out the grouping of CASE statements that would SUM values based on
the code, and used hardcoded values instead. This immediately took the query
(again, in QA) from 30 minutes back down to 20 seconds or so. I slowly went
back to the SP and began to add back the CASE statements one by one, trying
to determine which one was causing the bottleneck. As I added them back, the
query time jumped back up to 48 seconds, very acceptable and suddendly back
to where it was before. Even after adding back all CASE statements, the query
was back down to 48 seconds.
I have no idea as to why this "fixes" the query, and the resulting code is
exactly the same. Perhaps when it "recompiles" it, it's internal algorithm is
fixed? Sorry this is so weird, but it is outside my area of expertise.
FWIW, these are the CASE statements and hardcoded values I toggle between to
"fix" the query.
**************************
sum ( case when ( seg1_code >= 6100 and seg1_code <=6145 ) then Balance end)
as BalanceAdditionalLabor,
sum ( case when ( seg1_code >= 6310 and seg1_code <=6400 ) then Balance end)
as BalanceControllables,
sum ( case when ( seg1_code >= 6001 and seg1_code <= 6008) then Balance end)
as BalanceDirectLabor,
sum ( case when ( ( ( seg1_code >= 6701 and seg1_code <=6785 ) or seg1_code
in ( 6002, 8000, 8005 ) ) ) then Balance end) as BalanceFixed,
sum ( case when ( seg1_code =6201 ) then Balance end) as BalanceMaterials,
sum ( case when ( seg1_code = 6204 ) then Balance end) as BalanceRepairs,
sum ( case when ( seg1_code >= 5001 and seg1_code <= 5999 ) then Balance
end) as BalanceSales,
sum ( case when ( seg1_code =5002 ) then Balance end) as BalanceSpecial,
sum ( case when ( seg1_code = 5100 ) then Balance end) as BalanceSubContractor
--BalanceAdditionalLabor=1,
--BalanceControllables=1,
--BalanceDirectLabor=1,
--BalanceFixed=1,
--BalanceMaterials=1,
--BalanceRepairs=1,
--BalanceSales=1,
--BalanceSpecial=1,
--BalanceSubContractor=1
****************************
"Smit-Dog" wrote:
> I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> limitation, but here's the situation.
> I have a report based on a single query that accepts 3 parameters:
> 1) Company (0/1)
> 2) Month (Date)
> 3) Retrieve either YTD or Monthly values (0/1)
> Executing the query in Query Analyzer using parameters that would be the
> worst case scenario from a processing stand point, it takes 48 seconds to
> execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> I can easily execute the best case scenario in SRS to display the report,
> and it takes about 5-7 seconds to render as a web page. I continue to
> time-out on the worst case scenario report, even after setting the timeout
> value to 40 minutes in Site Settings in Report Manager.
> Help! We've recommended the SRS architecture to the customer as a solution
> over Crystal Reports. It now appears that large (even though it's only 2000
> rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> report.
> Any ideas or suggestions as to how to troubleshoot this?
> Thanks!|||OK... I've done some more testing, and this may not be related to SRS, but
rather some weirdness going on with the query itself.
It appears that I need to comment out a set of CASE statements, substitute
them with hardcoded values, execute the query a few times, un-comment the
CASE statements, then the query takes 48 seconds to run instead of 45 minutes.
I have gone through this little exercise dozens of times, and it magically
"fixes" the query everytime. Again, no perceived performance problem when the
query is run against the smaller company (much smaller result set - 40
records), just when going against the company that returns a large record set
(2400 records).
It's almost as if the query processor gets tangled in a funk, and going
through the comment/un-commenting of the CASE statments allows it to
recompile cleanly/correctly.
Unless someone has a clue as to what would be causing this weirdness, or can
see something glaringly wrong with the query, I'm to the point where I
re-write the query to get rid of the case statements altogether.
Any ideas or suggestions?
Thanks!
"Smit-Dog" wrote:
> I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> limitation, but here's the situation.
> I have a report based on a single query that accepts 3 parameters:
> 1) Company (0/1)
> 2) Month (Date)
> 3) Retrieve either YTD or Monthly values (0/1)
> Executing the query in Query Analyzer using parameters that would be the
> worst case scenario from a processing stand point, it takes 48 seconds to
> execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> I can easily execute the best case scenario in SRS to display the report,
> and it takes about 5-7 seconds to render as a web page. I continue to
> time-out on the worst case scenario report, even after setting the timeout
> value to 40 minutes in Site Settings in Report Manager.
> Help! We've recommended the SRS architecture to the customer as a solution
> over Crystal Reports. It now appears that large (even though it's only 2000
> rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> report.
> Any ideas or suggestions as to how to troubleshoot this?
> Thanks!|||... And I've found out that once I execute the query using Company = 1, then
go back and execute it using Company = 2, the stored procedure is "broke"
again, and takes 40+ minutes to execute. I have to edit the SP, comment out
the CASE statetments, execute it using hardcoded values instead, go back and
un-comment the CASE statements, then using Company = 0 takes 45 seconds.
What the heck is going on here?
"Smit-Dog" wrote:
> I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture
> limitation, but here's the situation.
> I have a report based on a single query that accepts 3 parameters:
> 1) Company (0/1)
> 2) Month (Date)
> 3) Retrieve either YTD or Monthly values (0/1)
> Executing the query in Query Analyzer using parameters that would be the
> worst case scenario from a processing stand point, it takes 48 seconds to
> execute, and returns 2,054 rows (by 15 columns). Using parameters for the
> best case scenario, it takes about 2-4 seconds, and returns 38 rows.
> I can easily execute the best case scenario in SRS to display the report,
> and it takes about 5-7 seconds to render as a web page. I continue to
> time-out on the worst case scenario report, even after setting the timeout
> value to 40 minutes in Site Settings in Report Manager.
> Help! We've recommended the SRS architecture to the customer as a solution
> over Crystal Reports. It now appears that large (even though it's only 2000
> rows) result sets using 2+ groupings is causing SRS to seize in rendering the
> report.
> Any ideas or suggestions as to how to troubleshoot this?
> Thanks!

Sunday, March 25, 2012

A couple of beginner's questions about reporting services

a connection error

A connection could not be made with report server ...

A connection could not be made with report server

A connection could not be made to the report server http://localhost/Reports.

Thursday, March 22, 2012

A connection could not be made to the report server

A connection cannot be made to Analysis Services 2005

A connection cannot be made to Analysis Services 2005

Monday, March 19, 2012

9MB of errors in log file each time RS report is run

9GB log file generated

8GB RAM in SQL Server

8gb of log files - how to i stop ?

Tuesday, March 6, 2012

64-bit SQL Server 2005 Installation (Reporting Services)

64-bit Reporting Services 2005 single-threading?

Saturday, February 25, 2012

64-Bit Edition for RS Database

Friday, February 24, 2012

64 bit ODBC Datasource

Thursday, February 16, 2012

50% BLOAT in the Excel files created by Reporting Services.

Monday, February 13, 2012

48folderopen.jpg

48 Second Query Takes 40+ minutes To Display in Report Manager

3G ram for SQL server

Blog Archive

About Me