Permision settings - Non-SysAdmins

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 07:21:36 -0800

If you make sure the sql server agent startup account is
in the sysadmin role, or use the same domain user account
as is used for sql server it should be ok.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Relevant Pages

  • Re: Confused...SA Account
    ... Is the SQL Server Agent startup account a member of the local admin group ... If you are using SQL Server authentication for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Restricting Access priviledge on SQL2000
    ... You must have made the "Application-Administrators" members of the sysadmin role in SQL Server. ... Take them out of the sysadmin role, add them as users in the correct database, then make them members of the db_owner role in that database. ...
    (microsoft.public.sqlserver.security)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Linked Server Connection Error: 18459
    ... Did either of your SQL Server instances run under a domain user account? ... I recommend that you first ensure that your SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Getting the sa password with SQLDMO
    ... SQL Server stores passwords using a one-way hash so you can't read the ... conditional password change by attempting a connection using the expected sa ... password and, if it fails, connect using a different sysadmin role member ... member can change the sa password. ...
    (microsoft.public.sqlserver.programming)