[otrs] Changing MySQL to MSSQL

17 Sep 2009

      Hi,

I am changing MySQL to MSSQL and need some assistance if I may.

I have created the database and set up a login for OTRS in my MSSQL.  I
have changed the config.pm file as per below:

# DatabaseHost

    # (The database host.)

    $Self->{DatabaseHost} = '[IP or name to your Database]';

    # Database

    # (The database name.)

    $Self->{Database} = 'otrs';

    # DatabaseUser

    # (The database user.)

    $Self->{DatabaseUser} = 'otrs';

    # DatabasePw

    # (The password of database user. You also can use
bin/CryptPassword.pl

    # for crypted passwords.)

    $Self->{DatabasePw} = '[password to sql server for user otrs]';

    # DatabaseDSN

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

    $Self->{DatabaseDSN} = "DBI:ODBC:otrs";

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

Perl-DBD-ODBC has also been installed.

I ran CheckDB.pl and I'm getting the following error, can anybody please
help me.  Do I have to change another file?

DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data
source name not found, and not default driver specified

Can anybody help?

Thanks

Rosanna

[otrs] Changing MySQL to MSSQL

Marretta, Rosanna