August 26, 2008 at 10:51 am
Are there problems with running sql server reporting services on the same server as the database server? Is this possible?
Please let me know any pros and cons of this?
I need to be prepared to address this with my infrastructure/security people.
Thank you in an advance.
August 26, 2008 at 11:31 am
Here are some pros:
1) Licensing - if they are on the same server, you only need one license.
2) Data does not need to be pulled over the network. If you have large data sets being rendered to reports, not having to transport the data over a NIC can be good.
3) Security is simplified. If you use NT Authentication, this allows you to use NTLM security rather than Kerberos - it is easier to configure and manage.
Some cons:
1) Performance is often hit because both processes are running on the same server. Distributing the rendering to another server can help.
2) Server configuration is more complicated because you must manage two applications sharing resources like memory, CPU, and disk IO.
3) You need to install and run IIS on your SQL Server - which is not necessary with just a base MSSQL Server.
4) Data is less secure. The pro of using NTLM security is also a con - it is less secure.
August 26, 2008 at 1:49 pm
Thank you very much. This is very helpful.
If anyone else has any information, please let me know.
Wilson Bell
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply