Post reply

In a cluster sqlserver service and sql server agent service should be automatic or manual.

  • December 12, 2011 at 4:42 am

    #264728

    In a cluster sqlserver service and sql server agent service should be automatic or manual.

    Thanks

  • December 12, 2011 at 5:08 am

    #1419956

    forsqlserver (12/12/2011)

    In a cluster sqlserver service and sql server agent service should be automatic or manual.

    They should be automatic, so that should any server restart occur due to any reason, they can come online automatically.

    Sujeet Singh

  • December 12, 2011 at 5:08 am

    #1419958

    Your answer is here.

    http://msdn.microsoft.com/en-us/library/ms143504.aspx

  • December 12, 2011 at 5:10 am

    #1419961

    Divine Flame (12/12/2011)

    forsqlserver (12/12/2011)

    In a cluster sqlserver service and sql server agent service should be automatic or manual.

    They should be automatic, so that should any server restart occur due to any reason, they can come online automatically.

    Nope. per BOL:

    For failover cluster configurations, use the domain user account and the start up type is set to manual..

  • December 12, 2011 at 5:16 am

    #1419964

    Thanks dev...But I am not finding it clearly in the doc..

    Thanks

  • December 12, 2011 at 5:19 am

    #1419966

    forsqlserver (12/12/2011)

    Thanks dev...But I am not finding it clearly in the doc..

    Please search for 'Automatic1' in that article. 😉

  • December 12, 2011 at 5:19 am

    #1419967

    I have got it

    Thanks

  • December 12, 2011 at 5:41 am

    #1419975

    Nope. per BOL:

    For failover cluster configurations, use the domain user account and the start up type is set to manual..

    I missed the "cluster" word completly & thought he (OP) is asking in general like standalone server. My bad :cool:.

    Sujeet Singh

  • December 12, 2011 at 5:45 am

    #1419979

    Divine Flame (12/12/2011)

    Nope. per BOL:

    For failover cluster configurations, use the domain user account and the start up type is set to manual..

    I missed the "cluster" word completly & thought he (OP) is asking in general like standalone server. My bad :cool:.

    It’s OK. It happens sometimes 😉

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply