← Back to Knowledge Base

KB #240008: How to access encrypted databases on a RAW Volume

⏱️ 2 min read
Type: Information
Summary:
This article explains how to allow SQL Server to access encrypted databases located on a RAW volume.

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, read the Microsoft Knowledgebase article MS KB256986 Description of the Microsoft Windows Registry.

Additional Information:
In order to preserve resources, Encryptionizer by default comes with RAW volume access disabled when running on NT, 2K or XP.You can enable RAW volume access by modifying the following DWORD registry Value:

HKLMSYSTEMCurrentControlSetServicesnlemsqlInclude

This DWORD value has the following meaning:

Value Device
0x0001 Local Drive
0x0002 Networked (remote) Drive
0x0004 CDROM/DVD
0x0010 Raw

To specify more than one device, add the two values together. For example, to process encrypted files on local drives and RAW volumnes, specify 0x00011. If omitted the default is 0x0003 (local drives). However, if you specify a value, you must specify all devices that may have encrypted files on them, not just the additional devices. For example, if you specify 0x0010, then only encrypted files on RAW volumnes can be accessed.

After changing this registry value, you must reboot the server in order for the change to take effect.

Note that this affects dynamic encryption only. It does not affect file APIs such as N_ENCODEFILE, N_DECODEFILE and N_RECODEFILE.

 

Was this article helpful?

Related Articles

KB #240067: Using 3GB Switch in BOOT.INI may cause I/O errors (event ID: 1181)

Type: Information Summary: Using the 3GB switch in boot.ini will severely restrict kernel memory and…

KB #240103: Log Shipping with Encryptionizer (driver v2010.201.10 and later)

Type: Information Summary: Encryptionizer for SQL FIPS 140-2 Validated supports Log shipping using an AES…

KB #240047: Encrypted values in var char column are randomly decrypting incorrectly

Type: Tip Summary: Values in a varchar column are, seemingly randomly, not decrypting to the…

Still need help?

Our support team is here to assist you.

NetLib Security
AI Assistant · Online
Hi! I'm the NetLib Security assistant. I can answer questions about our encryption solutions, HIPAA compliance, Encryptionizer, and more. How can I help you today?