Re: Error runnig xp_sqlagent_proxy_account

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 08/21/03 

Date: Thu, 21 Aug 2003 10:32:27 -0500

This error message may indicate a problem with the SQL Server service
account permissions. Using Enterprise Manager, change the SQL Server
service account to the system account and then back to the domain
account. This will grant the domain account the needed rights. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"srgr_100" <srgr_100@hotmail.com> wrote in message
news:0d9a01c367f6$7f1d2ca0$a501280a@phx.gbl...
> Hi,
>
> I've been tryin to set the SQL Agent proxy account using
> both the xp_sqlagent_proxy_account ESP and the EM
> interface, and I always get the following message:
> "Error executing extended stored procedure: Specified user
> can not login"
>
> I have tried with different user but nothing. The box is a
> SQL Server 2000 Enterprise Edition with SP3. I have been
> able to set the proxy in other boxes, but not on this one
> and I see no difference in the way this server was set up.
> Can anyone give me some ideas.
>
> Thank you,
>
> srgr_100
>

Relevant Pages

  • Re: Installation - What Account is needed?
    ... Because, when you change your SQL Server' s service account's password from your Active Directory, it won't be updated automatically at the SQL Server server and when your SQL Server service restarts, it'd compain about the wrong password. ... it does not mean your SQL Server services have to be running under the account which you installed the mentioned SQL Server instance. ... I understand you are asking about the required account to install a SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: xpsql.cpp
    ... The SQL Server service account also needs the rights below. ... > SQLAgentCmdExec login in EM and restarting SQL Server can help. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot connect to Query Analyzer
    ... On the account, Try adding the local account you created to ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect to Query Analyzer
    ... On the account, Try adding the local account you created to ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
Loading