Tried but no luck.

Also this is my DSN string.

    $Self->{DatabaseDSN} = "DBI:ODBC:driver={mssql};server=10.5.0.46;database=otrs;uid=otrs;pwd=Password123;";

    $Self->{"Database::Type"}='mssql';

    $Self->{DatabaseUserTable} = 'users';

Is there something I am missing?  Any guidance would be great.

Trust that all thing would work out for the good.
Keep standing. Keep believing. Keep hoping. Keep moving forward.

Advertise Your goods and services for free on Trin e-Ads
http://www.trin-e-ads.com

On Wed, Jan 16, 2013 at 11:11 AM, Gerald Young <crythias@gmail.com> wrote:

Start here: https://www.google.com/search?q=site:forums.otterhub.org+mssql

On Wed, Jan 16, 2013 at 9:28 AM, Bevan Agard <bevan.agard@gmail.com> wrote:

Guys & Gals

I need some help here. I am trying to setup OTRS ITSM to prove to my boss that it can do as good if not better job than Maximo.  The problem is that they want me to set it up utilizing our existing MS SQL 2005 database.

I have OTRS installed on a CentOS 6.3 server. I followed all the instruction I found everywhere and from the command line using isql, it works. I even found a perl script to test if my configuration outside of OTRS is good and that works too.  However when I run CheckDB.pl it gives me the following:

[root@tetron otrs]# bin/otrs.CheckDB.pl

DBI connect('mssql;uid=otrs;pwd=Password123;','otrs',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) at /opt/otrs/Kernel/System/DB.pm line 256

ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Jan 16 10:17:50 2013

 Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)

 Traceback (31291):

   Module: Kernel::System::DB::new (v1.144.2.2) Line: 227

   Module: bin/otrs.CheckDB.pl (v1.4) Line: 52

Trying to connect to database

DSN: dbi:ODBC:mssql;uid=otrs;pwd=Password123;

DatabaseUser: otrs

No database connect!

===================================================

This is my 

#/etc/odbc.ini

[mssql]

Driver  = FreeTDS

Servername =mssql

Port    = 1433

Database = otrs

#/etc/odbcinst.ini

# Driver from the mssql-connector-odbc package

# Setup from the unixODBC package

[FreeTDS]

Description     = ODBC for Microsoft SQL

Driver          = /usr/lib64/libtdsodbc.so.0

Setup           = /usr/lib64/libtdsS.so

UsageCount      = 1

Threading       = 2

#/etc/freetds.conf

[mssql]

host = otrs-mssql

port = 1433

tds version = 7.0

dump file = /var/log/freetds.log

This is really frustrating and I can't seem to figure this out. Does anyone out there have any clues. Any guidance would be appreciated.

Trust that all thing would work out for the good.
Keep standing. Keep believing. Keep hoping. Keep moving forward.

Advertise Your goods and services for free on Trin e-Ads
http://www.trin-e-ads.com

---------------------------------------------------------------------
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

---------------------------------------------------------------------
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

---------------------------------------------------------------------
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