Monday, March 12, 2012

New on Replication

I just started to use SQL Server replication. When I configue the Publisher
and Distributor (they are on same server), the snapshot folder is always
invalid. I was using administrator ID, the folder is located on the local
machine, it's shared. What else I need to change? Please help. Thanks.
Are you connected to a network? You need to be to be able to map a drive to
the snapshot share. I am pretty sure this is your problem. Note you can
install the loopback adapter and get it working that way.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"WindWind" <WindWind@.discussions.microsoft.com> wrote in message
news:8CD07DA4-9620-48C8-963C-0183601719D0@.microsoft.com...
>I just started to use SQL Server replication. When I configue the Publisher
> and Distributor (they are on same server), the snapshot folder is always
> invalid. I was using administrator ID, the folder is located on the local
> machine, it's shared. What else I need to change? Please help. Thanks.
|||Thanks for your response.
This server is connected to the network and I am able to map a drive to this
share folder, but when I chose the folder, it just wouldn't allow me to use
this folder as the snapshot share.
"Hilary Cotter" wrote:

> Are you connected to a network? You need to be to be able to map a drive to
> the snapshot share. I am pretty sure this is your problem. Note you can
> install the loopback adapter and get it working that way.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "WindWind" <WindWind@.discussions.microsoft.com> wrote in message
> news:8CD07DA4-9620-48C8-963C-0183601719D0@.microsoft.com...
>
>
|||Check to make sure that the SQL Server agent account on the publisher has
rights to write to the share, and full control of the directory and
subdirectory of the folder underlying this share. By default it will be read
only.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"WindWind" <WindWind@.discussions.microsoft.com> wrote in message
news:1C880CED-A2D2-4A73-B3EE-C49A50AFF5A0@.microsoft.com...[vbcol=seagreen]
> Thanks for your response.
> This server is connected to the network and I am able to map a drive to
> this
> share folder, but when I chose the folder, it just wouldn't allow me to
> use
> this folder as the snapshot share.
> "Hilary Cotter" wrote:

No comments:

Post a Comment