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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-06-06 : 16:22:15
|
| SQL server 2008 R2 agent jobs starting failing with following error:"The job failed. Unable to determine if the owner (domain\login) of job MaintenancePlan - ABC.Full backup has server access (reason: Could not obtain information about Windows NT group/user 'domain\login', error code 0x5. [SQLSTATE 42000] (Error 15404))".Any help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-06-07 : 14:01:15
|
| Do not use sa. create a user with the permissions needed.djj |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-06-10 : 14:07:49
|
quote:
Originally posted by djj55
Do not use sa. create a user with the permissions needed.djj
Why not use sa? |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-06-10 : 14:51:46
|
| It is a best practice. By locking the sa account you have one less security leak point.djj |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2013-06-11 : 11:41:13
|
| Database Engine Service Account was locked. Issued resolved after unlocking it. |
|
|
|
|
|
|
Agent jobs failing