os error 1326

[Andre Guerrero]

I keep getting the following error on my subscriber's replication job:

The process could not read file
'\\NEWSQL1\d$\MSSQL7\ReplData\unc\NEWSQL1_coda_coda_replication\19991216235235\employee_rate.sch'
due to OS error 1326. The step failed.

Can anyone tell me how to remedy this? I've tried to set the
permissions on the administrative share but that didn't help.

Thanks, Andre

[Neil Pike]

Andre - sounds like you've got a different password on the NT userid you're using on the
distributor as opposed to the subscriber.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (386 entries) see
sqlfaq.zip in lib 7 (SQL Public) @ http://go.compuserve.com/sqlserver
or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.sql-server.co.uk

[Mike Adams]

Not sure what kind of replication you are trying to use but try not using an
administrative share. Use a normal share.

Andre Guerrero <ague...@home.com> wrote in message
news:385B5A49...@home.com...

[Andre Guerrero]

no, both servers involved are using the same userid/pwd, although they are in different domains.

Neil Pike wrote:

> Andre - sounds like you've got a different password on the NT userid you're using on the
> distributor as opposed to the subscriber.
>

> > I keep getting the following error on my subscriber's replication job:
> >
> > The process could not read file

> > '\\NEWSQL1\d$\MSSQL7\ReplData\unc\NEWSQL1_coda_coda_replication\19991216235235\employee_rate.sch'

> > due to OS error 1326. The step failed.
> >
> > Can anyone tell me how to remedy this? I've tried to set the
> > permissions on the administrative share but that didn't help.
> >
> > Thanks, Andre
> >
>

[Neil Pike]

Andre - so there's a trust between the domains then?

> no, both servers involved are using the same userid/pwd, although they are in different domains.

Neil Pike MVP/MCSE. Protech Computing Ltd

[Andre Guerrero]

yes there is.

Since I needed to get this going I tried another route, with a little more success but not complete
success. I deleted the Pull subscription and created a new Push subscription. That worked as far as
the unc error I was receiving (bug?), but am now having another error. I had to resort to calling MS
support...

Andre

[Michael Hotek]

If you take a close look at the path, you will notice that the default is an
administrative share. If you do not have administrator authority on the
publisher, you can not access the share. To get around this, create an
explicit share and grant access to the account you are using for
replication. You then configure the snapshot to use the folder you
specified.

--
Please direct all replies to the newsgroup unless specifically stated
otherwise.
Mike
Schema Manager 1.0 review is up: http://www.mssqlserver.com/products
SQL Server resources: http://www.mssqlserver.com
Jokes, general products, and consulting: http://www.mhotek.com
Certification resources: http://www.certfaq.com
SYSOP PASS Discussion Forums: http://www.sqlpass.org
mailto:mho...@mssqlserver.com
"Aim high. You can never achieve more than you aspire to." - Al Reis

[Neil Pike]

Andre - if there wasn't a two way trust then I wouldn't expect both a pull and a push to work. With a
one-way trust the NT authentication only goes one way....

> Since I needed to get this going I tried another route, with a little more success but not complete
> success. I deleted the Pull subscription and created a new Push subscription. That worked as far as
> the unc error I was receiving (bug?), but am now having another error. I had to resort to calling MS
> support...

[Andre Guerrero]

It's a two way trust, which I've confirmed by logging into each sql server as 'trusted', from the other
domain.

[Andre Guerrero]

Tried that. I am the administrator, and the sql account has administrator
privileges as well. I tried creating an explicit share and granted both local
and remote sql accounts permissions on the share but it still didn't work