I'm trying to find out when a SQL server installation grants permissions on the OS.
I know that the following permissions are giving during setup msdn article about permissions.
However what I don't know is how SQL server will react if the permissions are there, but granted through a group. My problem is that the OS group policies do not allow for several of the required permissions to be granted. And we are going to add the users to a group, that is then included in the group policy.
Will SQL server correctly detect that the required permissions are present, and skip adding the users individually? Or will the installation end on error because it can not grant the required privileges?
We're planning to test this soon, however due to time constraints I was hoping some-one here has experience with this issue, and can give me an answer.
Update: I'm quickly adding some information in the hopes that someone can explain the observed behavior to me...
We are able to install SQL server, despite group policies preventing nearly all the permissions mentioned in the before linked MSDN article. However if we then try and run an SSIS package, or certain server wide jobs, we receive the error that SQL Server lacks the required privileges.
Why was SQL Server able to install, without error even, despite not being able to add the sql server agent and service users to the User Right policies it needs according to the MSDN documentation?
Currently SQL Server is running, despite the user not having local permissions, and not having the Log on as a service permissions... Am I wrong in my understanding of why these permissions are required?