Hi Stefan,

For a simple connection with MS-SQL from Linux you could use DBD::Sybase. Here's a sample configuration for a Customer Database on Windows / MS-SQL :

   # CustomerUser
    # (customer user database backend and settings)
    $Self->{CustomerUser} = {
        Name => 'Customer DB',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            DSN => 'DBI:Sybase:server=192.168.60.1',
            User => 'database_user',
            Password => 'password',
            Table => 'customer_user',
        },
        # customer unique id
        CustomerKey => 'login',
        # customer #
        CustomerID => 'customer_id',
        CustomerValid => 'valid_id',
        CustomerUserListFields => ['first_name', 'last_name', 'email'],
        CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
        CustomerUserSearchPrefix => '',
        CustomerUserSearchSuffix => '*',
        CustomerUserSearchListLimit => 250,
        CustomerUserPostMasterSearchFields => ['email'],
        CustomerUserNameFields => ['salutation','first_name','last_name'],
        CustomerUserEmailUniqCheck => 1,
        Map => [
            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
            [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ],
            [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'last_name',   1, 1, 'var', '', 0 ],
            [ 'UserLogin',      'Username',   'login',       1, 1, 'var', '', 0 ],
            [ 'UserPassword',   'Password',   'pw',          0, 1, 'var', '', 0 ],
            [ 'UserEmail',      'Email',      'email',       0, 1, 'var', '', 0 ],
            [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ],
            [ 'UserComment',     'Comment',   'comments',    1, 0, 'var', '', 0 ],
            [ 'ValidID',         'Valid',     'valid_id',    0, 1, 'int', '', 0 ],
        ],
        # default selections
        Selections => {
            UserSalutation => {
                'Mr.' => 'Mr.',
                'Mrs.' => 'Mrs.',
            },
        },
    };

Just install the package libdbd-sybase-perl and you're good to go!

Kind regards,

--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl

On Thu, Jul 9, 2009 at 09:53, Stefan-Michael Guenther <otrs01@in-put.de> wrote:

Hi Afshar,

>We are using OTRS in MS Windows platform with MS SQL database and have >not any problem till now. What's your problem with MS SQL?

just to make sure that we are talking about the same configuration:

The OTRS is currently running on a debian server. Did you install OTRS on the windows machine, too?

Stefan

Hello,

are there any members on this mailing list who store the OTRS agents in a MS SQL database?

We have used different OTRS installations on Debian, SuSE, Redhat
and Ubuntu but always get the same login error message which obviously has something to do with the DBD::ODBC module.

It would be helpful if we could get the version numbers MS
SQL, DBD::ODBC and OTRS of such a successful installation.

Thanks in advance,

Stefan-Michael G?nther

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/