Article ID: 814852 - Last Review: November 14, 2007 - Revision: 3.4

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

Retired KB Content Disclaimer

View products that this article applies to.

Expand all | Collapse all

SUMMARY

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

Back to the top

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/spain/windowsmobile/downloads/highencryption.mspx (http://www.microsoft.com/spain/windowsmobile/downloads/highencryption.mspx)

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/downloads/details.aspx?familyid=2dbee84a-bd94-4167-b817-2b2e548b2e92&displaylang=en (http://www.microsoft.com/downloads/details.aspx?familyid=2dbee84a-bd94-4167-b817-2b2e548b2e92&displaylang=en)

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.

Back to the top

REFERENCES

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

Encrypting SQL Server CE Databases
http://msdn2.microsoft.com/en-us/library/aa237941(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa237941(SQL.80).aspx)

Changing Passwords and Encryption Settings for a Database
http://msdn2.microsoft.com/en-us/library/aa237871(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa237871(SQL.80).aspx)

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://msdn2.microsoft.com/en-us/library/aa224604(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa224604(SQL.80).aspx)

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 (http://support.microsoft.com/kb/322956/EN-US/ ) 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://msdn2.microsoft.com/en-us/library/Aa224604(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/Aa224604(SQL.80).aspx)

Back to the top

APPLIES TO

Microsoft SQL Server 2000 Windows CE Edition

Back to the top

kbsecurity kbsetup kbinfo KB814852

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top