MS SQL Restore

[michaelh81]

Hi all,

I'm using the following setup:

Live Production
OTRS 3.2.9
Windows Server 2007 32 bit
SQL Server 2012 Express
IIS 7

All is working fine.

I then installed:
Test
OTRS 3.2.9 on my Windows 7 client on a SQL Server 2012 Express backend. I created a blank new database called OTRS and am able to log in ok.

I am wanting to test a restore from Live Production into my Test database. So I restored a copy of the database, all went ok. Then when I go to login, I receive the following in the web front end:


Error Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'otrs'. (SQ[..]
Please contact your administrator.

Backend ERROR: OTRS-CGI-26 Perl: 5.16.3 OS: MSWin32 Time: Thu Sep 5 13:55:42 2013 Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'otrs'. (SQL-28000) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (4968): Module: Kernel::System::DB::new (OTRS 3.2.9) Line: 224 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.9) Line: 140 Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

So, steps taken so far:

- I went into SQL Management on my Test client and changed the password of 'OTRS' user to that of the Live environment, rebooted the client and still the same message.
- Copied the Kernal\Config.pm file from Live to Test - still the same message

Any ideas what I am missing? It is something to do with the authentication of the OTRS SQL user, but I have so far been unable to work it out.

Regards,

Michael

[michaelh81]

Its ok I worked it out. I'll share if anyone else is in a similar position. Its easy, just copy the Defaults.pm from the Kernel\Config file from Live to Test and it works.

[crythias]

just copy the Defaults.pm from the Kernel\Config file from Live to Test and it works.

you shouldn't have made any changes to Defaults.pm.

[michaelh81]

Mmmm not sure, as soon as I copied the Defaults file it worked.