| Author |
Merge Replication Problem (Urgent)
|
|
| Robert Lie 2005-08-16, 3:23 am |
| Dear All,
I have an error message when I'm trying to synchronize from SQL Server
Ce to SQL Server 2000.
The error message is
"The process could not deliver the snapshot to the subscriber"
I already know that I need to verify that the IIS user your SQL Server
CE Server Agent is running under has READ permissions to this folder.
But I don't know how to verify that?
You can see my sqlserverce authentication and IIS configuration on the
attachement.
Pls give me some ideas to solve it out?
Thanks
Robert Lie
| |
| Hilary Cotter 2005-08-16, 1:25 pm |
| What is your default snapshot share? Is it \\ServerName\C$\Prog
ram
Files\Microsoft SQL Server\MSSQL\REPLdat
a?
You need to change it to a share which the anonymous account can access. I
would also configure the VD for anonymous access - this will make it easier
to debug your code.
--
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
"Robert Lie" <robert.lie24@gmail.com> wrote in message
news:%23EgsashoFHA.4028@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
> I have an error message when I'm trying to synchronize from SQL Server
> Ce to SQL Server 2000.
>
> The error message is
> "The process could not deliver the snapshot to the subscriber"
>
> I already know that I need to verify that the IIS user your SQL Server
> CE Server Agent is running under has READ permissions to this folder.
> But I don't know how to verify that?
>
> You can see my sqlserverce authentication and IIS configuration on the
> attachement.
>
> Pls give me some ideas to solve it out?
>
> Thanks
>
> Robert Lie
>
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
| |
| Robert Lie 2005-08-16, 1:25 pm |
| Yes I use \\ServerName\C$\Prog
ram Files\Microsoft SQL
Server\MSSQL\REPLdat
a. And I have set so I can access the folder.
Do you mean that I have to make folder \\ServerName\C$\Prog
ram
Files\Microsoft SQL Server\MSSQL\REPLdat
a as a share folder and
anonymous account can access it?
Thanks
Robert Lie
Hilary Cotter wrote:
> What is your default snapshot share? Is it \\ServerName\C$\Prog
ram
> Files\Microsoft SQL Server\MSSQL\REPLdat
a?
>
> You need to change it to a share which the anonymous account can access. I
> would also configure the VD for anonymous access - this will make it easier
> to debug your code.
>
| |
| Hilary Cotter 2005-08-16, 1:25 pm |
| Open up SQL Server CE Connectivity Manager, click on HTTP Authentication.
What have you selected. Then click on NFTS Permissions, click on the button
and click until you get the NTFP Permissions Snapshot Share. What share is
here?
It should be something like \\Servername\Sharena
me - while
\\ServerName\C$\Prog
ram Files\Microsoft SQL Server\MSSQL\ReplDat
a may work
for you if the account you are using to sync with is in the Administrators
group - this is probably not what you want.
--
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
"Robert Lie" <robert.lie24@gmail.com> wrote in message
news:OuaSu1loFHA.3256@TK2MSFTNGP12.phx.gbl...[color=darkred]
> Yes I use \\ServerName\C$\Prog
ram Files\Microsoft SQL
> Server\MSSQL\REPLdat
a. And I have set so I can access the folder.
>
> Do you mean that I have to make folder \\ServerName\C$\Prog
ram
> Files\Microsoft SQL Server\MSSQL\REPLdat
a as a share folder and
> anonymous account can access it?
>
> Thanks
>
> Robert Lie
>
>
> Hilary Cotter wrote:
I[color=darkred]
easier[color=darkred
]
|
|
|
|