Re: SQL Agent Proxy Account

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 08:37:38 -0800

Thanks Tibor,

I'll try that and see if it clears up my problem.

>-----Original Message-----
>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: 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)
  • Re: Microsoft Informational Alert
    ... > PSS Security Response Team Alert - SQL Security Recommendations ... > PRODUCTS AFFECTED: SQL Server ... Secure your SA login account with a non-NULL password. ...
    (microsoft.public.security)