Policy settings for MS SQL Service accounts

  • Hello,

    I've got request from my collegues from Windows Support to set up interactive logon restriction for all SQL Server Service accounts. I've searched google a lot but couldn't find any information how this change will impact SQL Server in my company. Any thoughts?

    Thanks,

    MCP ID# 1115468 Ceritified Since 1998
    MCP, MCSE, MCP+I, MCSE+I, MCSA,
    MCDBA SQL7.0 SQL 2000, MCTS SQL 2005

  • Inteactive logon restriction does not impact SQL Server.

    Becuase SQL Server is a service.

    Services don't need interactive logon previlage.

  • Thanks for confirmation. I wasn't sure and had no enough time for proper testing.

    MCP ID# 1115468 Ceritified Since 1998
    MCP, MCSE, MCP+I, MCSE+I, MCSA,
    MCDBA SQL7.0 SQL 2000, MCTS SQL 2005

Viewing 3 posts - 1 through 2 (of 2 total)

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