Re: SQL Service Accounts

From: Richard Waymire [MS] (rwaymi_ms@microsoft.com)
Date: 10/29/02 

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Tue, 29 Oct 2002 10:07:22 -0800

If the user is not a sysadmin then they'll probably need access to a proxy
account - you can configure that on the server properties -> security tab in
Enterprise manager. 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Andryszak" <danandryszak@yahoo.com> wrote in message
news:10f9201c27ee7$904a78a0$2ae2c90a@phx.gbl...
> I started a new job and am responsible for the "care and
> feeding" of SQL Server 2000. I have performed rudimentary
> DBA tasks at prior jobs, so I'm not a complete novice.
>
> Currently, all of the SQL Server service accounts
> (SQLServer and SQLAgent) are using the local system
> account and the servers are set for mixed security.
> Typically, I have always used a domain account that has
> local administrator priviligies in the SQL Server.
>
> I want to use the Maintenance Wizard to setup DBCC and
> Backup jobs, but I want to make sure that I don't "break"
> anything.
>
> I modified one SQL Server to use a domain account for the
> services and the Maintenance Plan executed fine, but I
> noticed (in the event viewer) that another user's
> scheduled jobs failed. What database role does the domain
> account need to operate properly?

Relevant Pages

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)