CI and MS SQL how to connect ?

[eluser]timpisti[/eluser]
Hi (sorry for bad english).

MS-SQL (MS) and PHP (Mostly Linux) using in same time is always a difficult thing.

First: Over 4-6 month of searching, I can't find a working solution to connect the MSSQL database with Windows autentication on PHP. There is some setting in php.ini at MSSQL part, but it's not seems to be working. It's not the CI problem, the mssql.connect function throw an error.

Second: You may create an SQL user for PHP to connect a database. Bad point: You'll miss the windows authentication. Good: Commonly used for everywhere, with a very little security risk.

Third: You may use ODBC connection. The CI work properly with that.

Good luck.