Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Short question: Can anyone tell me what the requirements (especially when it comes to SQL components) are for the web server used as web sync for merge replication?

Background:

I have a solution which uses merge replication to do one-way data sync with the client application of the solution.

The server uses SQL Server 2008, the client SQL Server 2008 Express and initiates the pull subscription using RMO. The request goes through Web Sync. All is fine when the IIS and the DB is on the same server - the problem occurs when the IIS is on a standalone web server.

From the error logs, it seems certain SQL components are required on the web server to make this work - but I haven't been able to find which ones. I've tried installing SQL Server 2008 Express on this server, with no luck.

So: Can anyone tell me what the requirements (especially when it comes to SQL components) are for the web server used as web sync for merge replication?

share|improve this question

1 Answer 1

As mentioned in How to: Configure IIS for Web Synchronization, SQL Server connectivity components must be installed on the computer that is running IIS. Also, If you use the Configure Web Synchronization Wizard (which is recommended), you'll also need to install SQL Server Management Studio on the computer that is running IIS.

share|improve this answer
    
I am running IIS 7, which isn't supported by the wizard :-( But I will try the connectivity components and see if that works... –  Chris Ridge Feb 24 '12 at 18:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.