We have been using the Domain administrator's account to
run the backup on our server. This morning the backup
failed on one of our SQL server's saying it was Unable to
determine if the owner of the job has server access. We
have another SQL server using the same account which
worked fine. Why would this account suddenly not work for
the backup'Are you using a 3rd party tool to backup the database such as NTBackup or
Arcserve or using SQLAgent to schedule a BACKUP DATABASE command
--
HTH
Ryan Waight, MCDBA, MCSE
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:063001c393f6$67d954c0$a001280a@.phx.gbl...
> We have been using the Domain administrator's account to
> run the backup on our server. This morning the backup
> failed on one of our SQL server's saying it was Unable to
> determine if the owner of the job has server access. We
> have another SQL server using the same account which
> worked fine. Why would this account suddenly not work for
> the backup'|||You could try setting the job owner to "sa". This has helped me a couple of times.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:063001c393f6$67d954c0$a001280a@.phx.gbl...
> We have been using the Domain administrator's account to
> run the backup on our server. This morning the backup
> failed on one of our SQL server's saying it was Unable to
> determine if the owner of the job has server access. We
> have another SQL server using the same account which
> worked fine. Why would this account suddenly not work for
> the backup'|||And the article to accompany Tibor's answer can be found here
PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated
User
PSS ID Number: 241643
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ukioT4IlDHA.1284@.TK2MSFTNGP09.phx.gbl...
> You could try setting the job owner to "sa". This has helped me a couple
of times.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Me" <anonymous@.discussions.microsoft.com> wrote in message
> news:063001c393f6$67d954c0$a001280a@.phx.gbl...
> > We have been using the Domain administrator's account to
> > run the backup on our server. This morning the backup
> > failed on one of our SQL server's saying it was Unable to
> > determine if the owner of the job has server access. We
> > have another SQL server using the same account which
> > worked fine. Why would this account suddenly not work for
> > the backup'
>sql
No comments:
Post a Comment