469,309 Members | 2,783 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,309 developers. It's quick & easy.

system DSN connection

23
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
Feb 29 '08 #1
0 742

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Sandy Norton | last post: by
reply views Thread by NicK chlam via DotNetMonster.com | last post: by
reply views Thread by Marco Castro | last post: by
1 post views Thread by henrycortezwu | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.