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 |
|
mmarovic
Aged Yak Warrior
518 Posts |
 Posted - 2005-07-24 : 15:07:01
|
| Hello gurus!My company needs kind of report server. I would like to know what hardware and software we have to buy to implement reporting services.Requirements are:1. Availability 24x72. Up to 500 report consumers3. 1-2 report designers.My guess is that we need:1. MSSQL Server Enterprise edition X 4 processor licenses2. Production MSSQL server on cluster with all server side report server components installed there3. Hot-swap mssql server with report server db on it.4. Workstation with report designer installed there.5. C# or vb.net installed on workstation6. Windows 2003 server x 4 processor licenses?7. Windows XP professional on workstation?Please let me know if I forgot something or I was wrong about something, especially if I forgot something that have to be paid. |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-24 : 22:25:48
|
I would seperate the report server from the db server, if you combine both it is a heavy load taking requests from the client application as well as the stored procedures / queries that access data from the report.Especially if you plan to use a lot of advanced reports that have a lot of datasets (which may be in fact used for parameters). Each dataset has to SELECT the data it needs from the report server.I dont understand what you mean by C# or vb.net installed on each workstation. For what purpose? The developers or for the users? If the latter you don't need either. Doesn't matter what OS you use on the client PC, as long as it's win 2k.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-07-25 : 05:19:08
|
| Thanks for the instant answer.The plan is to have one-two developers (one one-two workstations) creating reports.Mirko. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-07-25 : 08:19:44
|
So you will need either visual studio.net or some 3rd party tool to develop the reports. Each client must have a seperate licensed copy of vs.net. BTW rs is free if you are placing it on the same box as your sql server. This is not recommended due to performance related issues.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-07-25 : 09:22:48
|
| I think we will start with everything on one server just to show business people concept and its advantages, then we will ask for more. It is agreed to be pilot installation anyway. |
|
|
|
|
|
|
Buyers guide