Can SQL Reporting Services be installed on a virtual PC

Just thinking of ways to reduce server footprint in our Data Center. Is this
possible?
Thanks
--
Jeff Bennett
SQL DBA
St. Louis, MOYes, it's possible.
You'll need to tune it, and it probably won't be too happy if you run lots
of disk intensive reports on it, but it will work. I ran a virtual pc with
Reporting Services 2000 and Analysis Services 2000 as a development server
for almost a year. You'll need to give it lots of RAM, as you can't really
use a pagefile, but other than that it behaves more or less like a normal
server.
Kaisa M. Lindahl Lervik
"Chudman" <Chudman@.discussions.microsoft.com> wrote in message
news:89967826-0F61-46FB-B330-709E33850A9F@.microsoft.com...
> Just thinking of ways to reduce server footprint in our Data Center. Is
> this
> possible?
> Thanks
> --
> Jeff Bennett
> SQL DBA
> St. Louis, MO|||I've run into the similar problem with Virtual PC. Reporting services
appears to operate correctly under the data and layout tab but when I select
Preview it errors out saying an unexpected error occurs. These same reports
work fine on my physical machine using the same verion of reporting services
& Windows XP. I've dedicated 1024 MB of Ram to my virtual which I would
think would be enough memory. Any suggestions on how I can fix reports
services so that I can view the preview of my reports?
Craig
"Kaisa M. Lindahl Lervik" wrote:
> Yes, it's possible.
> You'll need to tune it, and it probably won't be too happy if you run lots
> of disk intensive reports on it, but it will work. I ran a virtual pc with
> Reporting Services 2000 and Analysis Services 2000 as a development server
> for almost a year. You'll need to give it lots of RAM, as you can't really
> use a pagefile, but other than that it behaves more or less like a normal
> server.
> Kaisa M. Lindahl Lervik
>
> "Chudman" <Chudman@.discussions.microsoft.com> wrote in message
> news:89967826-0F61-46FB-B330-709E33850A9F@.microsoft.com...
> > Just thinking of ways to reduce server footprint in our Data Center. Is
> > this
> > possible?
> >
> > Thanks
> > --
> > Jeff Bennett
> > SQL DBA
> > St. Louis, MO
>|||Are you running a Reporting Services server on your virtual PC? Or just the
client tools.
I was a bit superficial in my first reply.
I'm using Virtual Server 2005 R2 (beta) on my Vista PC. I have one image
with Windows XP and the Reporting Services 2000 client tools running on my
Vista PC, and I use this daily to develop reports. I don't have SQL Server,
Analysis Services or Reporting Services SERVER applications on this, I get
my data from other servers, and I deploy to another server running RS 2000.
I don't have any problems using Preview on this, except on very heavy
reports (30 pages with lots of calculations). My virtual image has 1024 MB,
leaving 1024 MB for my host pc.
I also ran a virtual machine on Virtual Server 2005 on a host server. It was
a Windows Server 2003 Std. edition with SQL Server, Analysis Services and
Reporting Services 2000. I gave it 3 GB RAM, which made it happy. I didn't
do any development work on this one though, just used it to run the reports
and OLAP cubes.
Maybe using Virutal Server 2005 gives it better performance than Virtual PC.
Which edition of Virtual PC are you using? 2004 or 2007?
With regards,
Kaisa M. Lindahl Lervik
"Craig Schneider" <Craig Schneider@.discussions.microsoft.com> wrote in
message news:1A6EAE2D-7752-446E-9FF7-2BFBA83E8DAB@.microsoft.com...
> I've run into the similar problem with Virtual PC. Reporting services
> appears to operate correctly under the data and layout tab but when I
> select
> Preview it errors out saying an unexpected error occurs. These same
> reports
> work fine on my physical machine using the same verion of reporting
> services
> & Windows XP. I've dedicated 1024 MB of Ram to my virtual which I would
> think would be enough memory. Any suggestions on how I can fix reports
> services so that I can view the preview of my reports?
> Craig
> "Kaisa M. Lindahl Lervik" wrote:
>> Yes, it's possible.
>> You'll need to tune it, and it probably won't be too happy if you run
>> lots
>> of disk intensive reports on it, but it will work. I ran a virtual pc
>> with
>> Reporting Services 2000 and Analysis Services 2000 as a development
>> server
>> for almost a year. You'll need to give it lots of RAM, as you can't
>> really
>> use a pagefile, but other than that it behaves more or less like a normal
>> server.
>> Kaisa M. Lindahl Lervik
>>
>> "Chudman" <Chudman@.discussions.microsoft.com> wrote in message
>> news:89967826-0F61-46FB-B330-709E33850A9F@.microsoft.com...
>> > Just thinking of ways to reduce server footprint in our Data Center.
>> > Is
>> > this
>> > possible?
>> >
>> > Thanks
>> > --
>> > Jeff Bennett
>> > SQL DBA
>> > St. Louis, MO
>>