February 28, 2008 at 11:03 am
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
February 29, 2008 at 9:25 am
You can't use local system account to get to another machine using integrated authentication. Try to run this daemon under a domain account that will be granted access to database on second machine.
Piotr
...and your only reply is slàinte mhath
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply