SQL Server Performance Forum – Threads Archive

SQL Server service account

Hi guys, Does anyone know the reason why after adding sql server service account to the local administrators group of any server, it is also added as a sql server login in enterprise manager. I know its not much of a bright question I just can’t get my head round it right now. cheers M

Hi ya, It shouldn’t get added as the result of adding the service account to the local admins group, but will get added if in Enterprise Manager you set the service account to that user Cheers
Twan

CHeck if the BUILTIN/ADMINISTRATORs group has access on SQL then it will be added to the SQL too. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

That is my question, Builtin/admin. has default access and so i want to know why sql server service account is also added as an account with sa rights just like builtin/admin.

One of the BOL topic covers:
If the startup account assigned to the MSSQLServer Service is not a member of the Local Administrators group, or if the BUILTINAdministrators SQL Server login has been removed, you must add the startup account for the MSSQLServer service or the SQLServerAgent service, or both, to the SQL Server system administrators (sysadmin) role. Grant the [DomainNTaccount] user a logon to SQL Server. So in your case by default if you enable service account as a local admin then because of Builtin/Adminsitrator enabled it will be added to SQL logins as well, by all means I don’t see any problem here. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>