Install using Apache and MSSQL

[advchris]

I give up trying to install using IIS now so I am going to go for using Apache and then try to connect this to MSSQL db.

All that I need to know is how to connect OTRS to MSSQL via Apache. I can't find much on the net so if someone could just point me in the right direction or paste in here any code that would be much appreciated.

I have spent nearly 3 days trying to get OTRS to work with IIS and had no luck so I am jumping ship to Apache and if that fails I will jump ship to Spiceworks!!!

[advchris]

I have just installed OTRS on a server with IIS service stopped but the installer didn't install Apache 2.2

I have just used the same installer file on my local PC and it installed Apache 2.2 - what am I missing here?

I just want to install OTRS with Apache and then point it to an already existent MSSQL database...

[wurzel]

Hi,

install it from windows installer with apache. Try to geht the mysql database running first.
Read documentation for connecting MSSQL Databsase. (read the README files)

You will get bad performance with Windows, Apache and MSSQL.
I would not use this combination.

Flo

[advchris]

Thanks, got this working now. Just in the process of trying to integrate it with Active Directory.

How poor performance are we talking? It seems to run reasonably quick so far...

What setup would you recommend?

[wurzel]

Hi,

your response times of the system will be slow with more tickets/user/agents...

recommended is a linux based system with postgres or mysql.

Flo