<div>
<div class="content wysiwyg-content">
I am building a SQL Server 2005 machine to primarily handle running SQL scheduled tasks to take the load off of our other production SQL servers. It will be built with SQL2005 Standard Edition. &nbsp;Im trying to figure out which components to install that may be helpful to us.<br />
<br />
These are the components available:<br />
<br />
SQL Server Database Services<br />
Analysis Services<br />
Reporting Services<br />
Notification Services<br />
Integration Services<br />
Workstation components, Books Online, and Development Tools<br />
<br />
We are not going to install Reporting Services but Im wondering about the Integration Services and Notification Services. &nbsp;Can someone please shed some light on these two services and let me know if it would be beneficial to install Integration Services and or Notification Services? A nutshell summary of the benefits of each component would be appreciated.<br />

</div>
</div>


I am building a SQL Server 2005 machine to primarily handle running SQL scheduled tasks to take the load off of our other production SQL servers. It will be built with SQL2005 Standard Edition.  Im trying to figure out which components to install that may be helpful to us.

These are the components available:

SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation components, Books Online, and Development Tools

We are not going to install Reporting Services but Im wondering about the Integration Services and Notification Services.  Can someone please shed some light on these two services and let me know if it would be beneficial to install Integration Services and or Notification Services? A nutshell summary of the benefits of each component would be appreciated.


Help Needed on Which SQL Server 2005 Components to Install

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.