Your syntax is a little off….  If this was an upgrade, you may also want to make sure your users table is not ‘users’ instead of ‘system_user2’ also.     

 

$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=server\SQLEXPRESS,1433;database=OTRS;uid=otrsuser;pwd=123456;";

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

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

 

Daniel

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Luis Fernando Giraldo Galeano
Sent: Wednesday, November 04, 2009 3:29 PM
To: User questions and discussions about OTRS.
Subject: [otrs] Problem install OTRS and MS SQL Server 2005 Express

 

Excuse me I do not speak English only Spanish.

 

I'm installing OTRS 2.4.5 with MSSQL 2005 and is showing me the following error

 

 

ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Nov  4 15:25:56 2009

 

Message: [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado (SQL-IM002)

 

Traceback (1368):

   Module: Kernel::System::DB::new (v1.105.2.1) Line: 188

   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 143

   Module: C:/Archivos de programa/OTRS/OTRS/bin/cgi-bin/index.pl (v1.88) Line: 48

 

To connect to the database I am using the following command

 

$Self->{DatabaseDSN}="DBI:ODBC:otrs={SQL Server};Server=99MESA03\SQLEXPRESS,1433;database=otrs;uid=sa;pwd=123456;";

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

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

 

It is where my problem might help me.

 

 

 

 

Cordialmente,

 

Luis Fernando Giraldo G.

Auxiliar Mesa de Ayuda

Cooperativa San Pio X - COOGRANADA

Tel. (054) 571 81 82 Ext. 111

E-mail lgiraldo@coogranada.com.co

 

 

"Las opiniones contenidas en este mensaje no necesariamente coinciden con las posiciones institucionales de la Cooperativa COOGRANADA.  La informacion y todos sus anexos es confidencial y privilegiada y solo puede ser utilizada por sus destinatarios.  Si por error usted recibe este mensaje le ofrecemos disculpas, solicitamos eliminarlo de inmediato, notificarle de su error a la persona que lo envio y abstenerse de utilizar su contenido"

 

 

P Antes de imprimir este e-mail piense si realmente es necesario hacerlo, el medio ambiente se lo agradecerá

 

 

This email and any files transmitted with it are confidential and intended for use only by the individual or entity named above. If you are not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying of this communication, or unauthorized use is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Randolph County Government. This email and any file attachments have been scanned for potential viruses; however, the recipient should check this email for the presence of viruses and/or malicious code. Randolph County accepts no liability for any damage transmitted via this email.