Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Web synchronisation on XP pro box

Author  Topic 

dafi
Starting Member

1 Post

Posted - 2007-10-17 : 16:49:48
Hi

For our application we want two Publisher models:
1) running SQL Server 2005 standard on Windows Server 2003
2) running SQL Server 2005 standard (or workgroup) on Windows XP pro

The reaseon is simply cost. The first for clients that may have 10s / 100s of SQLce subscribers, the second for just 1-5 SQLce subscribers.

We want to use Web syncronisation. Problem is when setting up on the XP box I get to the final bits of Microsoft's setup document and it starts to tell you to set up an application pool. As far as I can tell this is only available on IIS6 on Windows Server 2003.

Searching the Internet I don't seem to be able to find a definative 'don't be a pratt' you can't run Web Synchronisation from a XP pro box.

Could someone let me know if it is or is not possible. If I could get SQL Express to be a publisher (to SQLce subscribers) I would have prefered not to have the cost of a full verision of SQL Server for our smaller clients.

Many thanks in advance

Alistair

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-19 : 23:49:44
No, sql express can't be publisher.
Go to Top of Page
   

- Advertisement -