Kieth, On Fri, 2007-11-16 at 14:07 +1100, Keith Bannister wrote:
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.
I am happy that it is working for you.
The procedure to install in OTRS 2.2.4 in windows IIS 5.0 and MS SQL Express was:
Are you using a W2K3 server? If not, which Windows machine are you using?
-. 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@localhost password root
Is this worth adding to faq.otrs.org?
I will test this for your today, and add it to the faq if your process is working here to. ((enjoy)) Shawn Beasley -- ((otrs)) :: OTRS AG :: Europaring 4 :: 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftssitz: Bad Homburg Amtsgericht Bad Homburg, HRB 10751 Steuernummer: 003/240/97505 Aufsichtsratsvorsitzender: Burchard Steinbild Vorstandsvorsitzender: André Mindermann