Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
titan68
Starting Member
2 Posts |
 Posted - 2005-04-26 : 18:06:29
|
| I want to know what kind of hardware configuration I need to deploy SQL Reporting Services reports on the web as well as any licenses I will need to purchase to be legal. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-26 : 23:54:21
|
| Hardware configuration of course depends on how much capacity you need from the installation. We'll need more information. Licensing is the same as SQL Server. You will need to pay standard or enterprise SQL Server license cost per CPU if it's accessible by the web. If it's on the same box as SQL Server, there is no additional cost.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
titan68
Starting Member
2 Posts |
Posted - 2005-04-27 : 11:36:16
|
| I am trying to find out what the best practices are for deploying reporting services reports over the web. We have a client that is going to be doing this. I am not sure what their capacity demands are. But as a baseline I would like to know what the minimum number of servers and licenses necessary to deploy reporting services reports on the web. I have never used reporting services before. I know that the reports are going to be referenced from a web application. Is reporting services installed on the same box as IIS or dose it go on a separate server? I called Microsoft to try and get an idea of how many licenses we are going to need and one person said I would need a processor license for the SQL Server system and the system that has SQL Server Reporting Services installed on it. I call back with more questions and the second person I talked to told me that in addition to the processor licenses for the SQL Server and Reporting Services systems you needed an “external connector license”. I am trying to find out how to do this for minimum cost. I know they are using SQL Server 2000 standard edition.Thanks |
|
|
|
spark58510
Starting Member
4 Posts |
Posted - 2005-04-28 : 09:20:32
|
| I've not heard of an external connector license. As far as I know, reporting service licensing is free with SQL Server. For example, with SQL 2000 Enterprise, you get a license for Rpt Services Enterprise, Standard with Standard, and so on. Rpt Services installs as a virtual directory on IIS. You will need to install it on your SQL box and install IIS on the same box. |
|
|
|
|
|
|
Deploying SQL Reporting Services on the Web