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

  • 2012年3月14日 0:42
     
     

    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

    • 移動 Tom Phillips 2012年3月14日 15:24 SQL 2012 question (From:SQL Server Database Engine)
    •  

すべての返信

  • 2012年3月14日 1:39
     
     回答の候補

    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.

  • 2012年3月17日 20:18
     
     回答の候補

    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