Notes on using SQL/R on Windows Vista ------------------------------------- SQL/R A.02.77 and newer have been tested on Windows Vista. Previous versions are expected to work but have not been tested explicitly. Please note that Windows Vista by default protects all files and directories below the Program Files directory. Even if logged-on as administrator it is not possible to use a text editor such as Notepad to edit files below the Program Files directory. Depending on which editor program is used, Windows Vista either displays a "permission denied" error message or "virtualizes" the file (i.e., redirects it into a subdirectory below the user-specific %LOCALAPPDATA%\VirtualStore directory). This affects SQL/R because by default the SQL/R configuration files are located in the "Marxmeier\SQLR\etc" subdirectory below the Program Files directory. As a consequence it is no longer possible to edit the SQL/R configuration files, even if logged-on as administrator, without using cumbersome workarounds such as editing the files in a different directory and then copying them back. Starting with SQL/R A.02.77, the SQL/R installation program solves these problems by creating a local Windows group named "SQLR Administrators". The user who installs SQL/R is then made a member of this group. The "SQLR Administrators" group has modify/delete permissions on the SQL/R configuration subdirectory (by default C:\Program Files\Marxmeier\SQLR\etc) and all contained files. It also has modify/delete permissions on the sqlrodbc.ini file located in the Windows directory. This enables all members of the "SQLR Administrators" group to edit the SQL/R configuration files without restrictions. Please note: If SQL/R is installed on Vista for the first time, after the installation program has finished it is required to log-off and log-on so that the new "SQLR Administrators" group membership becomes effective. If additional users should be able to modify the SQL/R configuration, just add them to the local "SQLR Administrators" group. To do this: 1) Open the Computer Management Console From the Start Menu, navigate to: Control Panel -> Administrative Tools -> Computer Management Alternatively, from the start menu, open: All Programs -> Accessories -> Run Then enter "compmgmt.msc" and click OK. 2) In the left pane, choose Local Users and Groups -> Groups 3) In the right pane, locate the "SQLR Administrators" group and open its properties with a doubleclick. The properties dialog allows to change the group's list of members. In case these users are currently logged-on they should then log-off and log-on to activate the new group membership.