Share via


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

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)