← 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 #240102: Encrypted Databases not accessible (Recovery Pending, Suspect)

Type: Information Summary: Your encrypted SQL databases are not accessible after you have started SQL…

KB #240049: Error 5172 ‘FILE SIZE Property is incorrect’ when attaching a database

Type: Fixed Summary: Under certain conditions you may get the following error when attempting to…

KB #240095: User not being prompted to enter key when SQL starts

Type: Information Summary: Even though “??” was specified as the key when building the security…

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?