Starting Service with SQL Authentication

From: Neil W. (neilw.nospam_at_netlib.com)
Date: 07/25/03 

Date: Fri, 25 Jul 2003 14:32:56 -0400

I guess I should know this, but ... Using SQL 2000 lets say I allow only
SQL Authentication and delete all builtin/administrators. I also change the
SA password to something only a couple of people know. Then I modify the
service so that it is started by a normal domain user (doesn't have the SA
password). Does that domain user need to have SQL admin rights in order to
start the service? If not, what SQL rights, if any, does he need.

Thanks!

Relevant Pages

  • Re: Backup to NAS storage
    ... You can run the SQL service under a domain user account that has local admin ... rights need configured for a domain user in order for SQL Server to function ... you can set the security on the NAS to allow ...
    (microsoft.public.sqlserver.setup)
  • Re: SMS Backup Task
    ... > domain user, it is more supposed to be more secure. ... > testing here that SMS does not support SQL running as a domain user ... >> Is your SQL Server service account a local administrator on the server? ...
    (microsoft.public.sms.admin)
  • Re: SMS Backup Task
    ... domain user, it is more supposed to be more secure. ... testing here that SMS does not support SQL running as a domain user account ... > Is your SQL Server service account a local administrator on the server? ...
    (microsoft.public.sms.admin)
  • Re: Starting Service with SQL Authentication
    ... sqlagent or if you want to use extended stored procedures or anything else ... Using SQL 2000 lets say I allow only ... > service so that it is started by a normal domain user (doesn't have the SA ... Does that domain user need to have SQL admin rights in order ...
    (microsoft.public.sqlserver.security)
  • SQL Server Authentication Question (easy I think)
    ... 'I assigned a domain user as the SQL username as ... and 'User1' SQL Server account. ... into a local administrators group of the SQL Server ...
    (microsoft.public.sqlserver.server)