Re: sqlceException when attempting Merge Replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason L James (jason_at_nospam.divemaster.org)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 21:53:45 +0100

Mani,

I am not sure what you mean when you ask if I have made
my local machine a distributor? When should I have been
asked this question? In configure IIS or SQL? I have created
the publication in SQL2K.

My machine is configured using NTFS and I have assigned
NTFS permissions to the account iusr_xxxx to my shapshot
share?

Is there a thorough, and complete walkthrough example for
setting up the SQL and IIS apps and the folders, shares and
vitual directories they use?

Thanks,

Jason.

On Fri, 30 Jul 2004 12:00:38 -0400, "Mani"
<mani_AT_evikasystemsdotcom> wrote:

>Jason,
>
>have you made your local machine itself as the distributor? you would have
>been prompted to do so.
>I have not received the same error, but i did go thru my issues with
>replication.
>also, assign ntfs persmissions on the iusr_xxx account thru the 'configure
>connectivity for IIS'
>if your snapshot has been shared on a fat drive, you may have to do so on a
>ntfs partition.
>
>Thanks
>Mani.
>
>"Jason L James" <jason@no-spam.dive-master.org> wrote in message
>news:410a6929.28393467@news.demon.co.uk...
>> Hi All,
>>
>> merge replication with sqlce and vb.net is driving me crazy.
>>
>> I have my db built as published in my SQL2K DBMS.
>> I have set up my snapshot folder and shared it.
>> I have set up my virtual folder in IIS using sqlce mgr
>> I have created a test application in vb.net
>> I have deployed it to my device.
>> My DB has some sample data in it
>> My DB is called ShoppingCart
>> my publication is called ShoppingCart_pub
>> My virtual folder is called sqlcerep
>> My snapshot folder is aclled sqlcerep_snap
>>
>> HOWEVER, when I attempt to execute the
>> synchronize command on by replication object
>> I set the following sqlce exception:
>>
>> Some Distributor properties are not specified [,,,,,]
>>
>> I can see the virtual folder and its contents, i.e.
>> sscesa2.dll from within IE on my device.
>>
>> Both IIS and SQL are running on the same machine.
>>
>> I am using anonymous authentication for IIS and have
>> enables iuser_computername as having access to the
>> sql DB.
>>
>> I have worked through several examples but I am still
>> very confused about *exactly* how I should be configuring
>> my windows PC (the one running IIS and SQL) to ensure
>> correct authentication to allow my ppc app to
>> replicate.
>>
>> The code I am using is below.
>>
>> Dim rep1 As New SqlCeReplication
>> Dim ssceconn As New SqlCeConnection
>> Try
>> rep1.Publisher = "delllaptop"
>> rep1.PublisherLogin = ""
>> rep1.PublisherPassword = ""
>> rep1.InternetUrl =
>> "http://delllaptop/sqlcerep/sscea20.dll"
>> rep1.InternetLogin = ""
>> rep1.InternetPassword = ""
>> rep1.Subscriber = "MRCart"
>> rep1.Publication = "ShoppingCart_pub"
>> rep1.PublisherDatabase = "ShoppingCart"
>> ssceconn.ConnectionString = "Data Source = \My
>> Documents\ShoppingCart.sdf"
>> rep1.SubscriberConnectionString =
>> "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0; Data Source=\My
>> Documents\ShoppingCart.sdf"
>> While System.IO.File.Exists("\My
>> Documents\ShoppingCart.sdf") = False
>> If MessageBox.Show("Create File", "Create DB",
>> MessageBoxButtons.YesNo, MessageBoxIcon.Question,
>> MessageBoxDefaultButton.Button1) = DialogResult.Yes Then
>> rep1.AddSubscription(AddOption.CreateDatabase)
>> End If
>> End While
>> rep1.Synchronize()
>> Catch ex As SqlCeException
>> MessageBox.Show("SQLCE Ex : " & ex.Message)
>> Catch ex As Exception
>> MessageBox.Show("EX : " & ex.Message)
>> Finally
>> rep1.Dispose()
>> End Try
>>
>> End Sub
>>
>> I think that my problems are all to do with authentication and
>> permissions on folders and which users should be used for
>> which aspects of the application.
>>
>> Any help would be very much appreciated.
>>
>> Many thanks,
>>
>> Jason.
>

Relevant Pages

  • Re: sqlceException when attempting Merge Replication
    ... have you made your local machine itself as the distributor? ... connectivity for IIS' ... > merge replication with sqlce and vb.net is driving me crazy. ... > I have set up my virtual folder in IIS using sqlce mgr ...
    (microsoft.public.sqlserver.ce)
  • RE: sqlceException when attempting Merge Replication
    ... not have a Distributor SQL Server, then leave all of the Distributor ... you do not set any Distributor properties. ... | I have set up my virtual folder in IIS using sqlce mgr ... | Both IIS and SQL are running on the same machine. ...
    (microsoft.public.sqlserver.ce)
  • Re: sqlceException when attempting Merge Replication
    ... One is needed depending on how you've set up iis and your database. ... need a publisher password if you're uisng dbauthentication. ... > I have set up my virtual folder in IIS using sqlce mgr ...
    (microsoft.public.sqlserver.ce)
  • Re: Run IIS in a domain user context
    ... > If this is IIS 6.0, you need to change the identity of the Web Application ... When I say local machine I mean the server that is hosting IIS ... server side in the context of LocalSystem which I assume the web service ...
    (microsoft.public.inetserver.iis.security)
  • Re: sqlceException when attempting Merge Replication
    ... error occurred on the computer running IIS. ... >not have a Distributor SQL Server, then leave all of the Distributor ... >| I have set up my virtual folder in IIS using sqlce mgr ...
    (microsoft.public.sqlserver.ce)