Setting up Sql Mobile subscription

Setting up Sql Mobile subscription

• MarkR***

  Darren meant IUSR_<MachineName> where MachineName stands for IIS Box COMPUTERNAME. Did you try the same

  Also we assume here that you are having IIS and SQL Server on the same machine/box.

  Thanks,

  Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

  
  
  

• Tukanos

  You first add IUSR_MACHINENAME as a valid login to the database you are publishing (give the account DataReader and DataWriter permissions), *then* you will see it show up in the list of accounts you can grant permissions on the publication itself.

  Darren

  
  
  

• vAlex

  Doug,

  28037 can be caused by a variety of things. First, I would use the actual machine name in the url (not localhost) and you also need the virtual directory in the URL (http://machinename/virtdir/). Here are some other things that can cause this error:

  1. you don't run the SQL Agent under an account with admin permissions on the server as well as

  explicity set permissions on both the published database and the publication

  2. you use anonymous authentication and don't realize that the ISAPI DLL (sqlcesa30.dll) tries to

  present the ASP.NET default user credentials (IUSR_MACHINENAME) to the distributor and

  publisher to broker the replication. Be sure to explicitly grant IUSR_MACHINENAME read/write

  permissions on both the published database and the publication

  3. you don't have a fresh snapshot of the publication successfully created

  Darren

  
  
  

• visuallll

  i cannot seem to add Iuser_ to the list for the publication because none are showing up in the list to add. how do i go about adding that user to the database
  

• JosAnt

  I am having the same problem, but it's not any three of the things that you said above. I set up Web Synchronization to not use SSL (as we have not received it yet), so could that be causing this error I keep seeing a few burbs on the internet about how Replication can only be run using SSL, is this true Otherwise I am at a loss on what to do.

  Jackie

  
  

• embedded

  when i click on properties of the database that i am sharing, then select the permissions page, i currently have no users in the "Users or Roles" section. i click on add and and browse and only have four possible users to allow, Guest, Public, MS__Merge_Pal and MSmerge_08750F3A2EDB42899726D5D4170359E9. i do not see the IUSR_ role and when i attempt to enter it by hand and check the name it does not find it either.

  any other suggestions

  
  
• Setting up Sql Mobile subscription