| Author |
Topic |
|
sanmeets
Starting Member
3 Posts |
 Posted - 2003-02-27 : 10:20:17
|
| Some of the jobs, specially the backup and trans backup jobs fail occasionaly. It doesnt happen all the time but once in few days. This is the message I get.The job failed. Unable to determine if the owner (DOMAINNAME\username) of job "JOB NAME" has server access (reason: Could not obtain information about Windows NT group/user 'DOMAINNAME\username'. [SQLSTATE 42000] (Error 8198)). I fail to understand why the job succeeds most of the time but once in a while I get this message and it fails.Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-27 : 11:55:27
|
| Does the Domain account expire? Did you set up a service account? Are you connected to the Network? Who is the Owner of the job? SA or some other id? Is the job executed remotley or as a scheduled task?Just some ideas. Never had this problem.Good LuckBrett |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-27 : 12:31:55
|
| We have that same problem. I believe that the problem is that the server can not communicate with the Domain controller at times, so it can't determine if the account is valid. To get around this, we changed the job owner's to sql accounts instead. |
|
|
|
pritzy
Starting Member
6 Posts |
Posted - 2008-05-12 : 00:58:46
|
| hi,i have the same problem.the error i get is 'job failed. the owner of job does not have server access. can somebody help me please..its urgent |
|
|
|
pritzy
Starting Member
6 Posts |
Posted - 2008-05-12 : 01:00:22
|
| some of the jobs succeed and the others fail. what can be the problem...is there any walk around to this |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 21:54:10
|
| Are they have same owner? What do those jobs do? |
|
|
|
pritzy
Starting Member
6 Posts |
Posted - 2008-05-15 : 22:04:51
|
| the owner is the same for all SA. these are scheduled backup jobs. the first backup jobs run ok but on the next scheduled date, some of the backups fail and others are ok. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 23:18:25
|
| Did you check sql server log? It tells why backup failed. |
|
|
|
pritzy
Starting Member
6 Posts |
Posted - 2008-05-16 : 01:13:53
|
| the error i get is 'job failed. the owner of job does not have server access. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:10:39
|
| sa should have. |
|
|
|
RyanAustin
Yak Posting Veteran
50 Posts |
Posted - 2008-05-18 : 20:39:18
|
| You could also try adding the service account into the Local Administrator group. I can't say that I have ever seen an error like that in our setup for the last 2 years. |
|
|
|
|
SQL Server Job fails