Backup Error

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

Backing up to a server on another domain ?

Hi,
I'm trying to get a SQL 2005 server to backup it's databases to a
shared folder on a server on another domain. It used to work with
older versions of SQL by setting up a null session share on the
destination server, but something's changed in 2005 and it won't play
anymore. No matter what I do re null sessions, it still gives me the
'Cannot open backup device (OS error 1326, error not found)' message
in the log.
Any ideas ? I don't want to setup a trust between the two domains.
Cheers.
I suspect the account that SQL Server is running under does not have the
correct permissions to access this share. I have no idea what a NULL session
share is but the account needs to be able to read and write to the share.
Don't use a mapped drive.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<pcmangler@.googlemail.com> wrote in message
news:4639622a-56de-41e9-b0ad-68ee2b52eeec@.c30g2000hsa.googlegroups.com...
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.
|||I'm not entirely sure why you're using a null share anyway. If it's a
different domain and you want to save a backup to it, then they need to
provide the acct with permissions on that drive. Even a simple one-way trust
would solve your problem. However, that being said, and the obvious security
risks involved with such a venture, here's a KB article that has some things
to check to make sure you've got everything setup right.
http://support.microsoft.com/default.aspx/kb/289655
"pcmangler@.googlemail.com" wrote:

> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.
>

Backing up to a server on another domain ?

Hi,
I'm trying to get a SQL 2005 server to backup it's databases to a
shared folder on a server on another domain. It used to work with
older versions of SQL by setting up a null session share on the
destination server, but something's changed in 2005 and it won't play
anymore. No matter what I do re null sessions, it still gives me the
'Cannot open backup device (OS error 1326, error not found)' message
in the log.
Any ideas ? I don't want to setup a trust between the two domains.
Cheers.I suspect the account that SQL Server is running under does not have the
correct permissions to access this share. I have no idea what a NULL session
share is but the account needs to be able to read and write to the share.
Don't use a mapped drive.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<pcmangler@.googlemail.com> wrote in message
news:4639622a-56de-41e9-b0ad-68ee2b52eeec@.c30g2000hsa.googlegroups.com...
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.|||I'm not entirely sure why you're using a null share anyway. If it's a
different domain and you want to save a backup to it, then they need to
provide the acct with permissions on that drive. Even a simple one-way trus
t
would solve your problem. However, that being said, and the obvious securit
y
risks involved with such a venture, here's a KB article that has some things
to check to make sure you've got everything setup right.
http://support.microsoft.com/default.aspx/kb/289655
"pcmangler@.googlemail.com" wrote:

> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.
>

Backing up to a server on another domain ?

Hi,
I'm trying to get a SQL 2005 server to backup it's databases to a
shared folder on a server on another domain. It used to work with
older versions of SQL by setting up a null session share on the
destination server, but something's changed in 2005 and it won't play
anymore. No matter what I do re null sessions, it still gives me the
'Cannot open backup device (OS error 1326, error not found)' message
in the log.
Any ideas ? I don't want to setup a trust between the two domains.
Cheers.I suspect the account that SQL Server is running under does not have the
correct permissions to access this share. I have no idea what a NULL session
share is but the account needs to be able to read and write to the share.
Don't use a mapped drive.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<pcmangler@.googlemail.com> wrote in message
news:4639622a-56de-41e9-b0ad-68ee2b52eeec@.c30g2000hsa.googlegroups.com...
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.|||I'm not entirely sure why you're using a null share anyway. If it's a
different domain and you want to save a backup to it, then they need to
provide the acct with permissions on that drive. Even a simple one-way trust
would solve your problem. However, that being said, and the obvious security
risks involved with such a venture, here's a KB article that has some things
to check to make sure you've got everything setup right.
http://support.microsoft.com/default.aspx/kb/289655
"pcmangler@.googlemail.com" wrote:
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.
>