PULL subscriber problem SQL Server 2000

HI,
I hava an problem with start synchronizing on subcriber (anonymus pull
subscriber ), i got the error:
Step Name RUN AGENT
Category - OS
source:
Number 5
Message :Acces is denied
after that next step
The process could not read file
\\MARIUS\REPL\unc\MARIUS$SQLSERVER2000\..\*.sch due to OS error 5
I have both server on WORKGROUP , publisher has Windows 2003 server, and
subscriber Windows XP. if i used push subscriber all are fine.
On subscriber i use user sa instead impersonate(trusted connection)
Seem to be a problem un Agent permission on subscriber, is anybody to help
me in that problem?
thanks,
Marius
Please have a look at the account that the sql server agent on the
subscriber uses. This account must have rights to the snapshot share in
order to carry out the initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||can you connect to your subscriber using QA with the sa account, and issue
the following
xp_cmdshell 'net view \\MARIUS\REPL\unc\MARIUS$SQLSERVER2000'
and post back here with what you see.
"Replication" <mariuskelemen@.yahoo.com> wrote in message
news:%23%23LlNXK1FHA.3756@.tk2msftngp13.phx.gbl...
> HI,
> I hava an problem with start synchronizing on subcriber (anonymus pull
> subscriber ), i got the error:
> Step Name RUN AGENT
> Category - OS
> source:
> Number 5
> Message :Acces is denied
> after that next step
> The process could not read file
> \\MARIUS\REPL\unc\MARIUS$SQLSERVER2000\..\*.sch due to OS error 5
> I have both server on WORKGROUP , publisher has Windows 2003 server, and
> subscriber Windows XP. if i used push subscriber all are fine.
> On subscriber i use user sa instead impersonate(trusted connection)
> Seem to be a problem un Agent permission on subscriber, is anybody to help
> me in that problem?
> thanks,
> Marius
>
|||Hi
i have tried that command
and the result is : xp_cmdshell 'net view \\MARIUS\REPL'
System error 123 has occurred.
NULL
The filename, directory name, or volume label syntax is incorrect.
NULL
NULL
then i tried
xp_cmdshell 'net view \\MARIUS'
and the result is:
Shared resources at \\MARIUS
NULL
NULL
NULL
Share name Type Used as Comment
NULL
EPSONLQ- Print EPSON LQ-300+ ESC/P 2
H Disk
REPL Disk
The command completed successfully.
NULL
NULL
in the sescond u can see te share REPL , but first command didn't found it
Also i tried on computer where share is command:
E:\Documents and Settings\Administrator>net view \\marius\repl
System error 123 has occurred.
The filename, directory name, or volume label syntax is incorrect.
any ideea?
i do not have suficient rights on this folder?
this folder is shared and EVERYONE has full control - checked on it
Other hint , from subscriber an could brose that flder using \\marius\repl
thanks,
Marius
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eHmL5JL1FHA.1564@.tk2msftngp13.phx.gbl...
> can you connect to your subscriber using QA with the sa account, and issue
> the following
> xp_cmdshell 'net view \\MARIUS\REPL\unc\MARIUS$SQLSERVER2000'
> and post back here with what you see.
> "Replication" <mariuskelemen@.yahoo.com> wrote in message
> news:%23%23LlNXK1FHA.3756@.tk2msftngp13.phx.gbl...
>
|||It says it can't find the server Marius or the share repl.
Go to the publisher and issue the same command.
"Marius K" <mariuskelemen@.yahoo.com> wrote in message
news:%23yY0gAN1FHA.2576@.TK2MSFTNGP10.phx.gbl...
> Hi
> i have tried that command
> and the result is : xp_cmdshell 'net view \\MARIUS\REPL'
> System error 123 has occurred.
> NULL
> The filename, directory name, or volume label syntax is incorrect.
> NULL
> NULL
> then i tried
> xp_cmdshell 'net view \\MARIUS'
> and the result is:
> Shared resources at \\MARIUS
> NULL
> NULL
> NULL
> Share name Type Used as Comment
> NULL
> ----
> EPSONLQ- Print EPSON LQ-300+ ESC/P 2
> H Disk
> REPL Disk
> The command completed successfully.
> NULL
> NULL
> in the sescond u can see te share REPL , but first command didn't found it
> Also i tried on computer where share is command:
> E:\Documents and Settings\Administrator>net view \\marius\repl
> System error 123 has occurred.
> The filename, directory name, or volume label syntax is incorrect.
> any ideea?
> i do not have suficient rights on this folder?
> this folder is shared and EVERYONE has full control - checked on it
> Other hint , from subscriber an could brose that flder using \\marius\repl
> thanks,
> Marius
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eHmL5JL1FHA.1564@.tk2msftngp13.phx.gbl...
>
|||HI,
I tried to run both SQL Agent Services (on publisher and subscriber ) with same windows user name - i.e admin (new windows login )
I set LOG ON at services panel - with new users just added (admin)
I had restarted both services from \controlPanel\Services\SQLAgent$SERVERNAME -> restart
after that replication work fine, even i choise between impersonate or SA security for subscriber connection (Enterprise manager => Subscripton Properties)
Cheers
marius k
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:eS3hNJL1FHA.3376@.TK2MSFTNGP14.phx.gbl...
> Please have a look at the account that the sql server agent on the
> subscriber uses. This account must have rights to the snapshot share in
> order to carry out the initialization.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||HI
i reply to Paul Ibison with modification that make to work
cheers and thx
Marius K
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e3p3kpN1FHA.3568@.TK2MSFTNGP15.phx.gbl...
> It says it can't find the server Marius or the share repl.
> Go to the publisher and issue the same command.
> "Marius K" <mariuskelemen@.yahoo.com> wrote in message
> news:%23yY0gAN1FHA.2576@.TK2MSFTNGP10.phx.gbl...
>
|||Thanks Marius!
"Marius K" <mariuskelemen@.yahoo.com> wrote in message
news:%23gDHG9N1FHA.4064@.TK2MSFTNGP09.phx.gbl...
> HI
> i reply to Paul Ibison with modification that make to work
> cheers and thx
> Marius K
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e3p3kpN1FHA.3568@.TK2MSFTNGP15.phx.gbl...
>