Creating ODBC DSN Fails: ODBC System DSN Warning : You Are Logged On With Non-Administrative Privileges. System DSNs Could Not Be Created Or Modified

News Knowledge Base
1

Resolution when "Creating ODBC DSN fails: ODBC System DSN Warning : You are logged on with non-Administrative privileges. System DSNs could not be created or modified " .

Some installations of MS Office block the creation of System DSNs and programs cannot be run as administrator.

Resolution: To work around this Microsoft issue, run odbcad32.exe as administrator manually. Then continue with adding DSN before returning to MS Excel to link tables:

  1. Click Start.
  2. In "Search programs and files" enter "odbcad32.exe"
  3. Right click "obdcad32.exe" and select "Run as administrator"
  4. Continue the procedure to add.