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.
>