Installation using IIS

[advchris]

I have installed OTRS and setup IIS as per this KB http://wiki.otterhub.org/index.php?titl ... _and_IIS_7

However I still cannot get this to work! I am using our own in house MS SQL Server for the database side of things which again has been setup as per KB.

I get a fatal error when trying to load the Agent portal;

Backend ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: MSWin32 Time: Mon Nov 4 15:49:03 2013 Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (1112): Module: Kernel::System::DB::new (OTRS 3.2.5) Line: 224 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.5) Line: 140 Module: PerlEx::Precompiler::c_::program20files2028x8629::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

And for the customer portal I am just getting the usual HTTP 500 Internal Server Error.

Any ideas on where I am going wrong here? This is quite frustrating as the KB's aren't particularly helpful and there is barely anything else on the net resource wise apart from this forum.

Thanks in advance!

[jojo]

I strongly advise not to use MS SQL and IIS for OTRS. Windows is not a sustainable plattform for PERL based webbased software. Also OTRS is extremly slow on MS SQL as there is no PERL database driver!

If you are not familiar with Linux and other databases you should try the OTRS Appliance

[advchris]

Thanks for your response it is much appreciated but these are the technologies I have been asked to use due to the in house staff skill sets we have. Our DB developers want it to be on an MS SQL platform along with all other company DB's. One of the developers has mentioned about using the freeTDS as the driver?

Given what I have to work with can anyone give me any advice on these issues?

[crythias]

SQL Server does not exist or access denied

RemoteAddress: ::1

[advchris]

Which means?

The SQL Server does exist and as far as I am aware access is not denied... what does remote address 1 mean though?

Am I right in saying that you just specify the SQL server address in the config?

[crythias]

Which means?

It means the server specified in the config cannot be reached.

[jojo]

FreeTDS will not work for writing...

[advchris]

I am going to uninstall the software and reinstall with the latest version and scrap using IIS and just use Apache but connect to a MS SQL database.

Apart from running the installer what else is it that I would need to do to connect to the MS SQL database?

The only thing I know to do so far is to edit the config.pm file and enter connection details like so;

# The database DSN for Microsoft SQL Server - only supported if OTRS is
# installed on Windows as well
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Database=$Self->OTRS;Server=$Self->'SERVERNAMEHERE',1433";

Is this right?

[crythias]

You could check out the wiki article
There are other forum articles that also address MS SQL.