
Hi , please help me with configuring sqlserver2005 to Otrs. i have added DSN ->system DSN connecting to OTRS in Config.pm. lndex.pl page is coming ,when i enter root@localhost and password.page can't found error is coming. Regds Ravi Shankar

Could you provide your config.pm and your logs?
Afshar Mohebbi
On Mon, May 18, 2009 at 7:17 PM, ravi shanker
Hi , please help me with configuring sqlserver2005 to Otrs. i have added DSN ->system DSN connecting to OTRS in Config.pm. lndex.pl page is coming ,when i enter root@localhost and password.page can't found error is coming.
Regds
Ravi Shankar
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Hi Afshar,
To start with, is Active perl installation must for sqlserver to work for OTRS?
i don't have active perl installation in my system.
#settings for mSsqlserver
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQLServer};Server=58.2.71.49,1433;database=otrs;uid=otrs;pwd=password;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'users'';
#--------------------------#
does config.pm checks "db.pm" by anyway.
pls send any working config.pm,it would be of great help.thanks in advance afshar
Ravi Shankar
________________________________
From: Afshar Mohebbi

Hi Ravi,
You won't need ActivePerl; you can run OTRS with Microsoft SQL Server on any
perl distribution, just as long as it is Perl 5.8 or 5.10. The major perl
distributions for win32 are Strawberry Perl and Activestate Perl.
To connect using ODBC you'd have to have DBD::ODBC module installed. You
should see no error message if you'd issue the following statement:
perl -e"use DBD::ODBC;"
Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
On Tue, May 19, 2009 at 18:46, ravi shanker
Hi Afshar, To start with, is Active perl installation must for sqlserver to work for OTRS? i don't have active perl installation in my system. #settings for mSsqlserver $Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=58.2.71.49,1433;database=otrs;uid=otrs;pwd=password;"; $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseUserTable} = 'users''; #--------------------------#
does config.pm checks "db.pm" by anyway. pls send any working config.pm,it would be of great help.thanks in advance afshar
Ravi Shankar
------------------------------ *From:* Afshar Mohebbi
*To:* User questions and discussions about OTRS. *Sent:* Tuesday, May 19, 2009 10:17:04 AM *Subject:* Re: [otrs] (no subject) Could you provide your config.pm and your logs?
Afshar Mohebbi
On Mon, May 18, 2009 at 7:17 PM, ravi shanker
wrote: Hi , please help me with configuring sqlserver2005 to Otrs. i have added DSN ->system DSN connecting to OTRS in Config.pm. lndex.pl page is coming ,when i enter root@localhost and password.page can't found error is coming.
Regds
Ravi Shankar
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (3)
-
Afshar Mohebbi
-
Michiel Beijen
-
ravi shanker