We help IT Professionals succeed at work.

Setting up merge replication SQL 2005 - SQL CE

whityum
whityum asked
on
Medium Priority
1,149 Views
Last Modified: 2008-01-09
I am trying to setup Merge Replication between SQL 2005 and SQL CE using the new subscription wizard, I have the publications and virtual directories setup and keep getting the error:

New Subscription Wizard
- Beginning Synchronization (Success)
- Synchronizing Data (Error)
Messages
A request to send data to the computer running IIS has failed. For more information, see HRESULT.
HRESULT 0x80072EE2 (28037)
 The operation could not be completed.

Everywhere I look the advice is to ensure the permission on the snapshot and virtual directory are correct, however I have enabled Everyone to have full control of those directories and shares, so that should not be an issue.  I have even installed IIS on the test SQL server and used the virtual directory on that machine with the same result.  There is nothing in the event log and I had no errors setting up the publications and virtual directories.  Browsing to the virtual directory in IE gives me: SQL Server Mobile Server Agent 3.0
Comment
Watch Question

Owner
Commented:
Just a thought,
Right click the virtual directory in IIS, click properties, click directory security, click edit.
In the Authenticated Access box, make sure Integrated Windows Authentication is checked.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
permissions looked fine in windows for everything, i did a check of the sql dll by adding ?diag to the query string and found the wizard had setup permissions incorrectly somehow so it did not have read/write permissions, i reran the wizard on the server instead of the dev machine and it works.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.