databse mysql to mssql

[shailesh]

Hello Friends,

i want to change database type from mySQL to msSQL i make necessary changes, and run the file otrs.CheckDB.pl it shows message that "It looks ok !"

but when i try to run index.pl in browser error message display

Oops! An Error occurred.
Error Message: Can't connect to MySQL server on 'localhost' (10061)
Please contact your administrator.

<![CDATA[
Message:
Can't connect to MySQL server on 'localhost' (10061)

Comment:
Please contact your administrator

Traceback:
ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Fri Feb 11 17:31:46 2011<br/>
<br/>
Message: Can't connect to MySQL server on 'localhost' (10061)<br/>
<br/>
Traceback (576): <br/>
Module: Kernel::System::DB::new (v1.127) Line: 181<br/>
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 140<br/>
Module: ModPerl::ROOT::ModPerl::Registry::D_3a_Program_20Files_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48<br/>
Module: (eval) (v1.89) Line: 204<br/>
Module: ModPerl::RegistryCooker::run (v1.89) Line: 204<br/>
Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170<br/>
Module: ModPerl::Registry::handler (v1.99) Line: 31<br/>
<br/>
"
]]>
You canSend a bugreport or go back to the previous page.

Error Details:
Error Details
Backend ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Fri Feb 11 17:31:46 2011

Message: Can't connect to MySQL server on 'localhost' (10061)

Traceback (576):
Module: Kernel::System::DB::new (v1.127) Line: 181
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 140
Module: ModPerl::ROOT::ModPerl::Registry::D_3a_Program_20Files_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48
Module: (eval) (v1.89) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31


Powered by OTRS 3.0.5 Top of page

I don't know what is the exact matter, please give me hint.

Thanks in advance

[chetannagaonkar]

I believe that you need to make the necessary changes in Config.pm to connect to MSSQL server.

[shailesh]

Thanks chetan for quick response but i already made the changes ... and after running the CheckDB.pl it shows message that "It looks ok !"

it means database connection are OK !!!

do you have any other clue ?

[chetannagaonkar]

if you can post your config.pm, it may help to debug.

[shailesh]

Hi Chetan,

please find the file....

[chetannagaonkar]

I have reviewed the config.txt. You seem to connect to system_user2 table. Check if that table exists. Since you have specified the username/password for db (and assuming they are correct:-)), that's the only possibility that i can think causing that issue.

Best Regards
Chetan