Re: [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 87 from GetProxyAccount on line 604

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 01/28/03 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Tue, 28 Jan 2003 08:45:15 -0600

Check to ensure the 'Only users with sysadmin privleges ...' box is
unchecked from Enterprise Manager (Management\SQL Server
Agent\Properties\Job System). I've been able to repro the error when
the box is checked. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Darren Taft" <darren.taft@bt.com.removeme> wrote in message
news:u2#YJGtxCHA.364@TK2MSFTNGP12...
> Dan Guzman wrote:
> > I haven't seen this particular error but a common cause of
> > non-sysadmin xp_cmdshell problems is when the proxy account is not
> > set properly or the SQL Server service account doesn't have the
> > permissions necessary to switch security context.
> >
> > Try resetting the proxy account with xp_sqlagent_proxy_account:
> >
> > EXEC xp_sqlagent_proxy_account
> >     N'SET',
> >     N'MyDomain',
> >     N'MyUser',
> >     N'MyPassword'
> >
> > Also, check to ensure the SQL Server service account has 'Act as
part
> > of operating system' and 'Replace a process level token' user
rights.
>
> Dan,
>
> I'm also getting this error now that I've applied SP3.  I'm doing a
very
> simple call to xp_cmdshell, and everything was running fine before I
applied
> SP3.
>
> I've tried doing as above and that hasn't helped.
>
> Any other ideas?
>
> darren
>
>

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)