[otrs] Can't login to OTRS 2.2.4 on Windows XP IIS with MSSQL

Keith Bannister keith.bannister at fleximeals.com.au
Fri Nov 16 14:07:48 GMT 2007


> 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 root at localhost password root

Is this worth adding to faq.otrs.org?







More information about the otrs mailing list