You install a SQL Server 2012 database engine instance on a production server. A month later, you install
SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project Deployment model.
Operations Log records that are outside the configured retention period must be cleaned automatically.
You need to create the SSIS catalog on the production server.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
Enable XP Command Shell.
B.
Enable CLR Integration.
C.
Enable OLE Automation.
D.
Start the SQL Server Browser service.
E.
Enable Cross Database Ownership Chaining
F.
Start the SQL Server Agent service
G.
Enable Ad Hoc Remote Queries.
Explanation:
Ref: http://msdn.microsoft.com/en-us/library/gg471509(v=sql.110).aspx
Only B is Correct. You don’t need Sql server Agent Service.
SSISDB maintenance goes via a job called: SSIS Server Maintenance job.
If the SQL Server Agent isn’t running, the maintenance won’t be performed automatically.
B + F are correct
DrsKafka – Thanks for explaining.