system DSN connection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kaib
    New Member
    • Nov 2006
    • 23

    system DSN connection

    i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email

    accounts in one database so that email servers can link to a common account database. Mail

    server Mdaemon which has got option to store accounts in database. Mdaemon has got

    necessary scripts to create table etc..

    I installed in one machine (windows2k3 with SP1)Mdaemon and SQL and with a system DSN could

    successfully create tables in SQL and export accounts to those tables.

    madaemon installed in another windows2k3with SP1 machine and want to connect to the the

    machine with sql server running with a local system DSN. DSN is created but thru mdaemon i

    cannot run the scripts or mdaemon doesn't see the tables that are created by the first

    machine. when i run the script it gives an error 'nt authroity system/login failure'


    both machines are workgroup machines; i've installed sql with NT authentication and enabled

    thru surface area management remote connection (TCP) ; windows firewalls are off on both

    servers. both are loggedin as builtin local administrator
    what could be the reason not allowing me to connect
Working...