OTRS 3.1.11, MSSQL 2008 R2, FREETDS, UBUNTU 12.10

[nickyo]

I have all of the components working to integrate Ubuntu 12.10, MSSQL Server and OTRS using the unixODBC/FreeTDS combination. The issue I have is the error stating that the 'SessionID is invalid' on my first log in as root@localhost. In the syslog, the error states:

'Dec 13 03:15:38 <servername> OTRS-CGI-10[4223]: [Error][Kernel::System::AuthSession::DB::GetSessionIDData][Line:161]: [unixODBC][FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (SQL-42000), SQL: 'SELECT session_value FROM sessions WHERE session_id = ?'

I have tried setting the tds_version = 8.0 in both the /etc/freetds/freetds.conf file and the /etc/odbc.ini file.

[jojo]

having MS SQL as database backend for a unix based frontend is officially not supported. (I I stongly recmmend not to use MS SQL for OTRS)

[nickyo]

That is unfortunate. I understand the reasoning behind it, but is there any awareness you have to a solution to this problem? If, in the corporate world, you are supporting a collection of Microsoft systems, and you have purchased licensing for MSSQL, and you have your entire BI infrastructure using MSSQL, but you don't want to further proliferate the M$haft paradigm, what recourse do I have but to run LA-MSSQL-Perl for OTRS? Any help is appreciated.

[crythias]

http://php.net/manual/en/function.mssql-query.php