Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2002-05-15 : 10:20:29
|
| Now that I have your attention. I am trying to set up a Sql Agent Proxy Account and keep getting this error:"Unable to set the SQL Agent Proxy account because of the reason below.'error executing extended stored procedure: Specified user cannot login.'"The machine is stand alone. "MACHINEA"The user account is part of the NT administrator group. "SQLPROXY"The user is NT authenticated in MSSQL and is a sysadmin.EXEC master.dbo.xp_sqlagent_proxy_account 'SET', 'machineA', 'sqlproxy', 'proxypwd'I have tried MSDN, KNowledge Base, and Primer Support. Nothing!!Any help would be appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-15 : 10:39:13
|
Maybe it doesn't like you Scott  You've tried everything else.How about:EXEC master.dbo.xp_sqlagent_proxy_account N'SET', N'MACHINEA', N'sqlproxy', N'proxypwd' That's just a syntax thing, probably won't matter. Are you sure that the domain, user, and password are all the right case? I know that at least one of them is case sensitive.Are you running the latest service pack (which version of SQL Server are you running)? Have you tried setting up SQL Server, SQL Agent, and the proxy account to run under the same account? If there is a mismatch between the 3, that could be the problem (I'm guessing based on the Books Online entry, I haven't tried it)Did you call the support line? What did they tell you? If you haven't called them yet you should do that, and if they can't help, well, you're SOL then. |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-05-15 : 10:43:46
|
| OS: NT4.0 sp6MSSQL: 2k sp2Switch the account to the account the service is running and got the same error. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-05-15 : 10:46:38
|
| I have also tried loging into the machine as the account running SQL, connecting as a trusted connection and run the proc and connecting as sa and running the proc.Same error. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-15 : 10:51:54
|
| I'm shot. You'll have to call MS. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-05-15 : 11:02:17
|
| After many painfull days I have figured it out.The NT account needs these permissions:Act as part of the operating system. Increase quotas. replace process level token. Log on as a batch job. Search on PRB: Error 1314 in the knowledge based. |
|
|
|
|
|
|
|
|
ORACLE Rocks!!