OTRS + IIS + MSSQL

Moderator: crythias

Locked
skywww
Znuny newbie
Posts: 15
Joined: 19 Jun 2013, 13:56
Znuny Version: 3.2.8

OTRS + IIS + MSSQL

Post by skywww »

Hello.
We want to test OTRS for our organization.
Can you help me - where can I find otrs installer with IIS and MS SQL with possibility of choosen IIS as a web server and MSSQL as a DB server ?
(IIS 7.5 on Windows Server 2008 R2 and MS SQL 2008 R2 SP2CU4 on another Windows Server 2008R2)

Here http://www.otrs.com/ru/programmnoe-obes ... taller-30/ is written

New: Choose between the bundled Apache web server or the Microsoft IIS Web Server. The OTRS Windows Installer will install IIS if needed, and will configure it for the usage with OTRS. Additionally the updated Web Installer works correctly on Microsoft IIS as well.

New: Possibility to install other databases and the updated Web Installer supports PostgreSQL and Microsoft SQL Server as well.

But I tried to download this http://ftp.otrs.org/pub/otrs/otrs-3.2.8 ... -2.4.8.exe and this http://ftp.otrs.org/pub/otrs/otrs-3.2.8 ... -beta4.exe - there is NO possibility to choose IIS and MS SQL.

Where can I find true OTRS distributive for this ?

Thank's
OTRS 3.2.8 on Windows Server 2008 R2 + MS SQL 2008 R2 Database and IIS.
skywww
Znuny newbie
Posts: 15
Joined: 19 Jun 2013, 13:56
Znuny Version: 3.2.8

Re: OTRS + IIS + MSSQL

Post by skywww »

Up!
OTRS 3.2.8 on Windows Server 2008 R2 + MS SQL 2008 R2 Database and IIS.
juanfortegaa
Znuny newbie
Posts: 2
Joined: 27 Jun 2013, 00:14
Znuny Version: 3.2.2
Real Name: Juan Francisco Ortega
Company: Grupo Sega

Re: OTRS + IIS + MSSQL

Post by juanfortegaa »

Hello Skywww,

could you please share the way you installed OTRS in IIS + MSSQL?

I am just to start one project and this will be the environment to work in.....

I really appreciate your help

Juan F Ortega
skywww
Znuny newbie
Posts: 15
Joined: 19 Jun 2013, 13:56
Znuny Version: 3.2.8

Re: OTRS + IIS + MSSQL

Post by skywww »

Good Day.

Yes, I can share.
I succeeded with install to IIS and MS SQL software.
I used this doc for this - http://wiki.otterhub.org/index.php?titl ... _and_IIS_7 - it works but not exactly.

For success you should give write access for some Accounts: IUSR, Network Service and YOUROTRSSERVER$ (last one is a computer account) to folders:Perl (C:\Perl) and OTRS (C:\Program Files(x86)\OTRS).

It works.
OTRS 3.2.8 on Windows Server 2008 R2 + MS SQL 2008 R2 Database and IIS.
michaelh81
Znuny newbie
Posts: 25
Joined: 08 Jul 2013, 13:38
Znuny Version: 3.2.9

Re: OTRS + IIS + MSSQL

Post by michaelh81 »

Just out of interest what version of OTRS did you use to get it to work - 3.2.8? And was this the bundled version with the 3.0.1 windows installer? I've been trying and it just won't work. When I get to the web installer page it is blank.
advchris
Znuny newbie
Posts: 16
Joined: 04 Nov 2013, 18:19
Znuny Version: 3.2.5
Real Name: Chris Smith

Re: OTRS + IIS + MSSQL

Post by advchris »

I'm struggling to get this to work to on version 3.2.12

Followed this guide; http://wiki.otterhub.org/index.php?titl ... _and_IIS_7

And this guide; http://blogs.iis.net/wadeh/archive/2009 ... iis-7.aspx

I am getting HTTP Error 500.19 - Internal Server Error when browsing to http://localhost/otrs/customer.pl or http://localhost/otrs/index.pl from my IIS/OTRS server itself.

I don't get why this is not working now, Windows Firewall is turned off, no other websites are using the same ports and there does not seem to be anything obvious in the event logs either.
danny0312
Znuny newbie
Posts: 70
Joined: 08 Nov 2013, 00:14
Znuny Version: OTRS 3.2

Re: OTRS + IIS + MSSQL

Post by danny0312 »

Does it say anything about perl or Isapi Modules on the error page?

If so, make sure you installed all the components inside IIS ..asp.net, cgi, isapimodules, etc...
Version: OTRS & ITSM 3.3.8
OS: Windows Server 2012
DB: MS SQL 2012
Web Server: IIS 8
Locked