Can I run SQL db, RS 2000, and Analysis server all on 1 box?

We currently have SERVER A which is just IIS for VS2002 applications(and some
file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
running on one box? If so, what are the requirements? But doesn't RS 2000,
need IIS? Then I would need to install RS on SERVER A. But then SERVER A
would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?There is nothing preventing you from having IIS on your SQL Server box. If
you run it all on the same box it is free. Otherwise you are correct, you
have to have another license. One alternative would be to license for
Standard on the IIS box instead of Enterprise if you don't need Enterprise
features.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> We currently have SERVER A which is just IIS for VS2002 applications(and
> some
> file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> running on one box? If so, what are the requirements? But doesn't RS
> 2000,
> need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?|||Thanks Bruce,
This helps! So Standard has RS and AS?
I have always heard that SQL db on IIS is not good. Is that a horsepower
issue?
Speaking of horse power, how would I find out what kind of power I would
need to have everything on one box(IIS, SQL DB, RS and AS)?
With a very limited budget, what configuration/distribution of apps would
you recommend(be it multi-server or big honkin' server)?
thanks,
Fred
"Bruce L-C [MVP]" wrote:
> There is nothing preventing you from having IIS on your SQL Server box. If
> you run it all on the same box it is free. Otherwise you are correct, you
> have to have another license. One alternative would be to license for
> Standard on the IIS box instead of Enterprise if you don't need Enterprise
> features.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> > We currently have SERVER A which is just IIS for VS2002 applications(and
> > some
> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> > running on one box? If so, what are the requirements? But doesn't RS
> > 2000,
> > need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> > would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?
>
>|||No, I was not talking about AS. I am just talking about whether you put RS
on the same box as your SQL Server. If your box is at least a
multi-processor box with a decent amount of RAM. I have a two processor, 2
Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
problem. The datamart is currently about 10 Gig (not that big although one
table in it is up to 80 million rows). How to size a server is a bit of an
art. It really depends on the amount of data, the amount of users, how is it
being used (oltp, datamart, etc). My own experience with SQL Server is it is
a pretty good citizen with how it uses RAM. It will take and give up RAM
depending on the load on the server. I don't have any experience with AS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> Thanks Bruce,
> This helps! So Standard has RS and AS?
> I have always heard that SQL db on IIS is not good. Is that a horsepower
> issue?
> Speaking of horse power, how would I find out what kind of power I would
> need to have everything on one box(IIS, SQL DB, RS and AS)?
> With a very limited budget, what configuration/distribution of apps
> would
> you recommend(be it multi-server or big honkin' server)?
> thanks,
> Fred
> "Bruce L-C [MVP]" wrote:
>> There is nothing preventing you from having IIS on your SQL Server box.
>> If
>> you run it all on the same box it is free. Otherwise you are correct, you
>> have to have another license. One alternative would be to license for
>> Standard on the IIS box instead of Enterprise if you don't need
>> Enterprise
>> features.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
>> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
>> > We currently have SERVER A which is just IIS for VS2002
>> > applications(and
>> > some
>> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
>> > would
>> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
>> > as)
>> > running on one box? If so, what are the requirements? But doesn't RS
>> > 2000,
>> > need IIS? Then I would need to install RS on SERVER A. But then
>> > SERVER A
>> > would need a SQL Enterprise licenses? So really, RS 2000 is not
>> > free?!?!?
>>|||Thanks again Bruce. This is very helpful. I will search the technet on SQL
OLAP for answers on AS.
Thanks,
Fred
"Bruce L-C [MVP]" wrote:
> No, I was not talking about AS. I am just talking about whether you put RS
> on the same box as your SQL Server. If your box is at least a
> multi-processor box with a decent amount of RAM. I have a two processor, 2
> Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
> problem. The datamart is currently about 10 Gig (not that big although one
> table in it is up to 80 million rows). How to size a server is a bit of an
> art. It really depends on the amount of data, the amount of users, how is it
> being used (oltp, datamart, etc). My own experience with SQL Server is it is
> a pretty good citizen with how it uses RAM. It will take and give up RAM
> depending on the load on the server. I don't have any experience with AS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> > Thanks Bruce,
> > This helps! So Standard has RS and AS?
> >
> > I have always heard that SQL db on IIS is not good. Is that a horsepower
> > issue?
> >
> > Speaking of horse power, how would I find out what kind of power I would
> > need to have everything on one box(IIS, SQL DB, RS and AS)?
> >
> > With a very limited budget, what configuration/distribution of apps
> > would
> > you recommend(be it multi-server or big honkin' server)?
> >
> > thanks,
> > Fred
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is nothing preventing you from having IIS on your SQL Server box.
> >> If
> >> you run it all on the same box it is free. Otherwise you are correct, you
> >> have to have another license. One alternative would be to license for
> >> Standard on the IIS box instead of Enterprise if you don't need
> >> Enterprise
> >> features.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> >> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> >> > We currently have SERVER A which is just IIS for VS2002
> >> > applications(and
> >> > some
> >> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
> >> > would
> >> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
> >> > as)
> >> > running on one box? If so, what are the requirements? But doesn't RS
> >> > 2000,
> >> > need IIS? Then I would need to install RS on SERVER A. But then
> >> > SERVER A
> >> > would need a SQL Enterprise licenses? So really, RS 2000 is not
> >> > free?!?!?
> >>
> >>
> >>
>
>