With the recent release of SQL Server Compact 3.5 SP2, installing the Web Synchronization Agent on Windows 7 and Server 2008 R2 has become a lot easier, as I demonstrate below.
Download the latest Server Tools
First, download the latest version of the SQL Compact Server tools for 3.5 SP2.
For x64 systems, the x64 version of the tools is: SSCEServerTools_x64-ENU.msi
Notice the following on the download page:
Configure IIS 7.5
Enable IIS on Windows 7:
Click Start, click Control Panel, click Programs and Features, and then click Turn Windows features on or off.
Select the Internet Information Services check box.
Open Internet Information Services.
Open World Wide Web Services.
Open Application Development Features
Select the ISAPI Extensions check box.
Open Web Management Tools.
Open IIS 6.0 Management Compatibility.
Select the check boxes for IIS 6 Metabase and IIS 6 configuration compatibility and IIS 6 Management Console
Click OK.
Install the Server Tools
Install SSCEServerTools_x64-ENU.msi or SSCEServerTools_x86-ENU.msi
Important steps:
The checkmarks in this steps reflects the version of the SQL Server Replication components installed on the system, I my case only SQL Server 2008 replication components are installed.
Otherwise, just click Next, Next…
Create the publication and configure for SQL Compact subscribers
Go ahead and do this. See http://msdn.microsoft.com/en-us/library/ms171780(v=SQL.100).aspx
Configure the agent - run Configure Web Syncronization Wizard
Run "C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\SQL\ConnWiz.exe" (you can use the shortcut in Start, All Programs, Microsoft SQL Server Compact 3.5).
Complete the Wizard.
Test the agent
Run: http://mypc/ssce35/sscesa35.dll in your browser.
You may encounter this error:
If this happens, try to remove the web.config file from your root web folder (c:\inetpub\wwwroot). This worked for me.
If the test succeeds, you are good to go:
You can now use SQL Server Management Studio to test your publication, before testing on other machines and devices.
Create a new SQL Server Compact Database, and run the New Subscription Wizard to test it.
4 kommentarer:
Hello Erik,
I followed your post carefully. After the uninstall of sqlce 3.1 and install of sqlce 3.5 sp2, I lost the hability of connect to a sqlce database from Studio Management (2008).
I've search but I can't figure out how I correct this problem. Any ideas?
You uninstalled too much! - See http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/31ddcfa8-c566-49c7-ad19-74b1a651e1af/
Erik,
In my search for a solution to a connection problem with SQL CE 3.5 sp2 server tools, I found this blog entry. I have a successful connection to the dll with ?Diag option in URL, and I can connect to the database remotely using credentials. However, the error log, set at level 3, provides only generic error messages ( Hr=80070585 ERR:Failure reading Transport version header 0
Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1)
Can you recommend any diagnostic tools or reference sources for tracing what happens between the dll under IIS 7 and sql server 2008 r2?
Than you.
Rick
Suggest you ask in the MSDN forum - firewall/proxy??
Post a Comment