Using Internet Explorer to Check the Server Agent Configuration (SQL Server Compact)
You can use Microsoft Internet Explorer to verify that you have configured the Microsoft SQL Server Compact 3.5 Server Agent (Sqlcesa35.dll) correctly. In Internet Explorer, enter the URL for the SQL Server Compact 3.5 Server Agent (for example, http://sqlservername/sqlce/sqlcesa35.dll, where sqlce is the virtual directory). If the SQL Server Compact 3.5 Server Agent is configured correctly, Internet Explorer displays the string: "Microsoft SQL Server Compact 3.5 Server Agent". You can find diagnostic and statistical details by using ?diag and ?stat parameters at the end of the URL. For more information, see Using SQL Server CompactEdition Server Agent Statistics to Troubleshoot Connectivity and Using SQL Server Compact Server 3.5 Agent Diagnostics to Troubleshoot Connectivity.
You can also use Internet Explorer to verify that Microsoft Internet Information Services (IIS) security is working as you intended. If you configured IIS to require Basic authentication, Internet Explorer should prompt you for your user name and password before displaying a response. If you configured IIS to use Secure Sockets Layer (SSL) encryption, the URL must specify HTTPS instead of HTTP.
When you use Internet Explorer to verify IIS security, you must close and reopen Internet Explorer each time you change any IIS security setting. Opening a new instance of Internet Explorer ensures that a new connection to IIS is established, instead of reusing an existing connection.
Describes how you can use SQL Server Compact 3.5 Server Agent diagnostics to troubleshoot connectivity issues.
Describes how you can use SQL Server Compact 3.5 Server Agent statistics to troubleshoot connectivity issues.