Using SQL Server Compact Server 3.5 Agent Diagnostics to Troubleshoot Connectivity
You can obtain diagnostic information about the SQL Server Compact 3.5 Server Agent configuration by using Internet Explorer. Append ?Diag to the URL that addresses the SQL Server Compact 3.5 Server Agent, for example, http://sqlservername/sqlce/sqlcesa35.dll?diag.
A Web page is displayed with five tables that provide useful information about the SQL Server Compact 3.5 Server Agent configuration. Table entries in red indicate potential problems. Green indicates a normal condition. If a Web page is not displayed, the Internet Information Services (IIS) server is not configured properly. Each of the five tables is described below.
General Information
This table provides general information about the virtual directory.
| Item | Description |
|---|---|
Server Name |
Specifies the name of the IIS server pinged in the URL. |
URL |
Displays the Portion of the URL minus the http://sqlservername and the ?diag parameter. This is the value that IIS returns when the URL is requested. |
Authentication Type |
Specifies the authentication type supported by SQL Server Compact 3.5. It can be Anonymous, Basic, or Windows Integrated. |
Server Port |
The port configured for the Web site under which the virtual directory was created. The default Web site uses port 80. |
HTTPS |
Specifies if the virtual directory is configured for SSL. |
Server Software |
Specifies the version of IIS. |
Replication |
Specifies if replication is enabled. This functionality is controlled by the USAGE registry key and defaults to both replication and RDA being enabled. |
RDA |
Specifies if RDA is enabled. This functionality is controlled by the USAGE registry key and defaults to both replication and RDA being enabled. |
Logging Level |
Specifies the logging level of the SQL Server Compact 3.5 Server Agent. This functionality is controlled by the LOGGING_LEVEL registry key and defaults to 1 (errors). |
Impersonation and Access Tests
This section provides information about the ability of the user to access information on the disk as that specific user.
| Action | Description |
|---|---|
Impersonate User |
Specifies whether the SQL Server Compact 3.5 Server Agent was able to impersonate the user who executed the ping command. All replication and RDA operations are executed under the user who is making the request by using IIS, so the actual user name that is used depends on the Authentication type of the virtual directory. |
ReadWriteDeleteMessageFile |
Specifies whether the impersonated user has appropriate access to the content folder on an NTFS file system drive to perform synchronization. |
SQL Server Compact 3.5 Modules Test
This table provides information about the SQL Server Compact 3.5 Server components being installed and registered properly.
| Module | Description |
|---|---|
SQLCERP35.DLL |
Specifies whether the SQL Server Compact 3.5 Replication Provider is installed and registered properly. |
SQLCESA35.DLL |
Specifies whether the SQL Server Compact 3.5 Server Agent is installed and registered properly. If the Server Agent is not installed properly, this diagnostics page cannot be accessed. |
Reconciler Test
This table provides information about the SQL Server Database Reconciler functionality.
| Reconciler | Description |
|---|---|
10.0 Database Reconciler |
Specifies whether the SQL Server Merge Replication Reconciler (replrec.dll) is installed and registered properly. Replication synchronization to SQL Server 2008 cannot occur if the SQL Server 2008 replication components are not installed on the computer running IIS. |
9.0 Database Reconciler |
Specifies whether the SQL Server 9.0 Reconciler is installed and registered properly. Replication synchronization to SQL Server 9.0 cannot occur if the SQL Server 9.0 replication components are not installed on the computer running IIS. |
SQL Module Versions
This table helps identify the versions of the dependent SQL Server components on the computer running IIS. If the reconciler test fails for a particular version in the Reconciler Test table, those versions of the replication components are not listed in this table.
| Module | Description |
|---|---|
sqloledb.dll |
Specifies the version of the SQL Server OLE DB Provider. |
10.0 replrec.dll |
Specifies the version of the SQL Server Merge Replication Reconciler. |
10.0 replprov.dll |
Specifies the version of the SQL Server Merge Replication Provider. |
10.0 msgprox.dll |
Specifies the version of the SQL Server Merge Replication Message Proxy Provider. |
9.0 replrec.dll |
Specifies the version of the SQL Server 9.0 Reconciler. |
9.0 replprov.dll |
Specifies the version of the SQL Server 9.0 Replication Provider. |
9.0 msgprox.dll |
Specifies the version of the SQL Server 9.0 Message Proxy Provider. |
See Also
Tasks
Using Internet Explorer to Check the Server Agent Configuration (SQL Server Compact)
Using SQL Server Compact Server Agent Statistics to Troubleshoot Connectivity