Setting up SQL Server CE replication on Vista with IIS 7.0

Over the last couple of days I have rebuilt my laptop with the RTM build of Vista.  As expected there have been a few hurdles, the biggest of which was getting replication to work.  With SQL Server Management Studio I could easily create the publication but setting it up as a web virtual directory (so that it can be subscribed to by SQL Server CE) was another matter.  After installing Vista I went into the Add/Remove programs and selected the IIS windows component.  Unfortunately this doesn’t include the II6 compatibility API – which most applications that were designed for II6 and earlier use.  To get the virtual directory setup you need to install the compatibility API by checking the option selected in the following image (you also need to be running SSMS as administrator to communicate using these APIs)

Leave a comment