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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-08-21 : 15:13:05
|
| Is it good to have Reporting Services on seperate server to avoid performance promblems or it really doesn't matter (sql server and reporting server on same server) as long as the server have enough memory?Thanks ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-21 : 16:10:45
|
| Yes it is recommended to have it on a separate server, but it does mean you have to pay for a license.Same goes for Analysis Services and Notification Services.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-08-21 : 17:03:36
|
| When you say pay for a license..can you explain in more detail about it.... I am newbie...Thanks ! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-21 : 18:15:40
|
| Check out the licensing information on the Microsoft site. Reporting Services is only free when it is installed on the server where SQL Server exists. In this situation, you only have to pay for a SQL Server server license. When you install Reporting Services on a separate server for performance reasons, you must purchase a SQL Server server license plus an RS license.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Seperate Server for Reporting?