Freeradius 3.0.17 Unable to connect mssql database with iodbc

[Alan DeKok]

On Nov 17, 2018, at 7:42 AM, Giovanni Di Giorgio <gioele01 at gmail.com> wrote:
> 
> "test" is the name of the data source, not the hostname of the mssql server
> and I think that freeradius uses this reference at startup, if the "iodbc"
> driver has been set in the "sql" configuration file. Infact if i set ,in
> the "server" parameter, any value other than "test" I get:
> "
> rlm_sql_iodbc: SQLConnectfailed
> rlm_sql_iodbc: IM002: [iODBC] [Driver Manager] Data source name not found
> and no default driver specified. Driver could not be loaded
> "

  That's an error from the iODBC library.  It means that you've misconfigured the data it needs.

  Just typing that error into Google gets a FAQ:

http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ#%5BiODBC%5D%5BDriver%20Manager%5DData%20source%20name%20not%20found%20and%20no%20default%20driver%20specified.%20Driver%20could%20not%20be%20loaded%2C%20SQLSTATE%3DIM002

  Alan DeKok.