Re: SQL Agent Proxy Account

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/03/04


Date: Wed, 3 Mar 2004 17:12:37 +0100

Right-click the server, properties, security.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mlewis@awwa.org> wrote in message
news:635501c40139$256d4be0$a001280a@phx.gbl...
> I apologize in advance for the stupid question that I'm
> going to ask, but how do I change the account for
> MSSQLServer service in SQL Enterprise Manager?
>
> >-----Original Message-----
> >Sue, that was it!
> >
> >Originally, I didn't use the Enterprise Manager to change
> the account; I set the account through the Computer
> Management, Services. I just swapped both services to run
> as Local System account, and then changed it to the domain
> account I wanted through the SQL Enterprise Manager. You
> can see the additional privileges being assigned to the
> account (Policy Change events in the Security Log). Note
> that it didn't work right away, but after the reboot, I
> had no problems setting the SQL Agent Proxy Account to the
> account I wanted.
> >
> >Your help is greatly appreciated!!!
> >
> >.
> >


Relevant Pages

  • [NEWS] Xpede Found to Contain Multiple Vulnerabilities
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Intellisol Xpede ... anyone with a valid Xpede user account to issue requests to the Xpede's ... name used by Xpede to perform all its SQL queries. ...
    (Securiteam)
  • Re: ASP.NET Process Identity???
    ... In the application I not need/want to create user accounts into SQL Server. ... To control the security I have created a personalized security system. ... you can switch back to normal ASPNET machine account for the ... >> Public Class Personificacion ...
    (microsoft.public.dotnet.security)
  • Re: Windows vs SQL
    ... I would also add that with the sql security, ... account is a "known" entity in that a hacker knows that it exists and there ... >>> im always hearing that ms recommends trusted security ...
    (microsoft.public.sqlserver.security)
  • Re: SMS reinstall
    ... In the security logins node from SQL Enterprise manager do you have ... If so can you add the account to the local ...
    (microsoft.public.sms.setup)
  • Re: How to use EFS to encrypt SQL DB file
    ... You want to make sure that SQL is starting here with an ... account that has the right to decrypt the mdf file. ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)