Re: cannot deliver sp_repldropcolum schema change

I don't think db_owner is enough in your case. I haven't tested this, but it
makes sense to me that if this login is not part of the sysadmin server role
then the proxy account is required, which isn't configured on your system. I
am familiar with the proxy running for jobs, but you are using an activex
control. Even so, it might be worth testing this. You have the system
working when you use a sysadmin - now use the original login, but first add
a proxy account that is a local administrator and see if this works:

EXEC master.dbo.xp_sqlagent_proxy_account 'SET',
'NETDOMAIN', -- agent_domain_name
'ralph', -- agent_username
'RalphPwd', - agent password

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


.

Relevant Pages

  • Re: Granting xp_cmdshell permission to SQL Login
    ... Windows login, but I have a SQL Login. ... The 1329 error isn't related to the SQL login executing xp_cmdshell but is rather the Windows error code returned because the xp_cmdshell proxy account doesn't have the needed Windows permissions ... My guess is that the Windows login you mentioned is a sysadmin role member. ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell right for non sysadmin
    ... I did change the SQL agent proxy account info via Enterprise manger. ... For testing purpose, I login using this NT proxy account and try to execute xp_cmdshell, it works. ...
    (microsoft.public.sqlserver.server)
  • Re: Execute permission on xp_cmdshell
    ... Does the proxy account have proper permissions to ... If you login as the proxy account, can you run your BCP commands from ...
    (microsoft.public.sqlserver.security)
  • Re: Security hole?
    ... > WSS FAQ at wss.collutions.com ... > added to the site he does not even see this workspace in the list of all ... > also removed that login from sysadmin server role. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Server role members
    ... login into your system and run the is_membershould NOT be the system ... sysadmin server role. ... exec sp_helprolemember ... Baisong Wei ...
    (microsoft.public.sqlserver.security)