In the SQL Agent Properties - Jobsystem tab you can select an account to use for Non-Sysadmin job steps.
When I enter the proxy account I get an error
Error execuring store procedure: "Specified user cannot Login"
The account is fine, not locked or anything, I am entering it the same as I have on about 50 other servers. But still having no joy, even tried a different account.
I am having this problem on 2 recently built servers, but never had it before. I an convinced its not the actual account. Anyone seen this before, have any ideas.
Be much appreciated
When I enter the proxy account I get an error
Error execuring store procedure: "Specified user cannot Login"
The account is fine, not locked or anything, I am entering it the same as I have on about 50 other servers. But still having no joy, even tried a different account.
I am having this problem on 2 recently built servers, but never had it before. I an convinced its not the actual account. Anyone seen this before, have any ideas.
Be much appreciated
