Reporting Services SP2 public chat...

We'll be hosting a public chat on the contents of Service Pack 2 on February
8th at 2pm Pacific Time. It's listed at
http://www.microsoft.com/technet/community/chats/default.mspx.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.Stephen Dybing [MSFT] wrote:
> We'll be hosting a public chat on the contents of Service Pack 2 on February 8th at 2pm Pacific
> Time. It's listed at http://www.microsoft.com/technet/community/chats/default.mspx.
> --
> Sincerely,
> Stephen Dybing
When will it be available for download?|||The transcript is usually available within a week of the chat, but the time
does vary a bit.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"GeoSynch" <SpamSlayed@.Casablanca.com> wrote in message
news:OUY7wj2AFHA.3588@.TK2MSFTNGP11.phx.gbl...
> Stephen Dybing [MSFT] wrote:
>> We'll be hosting a public chat on the contents of Service Pack 2 on
>> February 8th at 2pm Pacific Time. It's listed at
>> http://www.microsoft.com/technet/community/chats/default.mspx.
>> --
>> Sincerely,
>> Stephen Dybing
> When will it be available for download?
>|||What about Service Pack 2?
When will that be available for download?
Thanks.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OKTVrM$AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> The transcript is usually available within a week of the chat, but the time does vary a bit.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "GeoSynch" <SpamSlayed@.Casablanca.com> wrote in message
> news:OUY7wj2AFHA.3588@.TK2MSFTNGP11.phx.gbl...
>> Stephen Dybing [MSFT] wrote:
>> We'll be hosting a public chat on the contents of Service Pack 2 on February 8th at 2pm Pacific
>> Time. It's listed at http://www.microsoft.com/technet/community/chats/default.mspx.
>> --
>> Sincerely,
>> Stephen Dybing
>> When will it be available for download?
>

Reporting Services Service Pack 2

Ok,
How do I get what Service Pack if any is installed for Reporting Services?
Version?
SQL query?
I see there is a Service Pack 2 for Reporting Services. Should everything be
fine with my reports after I
install this or is this going to be a mess? Break everything?
thanks
gvThere is no service pack 2 for RS 2005. RS 2000 does have it and is good, I
ran in production with that for quite awhile. For RS 2005 if you install SP1
then you also need to get a hotfix because SP1 broke using All for
multi-select parameters. SP2 is out as a pre-release. I have not installed
it however.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gv" <viator.gerry@.gmail.com> wrote in message
news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
> Ok,
> How do I get what Service Pack if any is installed for Reporting Services?
> Version?
> SQL query?
> I see there is a Service Pack 2 for Reporting Services. Should everything
> be fine with my reports after I
> install this or is this going to be a mess? Break everything?
> thanks
> gv
>|||We are running SQL 2000 Report Services.
How do I check Version Information? What has been installed
thanks for your help
gv
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
> There is no service pack 2 for RS 2005. RS 2000 does have it and is good,
> I ran in production with that for quite awhile. For RS 2005 if you install
> SP1 then you also need to get a hotfix because SP1 broke using All for
> multi-select parameters. SP2 is out as a pre-release. I have not installed
> it however.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gv" <viator.gerry@.gmail.com> wrote in message
> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should everything
>> be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>|||http://servername/Reportserver will show you the Version of the Reporting
service:
original installation 8.00.743.00
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gv" <viator.gerry@.gmail.com> wrote in message
news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
> We are running SQL 2000 Report Services.
> How do I check Version Information? What has been installed
> thanks for your help
> gv
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is good,
>> I ran in production with that for quite awhile. For RS 2005 if you
>> install SP1 then you also need to get a hotfix because SP1 broke using
>> All for multi-select parameters. SP2 is out as a pre-release. I have not
>> installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>|||ok great!
I'm running SP2 - 8.00.1038.00
thanks for your help
gv
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%237Y1ICBHHA.1196@.TK2MSFTNGP02.phx.gbl...
> http://servername/Reportserver will show you the Version of the Reporting
> service:
> original installation 8.00.743.00
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "gv" <viator.gerry@.gmail.com> wrote in message
> news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
>> We are running SQL 2000 Report Services.
>> How do I check Version Information? What has been installed
>> thanks for your help
>> gv
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is
>> good, I ran in production with that for quite awhile. For RS 2005 if you
>> install SP1 then you also need to get a hotfix because SP1 broke using
>> All for multi-select parameters. SP2 is out as a pre-release. I have not
>> installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>>
>|||Another easy way of figuring out if you have SP 2 to RS 2000, is to see if
there's a printer icon on the toolbar of a report that has been rendered. No
printer icon = no SP 2. Printer icon = SP2.
Kaisa M. Lindahl Lervik
"gv" <viator.gerry@.gmail.com> wrote in message
news:eHAz1MCBHHA.996@.TK2MSFTNGP02.phx.gbl...
> ok great!
> I'm running SP2 - 8.00.1038.00
> thanks for your help
> gv
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e%237Y1ICBHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> http://servername/Reportserver will show you the Version of the Reporting
>> service:
>> original installation 8.00.743.00
>> SP1 is Version 8.00.878.00
>> SP2 is Version 8.00.1038.00
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
>> We are running SQL 2000 Report Services.
>> How do I check Version Information? What has been installed
>> thanks for your help
>> gv
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is
>> good, I ran in production with that for quite awhile. For RS 2005 if
>> you install SP1 then you also need to get a hotfix because SP1 broke
>> using All for multi-select parameters. SP2 is out as a pre-release. I
>> have not installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>>
>>
>

Reporting Services not working after Windows 2003 Service Pack 1 installed

Help. After we installed Windows 2003 service pack one the SQL reporting is
getting an error:
The request failed with HTTP status 401: Unauthorized.
Can anybody help?Check if the 401 error has the same call stack as discussed in this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=d2f44745-4eb8-420d-b44a-da1b388069d7&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:euKwWDDRFHA.996@.TK2MSFTNGP09.phx.gbl...
> Help. After we installed Windows 2003 service pack one the SQL reporting
> is getting an error:
> The request failed with HTTP status 401: Unauthorized.
> Can anybody help?
>sql

Reporting Services initial page load takes to long.

I have looked all over to get an answer to the following:
I have installed Reporting Services with the latest service pack. When
I or any of my customers try to initially load the default page
(http://localhost/reports/Pages/Folder.aspx) it will take 20-30
seconds. After the initial load it is fine. The next day when we try
to access it again, it takes 20-30 seconds again. I have seen two
people ask the same question on the newsgroups with no answers.
Some may feel this is not a big deal, but I am moving from one
reporting service to "Reporting Services" and the less issues my
customers have the easier it will be for me to sell this. If I could
get this corrected it would be great, but if I can not, I would at
least like a logical reason why this occurs.
Also
Is there an equivalent function in RS to Crystal's "Next" command
I am converting a report from Crystal to Reporting Services and I need
the ability to look ahead by one row (the Next command in Crystal) and
use this data from the result set to perform certain calculation. If
there is not a similar command is there a way to do this short of
creating a temp table and using a cursor?
Thanks,
TomThe initial delay occurs when ASP.Net first compiles all of the assemblies.
This occurs during the first access only. After a period of time of
inactivity the ASP.Net worker process is unloaded and the whole thing must
start over again.
For you second question I would start a new thread with a subject which
reflects the question, otherwise it might not get answered.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1096037678.531999.323430@.k26g2000oda.googlegroups.com...
> I have looked all over to get an answer to the following:
> I have installed Reporting Services with the latest service pack. When
> I or any of my customers try to initially load the default page
> (http://localhost/reports/Pages/Folder.aspx) it will take 20-30
> seconds. After the initial load it is fine. The next day when we try
> to access it again, it takes 20-30 seconds again. I have seen two
> people ask the same question on the newsgroups with no answers.
> Some may feel this is not a big deal, but I am moving from one
> reporting service to "Reporting Services" and the less issues my
> customers have the easier it will be for me to sell this. If I could
> get this corrected it would be great, but if I can not, I would at
> least like a logical reason why this occurs.
> Also
> Is there an equivalent function in RS to Crystal's "Next" command
> I am converting a report from Crystal to Reporting Services and I need
> the ability to look ahead by one row (the Next command in Crystal) and
> use this data from the result set to perform certain calculation. If
> there is not a similar command is there a way to do this short of
> creating a temp table and using a cursor?
>
> Thanks,
> Tom
>

Reporting Services CRM Feature Pack

I am trying to install the Reporting Services CRM Feature Pack on a SBS 2003.
I have installed Reporting Services and SP1 for it. Everything installed
just fine when I installed Reporting Services. I went to install the Feature
Pack for CRM (also installed on the same server) and at the very end of the
installation, I get the following error:
"Object reference not set to an instance of an object."
That is it and then it backs itself out of the installation. Any ideas? I
have not been successful researching the error as it is highly generic.
ThanksI posted a reply on www.MSCRMExperts.com.
Do you have SQL Reporting Services Service Pack 1 installed?
Y
"kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
news:B37047C3-42CD-4089-88AB-171A273B8AA6@.microsoft.com...
>I am trying to install the Reporting Services CRM Feature Pack on a SBS
>2003.
> I have installed Reporting Services and SP1 for it. Everything installed
> just fine when I installed Reporting Services. I went to install the
> Feature
> Pack for CRM (also installed on the same server) and at the very end of
> the
> installation, I get the following error:
> "Object reference not set to an instance of an object."
> That is it and then it backs itself out of the installation. Any ideas?
> I
> have not been successful researching the error as it is highly generic.
> Thanks|||Yes, Reporting Services SP1 is installed. This is actually a prereq. for it.
I do not think it will even let you begin to install if it detects that SP1
for RS is not there. I am seeing this same issue pop up quite a bit with
others having the same problem. No resolution on any of them though.
"Yoshi" wrote:
> I posted a reply on www.MSCRMExperts.com.
> Do you have SQL Reporting Services Service Pack 1 installed?
> Y
>
> "kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
> news:B37047C3-42CD-4089-88AB-171A273B8AA6@.microsoft.com...
> >I am trying to install the Reporting Services CRM Feature Pack on a SBS
> >2003.
> > I have installed Reporting Services and SP1 for it. Everything installed
> > just fine when I installed Reporting Services. I went to install the
> > Feature
> > Pack for CRM (also installed on the same server) and at the very end of
> > the
> > installation, I get the following error:
> >
> > "Object reference not set to an instance of an object."
> >
> > That is it and then it backs itself out of the installation. Any ideas?
> > I
> > have not been successful researching the error as it is highly generic.
> >
> > Thanks
>
>|||What version of the .Net Framework do you have installed?
Y
"kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
news:98C460C9-6792-43E1-A8F9-D03AC5C98DD5@.microsoft.com...
> Yes, Reporting Services SP1 is installed. This is actually a prereq. for
> it.
> I do not think it will even let you begin to install if it detects that
> SP1
> for RS is not there. I am seeing this same issue pop up quite a bit with
> others having the same problem. No resolution on any of them though.
> "Yoshi" wrote:
>> I posted a reply on www.MSCRMExperts.com.
>> Do you have SQL Reporting Services Service Pack 1 installed?
>> Y
>>
>> "kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
>> news:B37047C3-42CD-4089-88AB-171A273B8AA6@.microsoft.com...
>> >I am trying to install the Reporting Services CRM Feature Pack on a SBS
>> >2003.
>> > I have installed Reporting Services and SP1 for it. Everything
>> > installed
>> > just fine when I installed Reporting Services. I went to install the
>> > Feature
>> > Pack for CRM (also installed on the same server) and at the very end of
>> > the
>> > installation, I get the following error:
>> >
>> > "Object reference not set to an instance of an object."
>> >
>> > That is it and then it backs itself out of the installation. Any
>> > ideas?
>> > I
>> > have not been successful researching the error as it is highly generic.
>> >
>> > Thanks
>>|||This is on SBS 2003 (which is Windows Server 2003). By default, it comes
with .NET Framework v1.1.
"Yoshi" wrote:
> What version of the .Net Framework do you have installed?
> Y
>
> "kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
> news:98C460C9-6792-43E1-A8F9-D03AC5C98DD5@.microsoft.com...
> > Yes, Reporting Services SP1 is installed. This is actually a prereq. for
> > it.
> > I do not think it will even let you begin to install if it detects that
> > SP1
> > for RS is not there. I am seeing this same issue pop up quite a bit with
> > others having the same problem. No resolution on any of them though.
> >
> > "Yoshi" wrote:
> >
> >> I posted a reply on www.MSCRMExperts.com.
> >>
> >> Do you have SQL Reporting Services Service Pack 1 installed?
> >>
> >> Y
> >>
> >>
> >> "kleinmk" <kleinmk@.discussions.microsoft.com> wrote in message
> >> news:B37047C3-42CD-4089-88AB-171A273B8AA6@.microsoft.com...
> >> >I am trying to install the Reporting Services CRM Feature Pack on a SBS
> >> >2003.
> >> > I have installed Reporting Services and SP1 for it. Everything
> >> > installed
> >> > just fine when I installed Reporting Services. I went to install the
> >> > Feature
> >> > Pack for CRM (also installed on the same server) and at the very end of
> >> > the
> >> > installation, I get the following error:
> >> >
> >> > "Object reference not set to an instance of an object."
> >> >
> >> > That is it and then it backs itself out of the installation. Any
> >> > ideas?
> >> > I
> >> > have not been successful researching the error as it is highly generic.
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||I am also getting this error:
"Object reference not set to an instance of an object."
I've verified that the ReportServer is running, however, I can't get the CRM
Report pack to install.|||Here is what we have found out. The environment we have is in Development
but mimics the production environment. So putting VS.NET on it (being SBS
2003 and mimicing the production environment) is not an option for this
circumstance (and is an optional install in the first place). Even though we
have unsuccessfully been able to install the CRM Report Pack, if you can
install it to another server NOT running the CRM, this seems to work. Then,
just publish your rdl from Reporting Services to the actual CRM Server
running Reporting Services. This assumes that you are running CRM and
Reporting Services on the same box.
"Chris" wrote:
> I am also getting this error:
> "Object reference not set to an instance of an object."
> I've verified that the ReportServer is running, however, I can't get the CRM
> Report pack to install.