[otrs] Can't login to OTRS 2.2.4 on Windows XP IIS with MSSQL

[Shawn Beasley]

Kieth,

On Fri, 2007-11-16 at 14:07 +1100, Keith Bannister wrote:
> > Which ((otrs)) version are you using? Which web server are you using?
> >
> >   
> Working now! The trick is to not use a standard ActivePerl download but 
> use the activeperl that's installed with the OTRS windows installer.
> 

I am happy that it is working for you.

> The procedure to install in OTRS 2.2.4 in windows IIS 5.0 and MS SQL 
> Express was:
> 

Are you using a W2K3 server? If not, which Windows machine are you
using?

> -. run the OTRS windows installer .exe (assume it installs to c:\otrs)
> -. Stop apache and mysql (run c:\Otrs_stop.bat)
> -. Start IIS and SQL server Express
> - Create IIS virtual directory pointing at c:\otrs\otrs\bin\cgi-bin
> -  For the otrs directory, add mapping for .pl to 
> c:\otrs\perl\bin\perl.exe %s %s
> - Modify c:\otrs\otrs\scripts\database\*mssql.sql replacing system_user 
> to system_user2
> - In SQL server management tool Create 'otrs' database
> - Import SQL data into database
> - create otrsroot user (using SQL authentication)
> -. Set owner of otrs database to otrsroot user
> -. Modify Config.pm according to:
>     $Self->{Home} = 'C:/OTRS/otrs';
>     $Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL 
> Server};Server=myservername\\sqlexpress;database=otrs;uid=otrsroot;pwd=mypassword;";
>     $Self->{"Database::Type"} = 'mssql';
>     $Self->{DatabaseUserTable} = 'system_user2';
>     $Self->{DatabaseUser} = 'otrsroot';
>     $Self->{DatabasePw} = 'mypassword';
> 
> - Hit index.pl and hope it works. login with root at localhost password root
> 
> Is this worth adding to faq.otrs.org?

I will test this for your today, and add it to the faq if your process
is working here to.

((enjoy))

 Shawn Beasley

-- 
((otrs)) :: OTRS AG :: Europaring 4 :: 94315 Straubing
    Fon: +49 (0)9421 56818 0 :: Fax: +49 (0) 9421 56818 18
      http://www.otrs.com/ :: Communication with success!


Geschäftssitz: Bad Homburg
Amtsgericht Bad Homburg, HRB 10751
Steuernummer: 003/240/97505

Aufsichtsratsvorsitzender: Burchard Steinbild
Vorstandsvorsitzender: André Mindermann
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.otrs.org/pipermail/otrs/attachments/20071116/3abb5501/attachment.pgp