Setting Up Windows Access to Raw Devices

Windows systems restrict raw device access to user accounts with Administrator privilege.

To run the SAP Sybase IQ servers using an account that lacks Administrator privilege, you must enable new device access permissions for that account after each system reboot.

The rawaccedit utility sets permissions for devices for the current session.

Set up read-write access for the write servers and read access for query servers.

  1. Type the following at a command prompt:
    rawaccedit
  2. In the IQ Raw Device Access window, type the name of the user and the device to which you want to grant access.

    You can use Alt+N to tab to the User's Name box and Alt+D to tab to the Raw Device Name box.

    Option Description
    To specify... Type...
    An unpartitioned raw device Type the physical drive number.

    Unpartitioned drives are named \\.\PhysicalDriveN, where N is a number starting with 0. To find the physical drive numbers, Run Accessories > System Tools > System Information.
    A partitioned raw device Type the letter assigned to that partition.
  3. Click Add.
  4. Correct any errors in the user name and device name that display in the top panel and click Update ACL and Exit.

Device access permissions remain until you reboot Windows.

Parent topic: Multiplex Storage Requirements