SQL Server Performance

Nightmare scenario - can't start sql server after running sqlservr.exe -c -m -T3608

Discussion in 'General DBA Questions' started by Trev256, Sep 24, 2007.

Page 2 of 2

  1. Trev256 New Member

    Turns out the service account did not have access on the new disk where the databases were moved to. What access should the service account have to ensure everything is moving smoothly.
    I am moving all databases to a new drive. Can you think of anything else that needs to be moved?
    Thanks
    Trev256, Sep 26, 2007
    #21

  2. satya Moderator

    Scary eh?
    The Service account should have FULL CONTROL on the drive where you are going to keep these data files, that is a default operation. Also the SQL Server service account should be a local admin on the server in order to avoid these petty issues.
    satya, Sep 26, 2007
    #22

  3. Trev256 New Member

    Thanks. Normally I setup the service account as local admin on the machine. Can you think of any valid reason why anyone would not want to do this and restrict the access to less?
    Thanks
    Trev256, Sep 28, 2007
    #23

  4. satya Moderator

    Oversight or any specific security policy within your organisation.
    Fro the Cluster environment it is must to have a local admin privileges.
    satya, Sep 28, 2007
    #24
Page 2 of 2

Share This Page