sync error after switching to mssql

[Mono]

winxp test PC + otrs 3.06 + ldap + MySql work fine, now i'm trying to replace MySql with MsSql.

I followed this guide
http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=121

CheckDB says that my config is OK, but i get "Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid" when try to log on.
I'm pretty new to otrs, so can somebody tell me what should i check to find cause of problem?

my DB settings from Config.pm:

# MSSQL database settings
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=192.168.xx.xx,1433;database=xxxx;uid=xxxx;pwd=xxxx;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'system_user2';

[ferrosti]

Please search the forum for 'no user data'. You´ll get lots of hints.

[Mono]

Those hints are mostly about ldap problems, but ldap works fine with my otrs.
I guess there is something wrong with mssql base, prepared for otrs. Can you recommemnd more detailed guide about mssql for otrs?

[crythias]

no user data means that you've authenticated but you don't have a user that matches what you've authenticated as. What could be the fix? Check your Config.pm and make sure that the User Authentication (permission) and the User list point to something relevant. If you are using the DB to handle Users (agents), make sure the user table is populated. If you're using ldap to handle Users, make sure you've set your config.pm appropriately.

Please post your Config.pm with personal information redacted.
Please adjust your signature.

[Mono]

Here is my config
Only data in mssql DB is that was created by otrs sql scripts, and I'm not mssql specialist and dont know how to verify if i have all required user data.
Half of symbols in otrs log are unreadable, cause I use russian version of OS and odbc drivers and they dont work that good with otrs. Changing codepage in text viewers didnt fix that.

# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# Start of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #





# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
# $Self->{'DatabaseHost'} = 'localhost';
# Database
# (The database name.)
# $Self->{'Database'} = 'xxx';
# DatabaseUser
# (The database user.)
# $Self->{'DatabaseUser'} = 'xxx';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
# $Self->{'DatabasePw'} = 'xxx';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
# $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

# (The database DSN for PostgreSQL ==> more: "man DBD::Pg")
# if you want to use a local socket connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
# if you want to use a tcpip connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";

# MSSQL database settings
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=192.168.xx.xx,1433;database=xxxx;uid=xxxx;pwd=xxxx;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'system_user2';


# ---------------------------------------------------- #
# fs root directory
# ---------------------------------------------------- #
$Self->{Home} = 'C:/PROGRA~1/OTRS/OTRS';

# ---------------------------------------------------- #
# insert your own config settings "here" #
# config settings taken from Kernel/Config/Defaults.pm #
# ---------------------------------------------------- #
# $Self->{SessionUseCookie} = 0;
# $Self->{CheckMXRecord} = 0;

# ---------------------------------------------------- #

# ---------------------------------------------------- #
# data inserted by installer #
# ---------------------------------------------------- #

$Self->{LogModule} = 'Kernel::System::Log::File';
$Self->{LogModule::LogFile} = 'C:/PROGRA~1/OTRS/OTRS/var/log/otrs.log';
# $DIBI$
$Self->{'DefaultCharset'} = 'utf-8';

$Self->{'AuthModule1'} = 'Kernel::System::Auth::LDAP';
$Self->{'AuthModule::LDAP::Host1'} = 'zzz.xxx.ccc';
$Self->{'AuthModule::LDAP::BaseDN1'} = 'dc=xxx,dc=ccc';
$Self->{'AuthModule::LDAP::UID1'} = 'sAMAccountName';


# The following is valid but would only be necessary if the
# anonymous user do NOT have permission to read from the LDAP tree
$Self->{'AuthModule::LDAP::SearchUserDN1'} = 'CN=qqq,OU=www,OU=zzz,DC=xxx,DC=ccc';
$Self->{'AuthModule::LDAP::SearchUserPw1'} = 'vvv';

# Net::LDAP new params (if needed - for more info see perldoc Net::LDAP)
$Self->{'AuthModule::LDAP::Params'} = {
port => 389,
timeout => 120,
async => 0,
version => 3,
};


# This is an example configuration for an LDAP auth sync. backend.
# (take care that Net::LDAP is installed!)
$Self->{'AuthSyncModule1'} = 'Kernel::System::Auth::Sync::LDAP';
$Self->{'AuthSyncModule::LDAP::Host1'} = 'zzz.xxx.ccc';
$Self->{'AuthSyncModule::LDAP::BaseDN1'} = 'dc=xxx,dc=ccc';
$Self->{'AuthSyncModule::LDAP::UID1'} = 'sAMAccountName';

# The following is valid but would only be necessary if the
# anonymous user do NOT have permission to read from the LDAP tree
$Self->{'AuthSyncModule::LDAP::SearchUserDN1'} = 'CN=qqq,OU=www,OU=zzz,DC=xxx,DC=ccc';
$Self->{'AuthSyncModule::LDAP::SearchUserPw1'} = 'vvv';

# AuthSyncModule::LDAP::UserSyncMap
# (map if agent should create/synced from LDAP to DB after successful login)
$Self->{'AuthSyncModule::LDAP::UserSyncMap1'} = {
# DB -> LDAP
UserFirstname => 'givenName',
UserLastname => 'sn',
UserEmail => 'mail',
};

# In case you need to use OTRS in iso-charset, you can define this
# by using this option (converts utf-8 data from LDAP to iso).
# $Self->{'AuthSyncModule::LDAP::Charset'} = 'iso-8859-1';

# Net::LDAP new params (if needed - for more info see perldoc Net::LDAP)
# $Self->{'AuthSyncModule::LDAP::Params'} = {
# port => 389,
# timeout => 120,
# async => 0,
# version => 3,
# };

# Die if backend can't work, e. g. can't connect to server.
# $Self->{'AuthSyncModule::LDAP::Die'} = 1;
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# End of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #