SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

• mattie02601

  Look at the replication Monitor output for the snapshot agent. Does that tell you anything
  
  Worst case, run the snapshot from the command line. To do that:
  1) select * from msdb..sysjobsteps
        select the command line parameters for the snapshot agent for the publication under consideration.
  2) Use the snapshot executable located in:
  C:\Program Files\Microsoft SQL Server\90\COM\snapshot.exe
  and add the parameters got from step 1
  3) Run the above command line on a command prompt.
  
  See what happens...
  
  

• Vishalbhambure

  ok thanks for that.  if i didnt solve this problem today i was going to look into implementing a Service Orientaited Architecture which aparently takes a fair amount more effort then merge replication.
  
  Thanks again.

  
  

• utkuozan

  Glad it woked out for you.
  
  No, you dont need to keep running it from the command line.
  I think what happened was you hit the start button and then immediately started the sync. Since snapshot takes a while to complete, you should have waited and then verified that the snapshot completed and then started to sync. I forgot to mention that. Anyways, now that it is working fine, you will not need to rerun the snapshot from command line. In case you need to run the snapshot again sometime, you can just start the snapshot agent (through UI, as I mentioned) but wait and verify that the job completed.
  
  

• afields2

  Hi Mahesh,
  
  That worked perfectly. Except for step 1 i had to change the sql slightly.

  select * from msdb.dbo.sysjobsteps
  
  I then ran it from the command line and it worked great.
  
  I then syncronised the SQL Mobile database and all went well.
  
  I would never have know how to run it via the command line, will i have to do that in the future to though :S
  
  Thanks heaps for your time in helping me out.
  
  

  
  

• prolove

  Hi Mahesh,
  
  The problem was as follows.  I configured the IIS directory by myself and it didnt put in the *.dlls.  So what i ended up doing was i tried to install the web connectivity wizzard sqlce30setupen.msi and then it wouldnt install saying that i didnt have sql server 2005 client connectivity components installed. Yet i had installed them previously.  So what i done then was to uninstall everything then reinstalled everything again which helped fix the problem, yet it has been problem after problem for me over the last 4 days solid trying to get this to work.
  
  Your advice above now shows the diagnostics.
  
  Although now when i create the subscription and try to syncronise an SQL Server Mobile db i get all the way through the wizzard i get to the end and press next and it starts syncrhonising and i get the following error message:
  

  Synchronizing Data (100%) (Error)

  Messages

  Initializing SQL Server Reconciler has failed.
  HRESULT 0x80045003 (29045)
  
  The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the synchronization.
  HRESULT 0x80045003 (0)
  

  The operation could not be completed.
  
  When i check the snapshot folder it is empty.  I am at a loss and running out of time. :(
  
  Looking at the replication monitor everything in the tree view has 'X's on it (crosses)
  
  Any ideas anyone.
  
  Thanks,
  Pdns
  

  
  

• Aarthi

  At Step 2 i get:
   Right Click on the Publication-->View Snapshot Agent Status-->Start
  Executed as user: <Computner Name>\snapshot_agent. The step did not generate any output.  The step failed.
  
  I then done step 3. checked the replication monitor to find the publisher for the database iam trying to connect to.  I then selected the publication and found an error as follows.
  
  

  Error messages:

  The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the synchronization. (Source: MSSQLServer, Error number: 2147766275)
  Get help: http://help/2147766275
  
  Iam not sure of this one either, since when i pressed 'start' in step 2 it still didnt work. 
  
  Thanks for the steps above. It looks like its getting closer :D

  
  

• yukizz

  Can you check if the virtual directory was created successfully and that you can connect to the virtual directory through internet explorer using:
  http://MachineName/VirtualDirName/sqlcesa30.dll diag
  
  

• km9

   Re: SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call Hi there - don't know if anyone is still reading this.
  
  I have had exactly the same problems with the Snapshot Agent - I have been trying out the sample provided by microsoft at http://msdn2.microsoft.com/en-us/library/ms171908.aspx
  
  I have tried to run the Snapshot Agent from the command line using the parameters that I got using select * from msdb.dbo.sysjobsteps
  
  However, the snapshot does not complete when running within the Command Prompt
  
  I get the following error:
  
  The replication agent has encountered an exception
  Source: unknown
  Exception type: System.UnauthorizedAccessException
  Exception message: Access to the path '\\(computername)\snapshot\unc\(computername)_SQLMobile_SQLMobile\20051128201956 is denied.
  
  That is a time stamp obviously, but why can't it be accessed I have gone through the sample exactly.
  
  Thanks for any help you can provide...
  
  JB
  

• Kumar PDV

  Hi,

  i have created publication on server.and when i try to create sql server mobile subscription on my machine, i get following error:

  TITLE: Microsoft SQL Server Management Studio
  ------------------------------

  A request to send data to the computer running IIS has failed. For more information, see HRESULT.
  HRESULT 0x80072EE2 (28037)

  ------------------------------
  BUTTONS:

  OK
  ------------------------------

  my machine and server are on different.

  i am able to get "SQL Server Mobile Server Agent 3.0" message when i run  http://<server_name>/<virtual_dir>sqlcesa30.dll through Internet explorer
  what should i do now.please help me
  

  
  

• Rafitelli

  Hi,
  The dlls not being copied is a different problem and we can address that later.
  
  For the current problem, the error message indicates that the snapshot is not yet ready and hence your sync is failing. You need to run the snapshot agent to generate the snapshot and then run the sync.
  Here is what you need to do:
  1) Start the SQL Server agent
  2) In Management Studio, Right Click on the Publication-->View Snapshot Agent Status-->Start OR (in Repl monitor, R-Click on the Publication-->Generate Snapshot)
  3) Also make sure that the snapshot is actually generated. The reason is that the snapshot agent could fail for some reason and then the sync will again fail for the same reason. (If the snapshot fails, look at the snapshot job history or in the repl monitor to see why the snapshot job failed and address that problem)
  4) Once snapshot is generated, start the sync and this time it should succeed.
  
  

• bplucas

  One of these two could be happening:
  1. The user running the snapshot agent does not have permissions on the snapshot folder
  2. Your snapshot share could be set incorrectly
  
  Please check both and try again.
  
  

• colinmit

  Hi i wonder if anybody is still reading this.HELP PLEASEEE
  I have 2 problems,
  First whem I go to "view snapshot agent status" on my merge publication it shows the following error message.
  
  "Executed as user: CR-TEC-LXP-FP05\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed"
  
  Second when I try to create a subscription on the SqlMobile server it gives me the next error when it's running the second step (synchronizing data).
  
  "An incorrect or unsupported HTTP function call was made.
  HRESULT 0x80004005 (28017)"
  
  Thanks in adavance.
  
  
  
  
• SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call