Report server service pack

How can I determine what version of service pack for reporting services is
installed on our servers?
I would deeply appreciate step by step instructions.
TIA...Go to http://yourserver/Reportserver
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> How can I determine what version of service pack for reporting services is
> installed on our servers?
> I would deeply appreciate step by step instructions.
> TIA...|||Thank you Bruce.
What would version 8.00.743.00 refer to?
TIA...
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||That must be RTM (release to Manufacturing, i.e. the first release). That
means you have no service packs installed. Given all the fixes I strongly
recommend applying both service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> Thank you Bruce.
> What would version 8.00.743.00 refer to?
> TIA...
> "Bruce L-C [MVP]" wrote:
> > Go to http://yourserver/Reportserver
> >
> > SP1 is Version 8.00.878.00
> > SP2 is Version 8.00.1038.00
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trisha" <trisha@.nospam.nospam> wrote in message
> > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > How can I determine what version of service pack for reporting
services is
> > > installed on our servers?
> > >
> > > I would deeply appreciate step by step instructions.
> > >
> > > TIA...
> >
> >
> >|||Bruce,
I just googled for 8.00.743.00 and it turns out to be the installation
version.
Thanks
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||Thanks Bruce...
"Bruce L-C [MVP]" wrote:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> > Thank you Bruce.
> >
> > What would version 8.00.743.00 refer to?
> >
> > TIA...
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Go to http://yourserver/Reportserver
> > >
> > > SP1 is Version 8.00.878.00
> > > SP2 is Version 8.00.1038.00
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trisha" <trisha@.nospam.nospam> wrote in message
> > > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > > How can I determine what version of service pack for reporting
> services is
> > > > installed on our servers?
> > > >
> > > > I would deeply appreciate step by step instructions.
> > > >
> > > > TIA...
> > >
> > >
> > >
>
>|||When you said "both service packs," does that mean that SP2 doesn't include
fixes from SP1?
When I read through the SP2 docs it wasn't clear to me, but it seemed like
if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
installations.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>|||SP2 includes everything that comes with SP1. So installing just SP2 is
sufficient.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||I was a little sloppy with that statement. As Robert said, SP2 is all that
is needed to upgrade with.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:#X0vnASUFHA.228@.TK2MSFTNGP12.phx.gbl:
> I was a little sloppy with that statement. As Robert said, SP2 is all
> that is needed to upgrade with.
>

Report Server Database is an invalid version

We have been receiving these errors and are not sure why. The Reporting
Server has RS SP1 and the latest SQL Server service pack (SP3a). The webiste
is serving up reports with no problem. Thanks.
Event Type: Error
Event Source: Schedule and Delivery Processor
Event Category: Startup/Shutdown
Event ID: 117
Date: 10/19/2004
Time: 2:36:58 AM
User: N/A
Computer: ProdServer
Description:
The report server database is an invalid version.Does RS work correctly when you browse to //localhost/reportserver? What
user is the reportserver service running as?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troy" <troy@.discussions.microsoft.com> wrote in message
news:04512DEC-7E0E-494A-9201-739E135A2885@.microsoft.com...
> We have been receiving these errors and are not sure why. The Reporting
> Server has RS SP1 and the latest SQL Server service pack (SP3a). The
webiste
> is serving up reports with no problem. Thanks.
> Event Type: Error
> Event Source: Schedule and Delivery Processor
> Event Category: Startup/Shutdown
> Event ID: 117
> Date: 10/19/2004
> Time: 2:36:58 AM
> User: N/A
> Computer: ProdServer
> Description:
> The report server database is an invalid version.|||Hi, I used to face the same problem, until I created a Virtual Directory/Database using the SQL Server Config Wizard. Since, then, the error has stopped occuring.
From http://www.developmentnow.com/g/115_2004_10_0_0_452074/Report-Server-Database-is-an-invalid-version.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Report Renderiring in EXCEL ..

I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
Plateform. - ASP .NET in a VB .NET Project.
I have disabled the EXCEL from my default renedering formats by placing
Visible="false" in RSReportServer.config file for EXCEL.
Now the problem is that I want one report to export to excel. How can I
achieve this without changing the above line?
If anyone could tell me about an article or example implementation of the
same. I will realy appreciate.Are you using SSRS in a custom application. Disabling visiblity on the config
file is for the whole reports and not for individual reports. In that case if
you are in a custome app. then you can use URL access for generating excel or
you can use render method of the rs web serives.
Amarnath
"Tanveer Malik" wrote:
> I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
> Plateform. - ASP .NET in a VB .NET Project.
> I have disabled the EXCEL from my default renedering formats by placing
> Visible="false" in RSReportServer.config file for EXCEL.
> Now the problem is that I want one report to export to excel. How can I
> achieve this without changing the above line?
> If anyone could tell me about an article or example implementation of the
> same. I will realy appreciate.
>
>