Install SQL Server 2012 on Server Core, what about sql agent

Question

after checking the link Install SQL Server 2012 on Server Core I still have below 2 questions

When sql 2012 is installed on windows core is sql agent also installed with it?

Can integration services packages be executed on the server?

Thank you

---

Gokhan Varol

Answer 1

Yes,Agent will be there.

Integration services is also supported.

Thank you,

---

Anup | Database Consultant

Blog: www.sqlsailor.com Twitter: Follow me !

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Hi Gokhal,

When you install SQL Server 2012 on Server Core, SQL Server Agent is installed. Also, SQL Server Integration Services installation is available on Server Core.

Moreover, you can use the dtexec command prompt utility to configure and execute an Integration Services package. Detailed information available here.

Thanks,
Vivek
SQL Server User Education