--消息 50001,级别 1,状态 50001
--xpsql.cpp: 错误 87 来自 GetProxyAccount(第 604 行)
打开SQLSERVER的企业管理器,进入“管理”,右键点击“Sql Server代理”点击属性;
首先你要“允许非SysAdmin权限的用户执行CmdExec.....”,然后指定一个账号。
不过,你需要意识到这样做所存在的安全上的风险。
有关英文回复:
You don't have to use a domain account. When you go into the "job system" properties on your sql agent, click the "reset proxy account". it will ask you for a new user/password and domain. For the domain, just put the name of the local server (of course, that account has to exist on the local server).
可以使用下面的语句来获取当前的代理所使用的账号:
exec master.dbo.xp_sqlagent_proxy_account N&#
--xpsql.cpp: 错误 87 来自 GetProxyAccount(第 604 行)
打开SQLSERVER的企业管理器,进入“管理”,右键点击“Sql Server代理”点击属性;
首先你要“允许非SysAdmin权限的用户执行CmdExec.....”,然后指定一个账号。
不过,你需要意识到这样做所存在的安全上的风险。
有关英文回复:
You don't have to use a domain account. When you go into the "job system" properties on your sql agent, click the "reset proxy account". it will ask you for a new user/password and domain. For the domain, just put the name of the local server (of course, that account has to exist on the local server).
Also, I'm sure you know what the risk is by allowing non-syadmins the ability to execute XP_CMDSHELL....
可以使用下面的语句来获取当前的代理所使用的账号:
exec master.dbo.xp_sqlagent_proxy_account N&#