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 - 2004-01-07 : 10:38:56
|
| A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': Logon failure: the user has not been granted the requested logon type at this computer. The step failed.Win Server 2000Sql Server 2000 sp4 and hotfix 8.0.818Job system set up using 'sqlexec' as a local user in the users group.When I switch the user to administrators group it works.Any help on what permissions I need to assign would be helpful.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 12:35:06
|
| The user does not have permissions to logon locally. You'll need to check the policy for that user.Tara |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-01-07 : 16:39:32
|
| User has log on locally. anywhere else? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 17:00:52
|
| Have you tried logging in locally with the account? Do you get any errors when doing so?Tara |
|
|
|
|
|
|
NON-SA Job Failing on cmdexec