locked
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

    • Déplacé Tom Phillips mercredi 14 mars 2012 15:24 SQL 2012 question (From:SQL Server Database Engine)
    mercredi 14 mars 2012 00:42

Toutes les réponses

  • 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.

    mercredi 14 mars 2012 01:39
  • 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 

    samedi 17 mars 2012 20:18