Ejabberd on a windows 2003 server with MSSQL 2005 - configuration issue

I have spent about 6 hours trying to get this to work with mssql. But no go. I can get it to work fine with it's internal db.

I've created the database, user in sql

Commented %%{auth_method, internal}.
uncommented {auth_method, odbc}

i've uncommented and tried this first
%%{odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=bla"}.

then i tried this as is was searching forums i noticed someone adding the server.

%%{odbc_server, "Server=localhost;Database=ejabberd;Uid=ejabberd;Pwd=bla!"}.

No go.....

What am i doing wrong? How can I get better debugging.

Here's my last crash report

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,inet_gethost_native_sup}
started: [{pid,<0.53.0>},{mfa,{inet_gethost_native,init,[[]]}}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.52.0>},
{name,inet_gethost_native_sup},
{mfa,{inet_gethost_native,start_link,[]}},
{restart_type,temporary},
{shutdown,1000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,sasl_safe_sup}
started: [{pid,<0.57.0>},
{name,alarm_handler},
{mfa,{alarm_handler,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,sasl_safe_sup}
started: [{pid,<0.59.0>},
{name,overload},
{mfa,{overload,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,sasl_sup}
started: [{pid,<0.56.0>},
{name,sasl_safe_sup},
{mfa,
{supervisor,
start_link,
[{local,sasl_safe_sup},sasl,safe]}},
{restart_type,permanent},
{shutdown,infinity},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,sasl_sup}
started: [{pid,<0.60.0>},
{name,release_handler},
{mfa,{release_handler,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
application: sasl
started_at: ejabberd@localhost

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.72.0>},
{name,dets_sup},
{mfa,{dets_sup,start_link,[]}},
{restart_type,permanent},
{shutdown,1000},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:47 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.73.0>},
{name,dets},
{mfa,{dets_server,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:48 ===
supervisor: {local,mnesia_sup}
started: [{pid,<0.81.0>},
{name,mnesia_event},
{mfa,{mnesia_sup,start_event,[]}},
{restart_type,permanent},
{shutdown,30000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:48 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.83.0>},
{name,mnesia_monitor},
{mfa,{mnesia_monitor,start,[]}},
{restart_type,permanent},
{shutdown,3000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:48 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.84.0>},
{name,mnesia_subscr},
{mfa,{mnesia_subscr,start,[]}},
{restart_type,permanent},
{shutdown,3000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:48 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.85.0>},
{name,mnesia_locker},
{mfa,{mnesia_locker,start,[]}},
{restart_type,permanent},
{shutdown,3000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:48 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.86.0>},
{name,mnesia_recover},
{mfa,{mnesia_recover,start,[]}},
{restart_type,permanent},
{shutdown,180000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.91.0>},
{name,disk_log_sup},
{mfa,{disk_log_sup,start_link,[]}},
{restart_type,permanent},
{shutdown,1000},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.94.0>},
{name,disk_log_server},
{mfa,{disk_log_server,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,kernel_safe_sup}
started: [{pid,<0.107.0>},
{name,timer_server},
{mfa,{timer,start_link,[]}},
{restart_type,permanent},
{shutdown,1000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.87.0>},
{name,mnesia_tm},
{mfa,{mnesia_tm,start,[]}},
{restart_type,permanent},
{shutdown,30000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.108.0>},
{name,mnesia_checkpoint_sup},
{mfa,{mnesia_checkpoint_sup,start,[]}},
{restart_type,permanent},
{shutdown,infinity},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.109.0>},
{name,mnesia_snmp_sup},
{mfa,{mnesia_snmp_sup,start,[]}},
{restart_type,permanent},
{shutdown,infinity},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.110.0>},
{name,mnesia_controller},
{mfa,{mnesia_controller,start,[]}},
{restart_type,permanent},
{shutdown,3000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_kernel_sup}
started: [{pid,<0.111.0>},
{name,mnesia_late_loader},
{mfa,{mnesia_late_loader,start,[]}},
{restart_type,permanent},
{shutdown,3000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
supervisor: {local,mnesia_sup}
started: [{pid,<0.82.0>},
{name,mnesia_kernel_sup},
{mfa,{mnesia_kernel_sup,start,[]}},
{restart_type,permanent},
{shutdown,infinity},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:49 ===
application: mnesia
started_at: ejabberd@localhost

=PROGRESS REPORT==== 30-Jul-2008::20:06:52 ===
supervisor: {local,crypto_sup}
started: [{pid,<0.214.0>},
{name,crypto_server},
{mfa,{crypto_server,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:52 ===
application: crypto
started_at: ejabberd@localhost

=PROGRESS REPORT==== 30-Jul-2008::20:06:53 ===
supervisor: {local,ssl_sup}
started: [{pid,<0.224.0>},
{name,ssl_server},
{mfa,{ssl_server,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,worker}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:53 ===
supervisor: {local,ssl_sup}
started: [{pid,<0.225.0>},
{name,ssl_broker_sup},
{mfa,{ssl_broker_sup,start_link,[]}},
{restart_type,permanent},
{shutdown,2000},
{child_type,supervisor}]

=PROGRESS REPORT==== 30-Jul-2008::20:06:53 ===
application: ssl
started_at: ejabberd@localhost

=PROGRESS REPORT==== 30-Jul-2008::20:06:53 ===
supervisor: {local,stringprep_sup}
started: [{pid,<0.227.0>},
{name,stringprep},
{mfa,{stringprep,start_link,[]}},
{restart_type,permanent},
{shutdown,brutal_kill},
{child_type,worker}]

=CRASH REPORT==== 30-Jul-2008::20:06:55 ===
crasher:
pid: <0.39.0>
registered_name: []
error_info: {bad_return,
{{ejabberd_app,start,[normal,[]]},
{'EXIT',
{badarg,
[{ejabberd_check,'-get_db_used/0-fun-0-',2},
{lists,foldr,3},
{ejabberd_check,get_db_used,0},
{ejabberd_check,check_database_modules,0},
{ejabberd_app,start,2},
{application_master,start_it_old,4}]}}}}
initial_call: {application_master,
init,
[<0.5.0>,
<0.38.0>,
{appl_data,
ejabberd,
[ejabberd,
ejabberd_sup,
ejabberd_auth,
ejabberd_router,
ejabberd_sm,
ejabberd_s2s,
ejabberd_local,
ejabberd_listeners,
ejabberd_iq_sup,
ejabberd_service_sup,
ejabberd_s2s_out_sup,
ejabberd_s2s_in_sup,
ejabberd_c2s_sup,
ejabberd_mod_roster,
ejabberd_mod_echo,
ejabberd_mod_pubsub,
ejabberd_mod_irc,
ejabberd_mod_muc,
ejabberd_offline,
random_generator],
undefined,
{ejabberd_app,[]},
[acl,
adhoc,
configure,
cyrsasl_anonymous,
cyrsasl,
cyrsasl_digest,
cyrsasl_plain,
ejabberd_admin,
ejabberd_app,
ejabberd_auth_anonymous,
ejabberd_auth,
ejabberd_auth_external,
ejabberd_auth_internal,
ejabberd_auth_ldap,
ejabberd_auth_odbc,
ejabberd_auth_pam,
ejabberd,
ejabberd_c2s,
ejabberd_c2s_config,
ejabberd_config,
ejabberd_ctl,
ejabberd_frontend_socket,
ejabberd_hooks,
ejabberd_http,
ejabberd_http_bind,
ejabberd_http_poll,
ejabberd_listener,
ejabberd_local,
ejabberd_logger_h,
ejabberd_loglevel,
ejabberd_node_groups,
ejabberd_rdbms,
ejabberd_receiver,
ejabberd_router,
ejabberd_s2s,
ejabberd_s2s_in,
ejabberd_s2s_out,
ejabberd_service,
ejabberd_sm,
ejabberd_socket,
ejabberd_sup,
ejabberd_system_monitor,
ejabberd_tmp_sup,
ejabberd_update,
ejabberd_web_admin,
ejabberd_web,
ejabberd_zlib,
ejd2odbc,
eldap,
eldap_filter,
eldap_pool,
eldap_utils,
'ELDAPv3',
extauth,
gen_iq_handler,
gen_mod,
gen_pubsub_node,
gen_pubsub_nodetree,
iconv,
idna,
jd2ejd,
jlib,
mod_adhoc,
mod_announce,
mod_caps,
mod_configure2,
mod_configure,
mod_disco,
mod_echo,
mod_http_bind,
mod_http_fileserver,
mod_irc,
mod_irc_connection,
mod_last,
mod_last_odbc,
mod_muc,
mod_muc_log,
mod_muc_room,
mod_offline,
mod_offline_odbc,
mod_privacy,
mod_privacy_odbc,
mod_private,
mod_private_odbc,
mod_proxy65,
mod_proxy65_lib,
mod_proxy65_service,
mod_proxy65_sm,
mod_proxy65_stream,
mod_pubsub,
mod_register,
mod_roster,
mod_roster_odbc,
mod_service_log,
mod_shared_roster,
mod_stats,
mod_time,
mod_vcard,
mod_vcard_ldap,
mod_vcard_odbc,
mod_version,
node_buddy,
node_club,
node_default,
node_dispatch,
node_pep,
node_private,
node_public,
nodetree_default,
nodetree_virtual,
p1_fsm,
p1_mnesia,
ram_file_io_server,
randoms,
sha,
shaper,
stringprep,
stringprep_sup,
tls,
translate,
xml,
xml_stream,
'XmppAddr'],
[],
infinity,
infinity},
normal]}
ancestors: [<0.38.0>]
messages: [{'EXIT',<0.40.0>,normal}]
links: [<0.38.0>,<0.5.0>]
dictionary: []
trap_exit: true
status: running
heap_size: 1597
stack_size: 21
reductions: 2041
neighbours:Start Free Trial