Which ((otrs)) version are you using? Which web server are you using?
Working now! The trick is to not use a standard ActivePerl download but
use the activeperl that's installed with the OTRS windows installer.
The procedure to install in OTRS 2.2.4 in windows IIS 5.0 and MS SQL
Express was:
-. run the OTRS windows installer .exe (assume it installs to c:\otrs)
-. Stop apache and mysql (run c:\Otrs_stop.bat)
-. Start IIS and SQL server Express
- Create IIS virtual directory pointing at c:\otrs\otrs\bin\cgi-bin
- For the otrs directory, add mapping for .pl to
c:\otrs\perl\bin\perl.exe %s %s
- Modify c:\otrs\otrs\scripts\database\*mssql.sql replacing system_user
to system_user2
- In SQL server management tool Create 'otrs' database
- Import SQL data into database
- create otrsroot user (using SQL authentication)
-. Set owner of otrs database to otrsroot user
-. Modify Config.pm according to:
$Self->{Home} = 'C:/OTRS/otrs';
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL
Server};Server=myservername\\sqlexpress;database=otrs;uid=otrsroot;pwd=mypassword;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'system_user2';
$Self->{DatabaseUser} = 'otrsroot';
$Self->{DatabasePw} = 'mypassword';
- Hit index.pl and hope it works. login with [EMAIL PROTECTED] password root
Is this worth adding to faq.otrs.org?
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/
