Tuesday, March 20, 2012

Best practices for an installation of SQL Server 2000 Reporting Se

Hi,
Where would one install SQL Service 2000 Reporting Services? I though about
installing them on a Web Server (with NO local SQL Server installed on) and
connection remote to a SQL Server 2000. Does this approach make sense?
I donâ't have a good feeling installing the Web Services on a Database Server
where I have to install IIS and the .NET Framework as well.
Best regards,
DanielThis will work fine. One point to keep in mind is that you have to have a
SQL Server license on the box with RS.
What I do is have SQL Server just for RS on the box. The data the reports
are based on reside on a different box. My feeling is why not have SQL
Server for the object caching that RS uses it for be on the same box. I have
to pay for it anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> Hi,
> Where would one install SQL Service 2000 Reporting Services? I though
> about
> installing them on a Web Server (with NO local SQL Server installed on)
> and
> connection remote to a SQL Server 2000. Does this approach make sense?
> I don't have a good feeling installing the Web Services on a Database
> Server
> where I have to install IIS and the .NET Framework as well.
> Best regards,
> Daniel|||Bruce,
Thanks for your answer! Just to make sure I got your point. You suggest to
have both (SQL Server and RS) installed on the same computer? Am I also right
that this constellation would only require on SQL Server license?
And one more question: Can RS be installed on a computer with NO SQL Server
installed? I had some troulbe installing RS on my Web Server where on SQL
Server is installed on. The installation skipped the part where I am supposed
to select the SQL Server but told me all is fine :-( This problem though
could have been caused by the Terminal Services which I had not disabled
(Will try tomorrow).
Thanks!
Daniel
"Bruce L-C [MVP]" wrote:
> This will work fine. One point to keep in mind is that you have to have a
> SQL Server license on the box with RS.
> What I do is have SQL Server just for RS on the box. The data the reports
> are based on reside on a different box. My feeling is why not have SQL
> Server for the object caching that RS uses it for be on the same box. I have
> to pay for it anyway.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> > Hi,
> >
> > Where would one install SQL Service 2000 Reporting Services? I though
> > about
> > installing them on a Web Server (with NO local SQL Server installed on)
> > and
> > connection remote to a SQL Server 2000. Does this approach make sense?
> >
> > I don't have a good feeling installing the Web Services on a Database
> > Server
> > where I have to install IIS and the .NET Framework as well.
> >
> > Best regards,
> >
> > Daniel
>
>|||From a licensing perspective there is no difference. You have to have a SQL
Server license for the box that has Reporting Services. Reporting Services
uses SQL Server for it's object storage. For instance, all reports are
stored in the database. You will not see any rdl files on the server. It
uses SQL Server for other objects as well. So, RS has to have SQL Server
somewhere. If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found. I have not done this myself. I assume the
info on how to do this is in the readme. If you use the setup program it
plans that SQL Server is on the box you are installing RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
> Bruce,
> Thanks for your answer! Just to make sure I got your point. You suggest to
> have both (SQL Server and RS) installed on the same computer? Am I also
> right
> that this constellation would only require on SQL Server license?
> And one more question: Can RS be installed on a computer with NO SQL
> Server
> installed? I had some troulbe installing RS on my Web Server where on SQL
> Server is installed on. The installation skipped the part where I am
> supposed
> to select the SQL Server but told me all is fine :-( This problem though
> could have been caused by the Terminal Services which I had not disabled
> (Will try tomorrow).
> Thanks!
> Daniel
>
> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>|||Thank you Bruce,
this is good to know!
Daniel
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:%238AtkHJYFHA.2796@.TK2MSFTNGP09.phx.gbl...
> From a licensing perspective there is no difference. You have to have a
> SQL Server license for the box that has Reporting Services. Reporting
> Services uses SQL Server for it's object storage. For instance, all
> reports are stored in the database. You will not see any rdl files on the
> server. It uses SQL Server for other objects as well. So, RS has to have
> SQL Server somewhere. If you use a SQL Server that is somewhere other than
> the box you are installing RS on you have to use the command line install
> and specify where SQL Server can be found. I have not done this myself. I
> assume the info on how to do this is in the readme. If you use the setup
> program it plans that SQL Server is on the box you are installing RS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
>> Bruce,
>> Thanks for your answer! Just to make sure I got your point. You suggest
>> to
>> have both (SQL Server and RS) installed on the same computer? Am I also
>> right
>> that this constellation would only require on SQL Server license?
>> And one more question: Can RS be installed on a computer with NO SQL
>> Server
>> installed? I had some troulbe installing RS on my Web Server where on SQL
>> Server is installed on. The installation skipped the part where I am
>> supposed
>> to select the SQL Server but told me all is fine :-( This problem though
>> could have been caused by the Terminal Services which I had not disabled
>> (Will try tomorrow).
>> Thanks!
>> Daniel
>>
>> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have
>> a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the
>> reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in
>> message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed
>> > on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>
>|||" If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found."-Bruce
Are you absolutely 100% certain this is the case?
I'm certainly stuck trying to install enterprise RS on the web server
pointing to a SQL server DB on another sql server(2000). Problem is the
install ends "successfully" but then throws an activivation error. No
resolution for this error in sight.
However if I MUST use the commend line too to configure RS across servers
this may explain the activiation error. I don't remember finding anything
documented telling me I must use this command line approach.
Please verify this is true. Thanks! Could save a lot of headaches...

No comments:

Post a Comment