Microsoft SQL should be installed on a Microsoft Windows Server.

Of course, your OTRS installation can run on Linux, but if your database is running MSSQL then it is installed on a Windows server. That is where you need to configure the DSN –

On the Windows server

Click Start > Control Panel > Administrative Tools > Data Sources (ODBC)

Click the second tab labeled - System DSN

Proceed through the wizard – it is a fairly easy / self-explanatory wizard.

You definitely should configure the System DSN – if that doesn’t work, there may be some other issues getting a Linux box to communicate with the Windows / MSSQL server, but my Linux / Windows interaction experience is limited to Samba, which I don’t think would apply in this case. Remember, Google is your friend! J

Good luck (still),

Nathan Campbell
Systems Administrator
Dallas Symphony Orchestra
Morton H. Meyerson Symphony Center
Schlegel Administrative Suites
2301 Flora Street
Dallas, Texas 75201

214-871-4026 - phone
214-953-1218 - fax
n.campbell@DalSym.com
www.dallassymphony.com

"To entertain, inspire and change lives through musical excellence"
Click Here To Buy Tickets

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna
Sent: Thursday, September 17, 2009 10:34 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Changing MySQL to MSSQL

Thank you very much for your email. I haven't set up the System DSN, would make sense! We are using Linux Suse server, do you know how to do this as I'm very new to linux.

Thanks,

Rosanna

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nathan Campbell
Sent: 17 September 2009 15:48
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Changing MySQL to MSSQL

Did you create a System DSN in the ODBC settings on the server running the OTRS MSSQL SQL instance? It looks like you would have, but just in case:

(Forgive if this is more information that you need – you probably know all of this – more for posterity and others in the future.)

In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN – whatever you name the DSN is the value to enter in your config.pm file:- it does not have to match the actual database name.

For instance, my SQL server is named IMUDD, the database itself is named otrs, but the value I enter in the config.pm file is SQLOTRS because that is what I named the System DSN on the SQL Server.

Also, try using the value below for $Self->{DatabaseDSN} instead of DBI:ODBC:otrs -

$Self->{'DatabaseHost'} = 'IMUDD';

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

$Self->{'DatabaseUser'} = 'mssql-user-name';

$Self->{'DatabasePw'} = 'super-secret-password';

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

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

Good luck!

Nathan Campbell
Dallas Symphony Orchestra

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna
Sent: Thursday, September 17, 2009 9:35 AM
To: otrs@otrs.org
Subject: [otrs] Changing MySQL to MSSQL

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