"Cl@" <none@none.com> wrote in message
news:OD8pE$qIGHA.2900@TK2MSFTNGP14.phx.gbl...
> Hello there,
>
> I'm experiencing a really weird problem:
> I have a SqlCE subscriber connecting via IIS to a SQL Server 2005
> database. The database publisher/distributor and the web server are on
> different machines (IIS being in a DMZ) and I want to avoid the use of
> Kerberos delegation to share priviledges on the snapshot folder.
> I configured the web synchronization to accept basic authentication and
> obviously the subscriber sends @internetlogin and @internetpassword. Plus,
> I used a DB authentication on the SQL Server database.
> First problem, if i disable on the publisher configuration the anonymous
> authentication, replication fails (I expected to be an authenticated user)
> If i enable anonymous authentication, the replication succeed but ONLY if
> I don't use join filters. Everything goes well with static filters,
> overlapping/non overlapping articles, download only tables. Using a
> dynamic filter results in a "The merge process was unable to deliver the
> snapshot to the Subscriber" error.
>
> I really can't imagine a way to fix this behaviour.
>
> Thanks in advance

> Is your join filter based on SUSER_NAME? This should map to your
> publisherlogin.
>
> So if you want to filter on the bases of CL, create a SQL Server account
> called CL, add it to the pal in the publication database, and in your code
> use the account CL and its password.
>

"Cl@" <none@none.com> wrote in message
news:eyhpvVyIGHA.1848@TK2MSFTNGP12.phx.gbl...
> Hilary Cotter ha scritto:
>> Is your join filter based on SUSER_NAME? This should map to your
>> publisherlogin.
>>
>> So if you want to filter on the bases of CL, create a SQL Server account
>> called CL, add it to the pal in the publication database, and in your
>> code use the account CL and its password.
>>
>
> Thanks for the reply and sorry for my lack of knowledge: what is the CL?
> I have this configuration: basic authentication on the IIS (login and
> password sent by the subscriber), SQL authentication for the replication
> (user: ABC, password: CBA)
> On the publication properties I accept anonymous logins and I have the
> user ABC as DB owner and mapped on the PAL.

> :)
>
> I should have said create a sql account, for example CL (the name you posted
> under), and use this account as the basis to filter under.
>
> I don't know what your filtering criteria looks like if its a number create
> an account with this number, if its a name create an account with this name,
> if its a range use a lookup table incorporating a UDF with the account name
> as a variable.
>