INF: How to Enable Encryption Support for SQL Server CE Databases (814852)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition

SUMMARY

This article describes how to enable encryption support for SQL Server CE databases.

MORE INFORMATION

You can encrypt databases when you are using the SQL Server CE database engine. MIcrosoft Windows CE provides this support, and it is supported on all Pocket PC devices.

To enable encryption if you use Pocket PC 2000, install the Microsoft High Encryption Pack for Pocket PC. To download and install the Microsoft High Encryption Pack, visit the following Microsoft Web site:

Microsoft High Encryption Pack for Pocket PC v1.0
http://www.microsoft.com/mobile/pocketpc/downloads/ssl128.asp

If you use Pocket PC 2002, obtain the Rsaenh.dll file from the Pocket PC 2002 software development kit (SDK). Rsaenh.dll implements the security features of SQL Server CE. Rsaenh.dll is available as a redistributable .cab file in the Pocket PC 2002 SDK. To download and install the Pocket PC 2002 SDK, visit the following Microsoft Web site:

Pocket PC 2002 SDK
http://www.microsoft.com/mobile/developer/downloads/ppcsdk2002.asp

After you install the Pocket PC 2002 SDK, obtain the .cab file from the installation drive:\Windows CE Tools\Wce300\Pocket PC 2002\Support\EnhancedCrypto folder.

REFERENCES

For additional information about encrypting SQL Server CE databases, visit the following Microsoft Web sites:

Encrypting SQL Server CE Databases
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_encrypting_databases_579.asp

Changing Passwords and Encryption Settings for a Database
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_changing_passwords_and_encryption_settin_289.asp

For information about configuring Secure Sockets Layer (SSL) encryption, see the "Configuring SSL Encryption" topic in the SQL Server CE Books Online and the "Configuring SSL on Windows 2000" section in the "Security Models and Scenarios for SQL Server 2000 Windows CE Edition 2.0" white paper. To obtain this white paper, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_secmodelscen20.asp

Note The SQL Server CE Books Online and the white paper refer to the Rootcert.exe tool that is supplied with SQL Server CE. This file is installed in the Program Files\Microsoft SQL Server CE 2.0\Device\Processor family\Processor type folder. This tool is for Pocket PC 2000.

For Pocket PC 2002, use the AddRootCert.exe tool. For additional information about root certificates for Pocket PC 2002 users and to download the AddRootCert.exe tool, click the following article number to view the article in the Microsoft Knowledge Base:

322956 Sample to Add Root Certificates to Pocket PC 2002

For additional information about security models and scenarios for SQL Server CE, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_secmodelscen20.asp

Modification Type:MajorLast Reviewed:9/10/2004
Keywords:kbSecurity kbsetup kbinfo KB814852 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.