|
|
You're in the
sql server reporting services
group:RS - Planning Question
sql server reporting services:
We're looking to implement Reporting Services in our environment. We currently have a couple of high-end SQL Server boxes with relatively low usage. I'm considering installing Reporting Services on one of these SQL Server boxes or installing Reporting Services on another box isolated to RS that would point to one of these existing SQL Servers. All boxes are dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD space. Are there any performance issues I should be aware of or possibly licensing issues with installing RS on a seperate SQL Server? Thanks Jerry
Last sentence should be ...RS on a seperate server (not a SQL Server).
Thanks Jerry [quoted text, click to view] "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message news:ey%23ulmHuFHA.3864@TK2MSFTNGP12.phx.gbl... > Hi, > > We're looking to implement Reporting Services in our environment. We > currently have a couple of high-end SQL Server boxes with relatively low > usage. I'm considering installing Reporting Services on one of these SQL > Server boxes or installing Reporting Services on another box isolated to > RS that would point to one of these existing SQL Servers. All boxes are > dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD space. Are there > any performance issues I should be aware of or possibly licensing issues > with installing RS on a seperate SQL Server? > > Thanks > > Jerry >
Bruce,
Are you saying that if I install RS on a stand alone box (w/o SQL Server) and point it to another SQL Server to store the ReportServer and ReportServerTempDB databases that I'm required to have a SQL Server license for the box running RS? Are you refering to a SQL Server cal license or a per CPU license (costing thousands)? Thanks Jerry [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:OfhA%23wHuFHA.2624@TK2MSFTNGP12.phx.gbl... > Every box that RS is on has to have a SQL Server license whether or not > the database resides on it or not. > > If it is a low usage server I'd say give it a try. First off, it is a lot > cheaper. I currently have a datamart that I have done that with (both RS > and SQL Server on one server). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message > news:ey%23ulmHuFHA.3864@TK2MSFTNGP12.phx.gbl... >> Hi, >> >> We're looking to implement Reporting Services in our environment. We >> currently have a couple of high-end SQL Server boxes with relatively low >> usage. I'm considering installing Reporting Services on one of these SQL >> Server boxes or installing Reporting Services on another box isolated to >> RS that would point to one of these existing SQL Servers. All boxes are >> dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD space. Are >> there any performance issues I should be aware of or possibly licensing >> issues with installing RS on a seperate SQL Server? >> >> Thanks >> >> Jerry >> > >
Thanks Bruce.
The "explanation" makes sense now. Here are a couple of useful links I ran across for future reference on subsequent reads of this thread: RS Deployment Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx#EEAA RS Licensing FAQ http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx How to License RS http://www.microsoft.com/sql/reporting/howtobuy/howtolicensers.mspx Jerry [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:O69Iu8HuFHA.2076@TK2MSFTNGP14.phx.gbl... > As far as licensing is concerned installing RS on a server is the same as > installing the DB. I had it explained to me this way. You can buy MS > Office which has Word, Excel, Powerpoint etc. You can't install Word on > one PC, Excel on another and Powerpoint on a third without > paying/licensing it. > > SQL Server is not a suite of products: Database, Analysis Services, > Reporting Services. Same rule holds for RS as for Analysis Services. I.e. > you install on another machine you need a license. > > What you need for it depends on your environment. If you are reporting > over the internet I believe you have to do per processor (just a guess). > In an intranet environment it depends on how you have licenses. In my case > all PCs in our compnay have a CAL to connect to any database we have. So I > just buy a server license and I have no additional CALS to buy. The > easiest way to think about this is your licensing is exactly the same as > if you were adding another database server. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message > news:%2325gz2HuFHA.908@tk2msftngp13.phx.gbl... >> Bruce, >> >> Are you saying that if I install RS on a stand alone box (w/o SQL Server) >> and point it to another SQL Server to store the ReportServer and >> ReportServerTempDB databases that I'm required to have a SQL Server >> license for the box running RS? Are you refering to a SQL Server cal >> license or a per CPU license (costing thousands)? >> >> Thanks >> >> Jerry >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> news:OfhA%23wHuFHA.2624@TK2MSFTNGP12.phx.gbl... >>> Every box that RS is on has to have a SQL Server license whether or not >>> the database resides on it or not. >>> >>> If it is a low usage server I'd say give it a try. First off, it is a >>> lot cheaper. I currently have a datamart that I have done that with >>> (both RS and SQL Server on one server). >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message >>> news:ey%23ulmHuFHA.3864@TK2MSFTNGP12.phx.gbl... >>>> Hi, >>>> >>>> We're looking to implement Reporting Services in our environment. We >>>> currently have a couple of high-end SQL Server boxes with relatively >>>> low usage. I'm considering installing Reporting Services on one of >>>> these SQL Server boxes or installing Reporting Services on another box >>>> isolated to RS that would point to one of these existing SQL Servers. >>>> All boxes are dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD >>>> space. Are there any performance issues I should be aware of or >>>> possibly licensing issues with installing RS on a seperate SQL Server? >>>> >>>> Thanks >>>> >>>> Jerry >>>> >>> >>> >> >> > >
Every box that RS is on has to have a SQL Server license whether or not the
database resides on it or not. If it is a low usage server I'd say give it a try. First off, it is a lot cheaper. I currently have a datamart that I have done that with (both RS and SQL Server on one server). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message news:ey%23ulmHuFHA.3864@TK2MSFTNGP12.phx.gbl... > Hi, > > We're looking to implement Reporting Services in our environment. We > currently have a couple of high-end SQL Server boxes with relatively low > usage. I'm considering installing Reporting Services on one of these SQL > Server boxes or installing Reporting Services on another box isolated to > RS that would point to one of these existing SQL Servers. All boxes are > dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD space. Are there > any performance issues I should be aware of or possibly licensing issues > with installing RS on a seperate SQL Server? > > Thanks > > Jerry >
As far as licensing is concerned installing RS on a server is the same as
installing the DB. I had it explained to me this way. You can buy MS Office which has Word, Excel, Powerpoint etc. You can't install Word on one PC, Excel on another and Powerpoint on a third without paying/licensing it. SQL Server is not a suite of products: Database, Analysis Services, Reporting Services. Same rule holds for RS as for Analysis Services. I.e. you install on another machine you need a license. What you need for it depends on your environment. If you are reporting over the internet I believe you have to do per processor (just a guess). In an intranet environment it depends on how you have licenses. In my case all PCs in our compnay have a CAL to connect to any database we have. So I just buy a server license and I have no additional CALS to buy. The easiest way to think about this is your licensing is exactly the same as if you were adding another database server. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message news:%2325gz2HuFHA.908@tk2msftngp13.phx.gbl... > Bruce, > > Are you saying that if I install RS on a stand alone box (w/o SQL Server) > and point it to another SQL Server to store the ReportServer and > ReportServerTempDB databases that I'm required to have a SQL Server > license for the box running RS? Are you refering to a SQL Server cal > license or a per CPU license (costing thousands)? > > Thanks > > Jerry > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:OfhA%23wHuFHA.2624@TK2MSFTNGP12.phx.gbl... >> Every box that RS is on has to have a SQL Server license whether or not >> the database resides on it or not. >> >> If it is a low usage server I'd say give it a try. First off, it is a lot >> cheaper. I currently have a datamart that I have done that with (both RS >> and SQL Server on one server). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message >> news:ey%23ulmHuFHA.3864@TK2MSFTNGP12.phx.gbl... >>> Hi, >>> >>> We're looking to implement Reporting Services in our environment. We >>> currently have a couple of high-end SQL Server boxes with relatively low >>> usage. I'm considering installing Reporting Services on one of these >>> SQL Server boxes or installing Reporting Services on another box >>> isolated to RS that would point to one of these existing SQL Servers. >>> All boxes are dual-proc 3 GHz or higher with 2 GB-3GB RAM and ample HD >>> space. Are there any performance issues I should be aware of or >>> possibly licensing issues with installing RS on a seperate SQL Server? >>> >>> Thanks >>> >>> Jerry >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |