Set ODBC Permissions
For individuals that are not administrators or "Power Users" on there system it will be necessary to set permissions for a key in the system registry. This is necessary to allow FPS to connect to databases through an ODBC connection. Without these permissions the user will be unable to create the temporary key in the registry that ODBC stores database connection information.
Steps to Update Registry Permissions
Standard Method
- Open the registry by running REGEDIT from the start menu or command prompt.
- navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
- and on 64-bit installations:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ODBC
- right click on the "ODBC" key
- select "Permissions..."
- Select "User" from the list of groups and users
- Click "Allow" Full Control in the permissions section
- Click "OK"
- Exit the registry editor
The results should be immediate. However, if they are not reboot your machine.
Advanced Method
THIS IS AN ADVANCED METHOD TO SET REGISTRY PERMISSIONS. THIS IS NOT SUPPORTED BY FBRI AND THE USER MAY USE AT THERE OWN RISK.
First you will need the SubInAcl[1] utility from Microsoft
once you have downloaded the utility the following commands can be used to set permissions from a script or the command prompt.
SUBINACL /subkeyreg HKEY_LOCAL_MACHINE\SOFTWARE\ODBC /grant=Everyone=F SUBINACL /subkeyreg HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ODBC /grant=Everyone=F
Notes:
- ↑ http://www.microsoft.com/download/en/details.aspx?id=23510 visited 2012/03/11