SQL Server Performance

if sql server service is not local admin what are the minimum permissions required?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Nov 2, 2013.

  1. Trev256b Member

    What are the minimum permissions required for sql server 2008 r2 and 2012. I want to implement the easiest simplest solution but still have the server working!!! There are a lot if complicated permissions ti add and i don't know how to assign these permissions to a domain account, so i can copy this account as a template fir other servers.
  2. catullus Member

    The installation process takes care of this. It grants the appropriate permissions to the service account you specify for SQL Server. So create a service account, don't give this account any permissions, log on to the server as an administrator and specify the service account during installation.This is easiest.

Share This Page