Connect OTRS 4.0.5 Appliance to MS SQL Server

esaunders · Post by **esaunders** » 29 Jan 2015, 02:00

I'm attempting to connect a brand new OTRS appliance VM to our MSSQL 2012 server. I've made the following changes to my Config.pm:

Code: Select all

$Self->{DatabaseHost} = '172.16.151.45';
$Self->{Database} = 'OTRSDEV';
$Self->{DatabaseUser} = 'otrsuser';
$Self->{DatabasePw} = 'otrs';
	$Self->{SecureMode}=1;
	$Self->{"Package::Timeout"}=120;
	$Self->{'SystemID'}=62;
	$Self->{'SessionName'}='OTRSAgentInterface';

$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Database=$Self->{Database};Server=$Self->{DatabaseHost},1433";

and followed the instructions here

http://wiki.otterhub.org/index.php?titl ... _and_IIS_7

to create a new database and user. When I run otrs.CheckDB.pl on the appliance I get this:

Code: Select all

[Wed Jan 28 15:13:32 2015] otrs.CheckDB.pl: DBI connect('driver={SQL Server};Database=OTRSDEV;Server=172.16.151.45,1433','otrsuser',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) at /TARGET/SHARE/var/otrs/Kernel/System/DB.pm line 184
ERROR: OTRS-otrs.CheckDB.pl-62 Perl: 5.10.1 OS: linux Time: Wed Jan 28 15:13:32 2015

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

 Traceback (1583): 
   Module: Kernel::System::DB::new Line: 155
   Module: Kernel::System::ObjectManager::_ObjectBuild Line: 222
   Module: Kernel::System::ObjectManager::Get Line: 176
   Module: otrs.CheckDB.pl Line: 41

ERROR: OTRS-otrs.CheckDB.pl-62 Perl: 5.10.1 OS: linux Time: Wed Jan 28 15:13:32 2015

 Message: The constructor of Kernel::System::DB returned undef.

 Traceback (1583): 
   Module: Kernel::System::ObjectManager::_DieWithError Line: 529
   Module: Kernel::System::ObjectManager::_ObjectBuild Line: 233
   Module: Kernel::System::ObjectManager::Get Line: 176
   Module: otrs.CheckDB.pl Line: 41

The constructor of Kernel::System::DB returned undef. at /TARGET/SHARE/var/otrs/Kernel/System/ObjectManager.pm line 533
	Kernel::System::ObjectManager::_DieWithError('Kernel::System::ObjectManager=HASH(0x23e9d88)', 'Error', 'The constructor of Kernel::System::DB returned undef.') called at /TARGET/SHARE/var/otrs/Kernel/System/ObjectManager.pm line 233
	Kernel::System::ObjectManager::_ObjectBuild('Kernel::System::ObjectManager=HASH(0x23e9d88)', 'Package', 'Kernel::System::DB') called at /TARGET/SHARE/var/otrs/Kernel/System/ObjectManager.pm line 176
	Kernel::System::ObjectManager::Get('Kernel::System::ObjectManager=HASH(0x23e9d88)', 'Kernel::System::DB') called at otrs.CheckDB.pl line 41

and when I launch the WebUI I get this:

Code: Select all

Backend ERROR: OTRS-CGI-62 Perl: 5.10.1 OS: linux Time: Wed Jan 28 14:51:12 2015 Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) RemoteAddress: 132.239.151.222 RequestURI: /otrs/index.pl Traceback (1185): Module: Kernel::System::Web::InterfaceAgent::Run Line: 171 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 41 Module: (eval) (v1.99) Line: 204 Module: ModPerl::RegistryCooker::run (v1.99) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31

Any insights appreciated.