Administering Core Business Intelligence Services - Microsoft SQL Server 2008 R2 Administration - page 165

13. You can assign the same login account to all SQL Server services, or you can
configure each service account individually.
14. This account must be a Windows Domain User account. Built-in machine accounts
(such as Network Service, or Local Service) are prohibited.
15. Choose the SQL Server Administrators for SSIS service, click Add Current User and
you can also add any other user to assign SYSADMIN privileges.
16. You can only install a single instance of Integration Services; the service is not
specific to a particular instance of the database engine.
17. You can connect to the service by using the name of the computer.
By default, the Integration Services is
configured to store packages in MSDB
system database.
18. On a 64-bit environment, when you install SQL Server and select Integration Services
for installation, Setup installs 64-bit Integration Services features and tools.
64-bit features are installed under the Program Files directory, and 32-bit
features are installed separately under the Program Files ( x86 ) directory
19. The System Configuration Checker will run an additional set of rules to validate the
server configuration with the SQL Server features that you have specified.
20. The Ready to Install page shows a tree view of installation options that were
specified during Setup. Now, click Install to continue.
21. At this point, the installation should proceed as planned. Unless some unexpected
error occurs, the process should have a working instance of SSIS deployed on your
machine, along with SQL Server.
22. After installation, the Complete page provides a link to the summary log file for the
installation and other important notes.
23. Make sure you review the summary of installation log file from the %Program
Files%\Microsoft SQL Server\110\Setup Bootstrap\Log folder to ensure
no errors are reported.
If you are instructed to restart the computer, do so now.
It is important to read and follow the message from the
Installation Wizard when you have finished running the Setup.
Now, we have the Integration Services installation complete, and ready to manage the ETL
processes using BIDS and SSMS tools.