Showing posts with label pull. Show all posts
Showing posts with label pull. Show all posts

Tuesday, March 27, 2012

Can't start replication agent

Hi,
I am using snapshot replication and want to create pull /
push replication but I always encountered same problem :
Login failed for user . . .
I think I had already set my user as an Administrator but
it didn't work.
Thanks in advance !
Michael Rawi
Michael,
in the subscriber database, right-click the distribution agent and select
properties.
On the security tab, choose to impersonate the SQL Server Agent.
You can change the service accounts to use the same domain user or have the
windows login of the subscriber's agent as a separate login on the
publisher.
HTH,
Paul Ibison
sql

Wednesday, March 7, 2012

Can't pull the subscription

The process could not read file
'd:\sql_data\MSSQL\ReplData\unc\...\20050324084140 \snapshot.pre' due to OS
error 3.
What is going on?
Wack
This message will self destruct.
Looks like you set your snapshot folder to be a local path ("d:\...")
instead of a UNC path (\\mybox\d$\sql_data\MSSQL\ReplData). You specify the
default snapshot folder when you configure your publisher/distributor but
can override this value when you create a publication.
"Ray Lewis" <dav5489@.hotmail.com> wrote in message
news:enypHuHMFHA.3420@.tk2msftngp13.phx.gbl...
> The process could not read file
> 'd:\sql_data\MSSQL\ReplData\unc\...\20050324084140 \snapshot.pre' due to OS
> error 3.
> What is going on?
> --
> Wack
> --
> This message will self destruct.
>
|||The snapshots are going to the correct place, I.E, Server X = Distributor,
Server Y = Publisher, Server Z = Subscriber.
Server Y takes a snapshot of the db and stores it on Server X. Server Z,
however, can't get to the snapshot to replicate.
Wack
This message will self destruct.
"Mike Jansen" <mjansen_nntp@.mail.com> wrote in message
news:uJ4nJ7JMFHA.1300@.TK2MSFTNGP10.phx.gbl...
> Looks like you set your snapshot folder to be a local path ("d:\...")
> instead of a UNC path (\\mybox\d$\sql_data\MSSQL\ReplData). You specify
the[vbcol=seagreen]
> default snapshot folder when you configure your publisher/distributor but
> can override this value when you create a publication.
> "Ray Lewis" <dav5489@.hotmail.com> wrote in message
> news:enypHuHMFHA.3420@.tk2msftngp13.phx.gbl...
OS
>