Enabling Logging by Using SQL Server Compact Edition Server Agent

The Microsoft SQL Server Compact Edition Server Agent can log errors, warnings, and informational messages to a log file on the computer running Microsoft Internet Information Services (IIS). By default, logging is not available. When logging is enabled, the sqlcesa30.log file is written to the IIS virtual directory for SQL Server Compact Edition. The information recorded in the log can be useful for diagnosing remote data access (RDA) or replication problems.

Enable logging by the SQL Server Compact Edition Server Agent

1. Create the following registry key, if it does not already exist:
   HKLM\Software\Microsoft\MSSQLSERVERCE\3.0\Transport

2. Under the HKLM\Software\Microsoft\MSSQLSERVERCE\3.0\Transport key, create a DWORD key value. The name of the key value must begin with the local path associated with the IIS virtual directory for SQL Server Compact Edition. For example, if Sqlcesa30.dll is located in the NTFS file directory C:\Inetpub\Sqlce\NorthWind, you must name the registry value C:\Inetpub\Sqlce\NorthWind\LOGGING_LEVEL. The data value of the DWORD key must be a value between 0 and 3. The data value contained in the registry entry controls the level of logging that the SQL Server Compact Edition Server Agent performs.
   The following table describes the data values that should be assigned to the registry key value to define the level logging:

   LOGGING_LEVEL value	Description
   0	Logging is not available.
   1	Log errors.
   2	Log errors and warnings.
   3	Log errors, warnings, and informational messages. Important   SQL Server Compact Edition Server Agent generates very large log files when you specify LOGGING_LEVEL 3. You should not use this logging level under usual circumstances, but it is useful when you are attempting to diagnose a problem.

See Also

Tasks

Understanding the SQL Server Compact Edition Server Agent Log

Help and Information

Getting SQL Server Compact Edition Assistance