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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2006-06-30 : 10:52:54
|
| HiWe have an AD account called X.The SQL Service and the SQL Server AGent both run on this account.However we still have some of the older accounts from (NT Domain Days)a domain called y\xuser physically on the server not attached to any databases.In our production servers one of our jobs dies when we disable this account y\xuser. Cannot seem to locate the exact reason for that.Anybody come across this issue? or how we can overcome that?My idea was to drop the job and recreate it with SA login. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-30 : 11:03:53
|
| is the job running using that account?if yes, change the owner to sawhat does the job do? are there objects or permissions set for account y/xuser on that job that fails because of permission denies?HTH--------------------keeping it simple... |
 |
|
|
|
|
|
Job Dying because....