none
The ideal startup type of various SQL Server services

    Question

  • Hi,

    What is the ideal startup type for the following services?

    SQL Server Browser service in Cluster - Automatic/Manual??

    SQL Server Integration Service in Cluster - Automatic/Manual??

    SQL Server Analysis Service in Cluster - Automatic/Manual??

    If I am correct none of the above services are cluster-aware, right? Also please let me know how the above services should be in both active node as well as passive node.

    Regards and Thanks,

    Shanoof

    Saturday, October 12, 2013 3:11 AM

Answers

  • Hello Shanoof,

    Analysis service is cluster aware .Also enabling service on cluster totally depends on your requirement if you dont require them please keep it in disabled mode.You can enable them in future if you require.

    Reg browser service as a security measure it is advised to keep it disabled.But if you application is configured to listen on different port with multiple instance this needs to be enabled otherwsie connection to SQL will be refused

    More details about browser service in below link

    http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 12, 2013 6:32 AM