I ran across the same problem. I can't guarantee that this is your same problem, but:
- Check the DSN to make sure the connection test works. - Recheck the DSN, make sure it's a System DSN. Also, make sure you have "With SQL Server Authentication" or "With NT Authentication" checked depending on your setup. If you use SQL Server Authentication, but have NT Authenticaion checked in the ODBC, the ODBC connection test may succeed, but your iMail login will fail. Actually, I don't even know if you can use NT Authentication with iMail. - Check to make sure the tables have been created in your SQL Database. For some weird reason, they weren't getting created for me. I rebooted. Then, it worked fine. - I don't think you can run multiple domains on a single DB table. You have to specify different tables for each domain. Otherwise, you can login to all domains with the same username/password ([EMAIL PROTECTED]/password works on domain1.com, domain2.com, etc...). Don't know if that's what you're trying to do, but it would make iMail authentication flaky. Again, don't know if this will help, but it sounds like a problem we had. Norman J. Nolasco Advarion Incorporated -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Campbell Sent: Monday, February 25, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: [IMail Forum] IMail SQL User Database - Problems I was running IMail 7.05 HF1 using the IMAIL User Database on NT4 spk6. I have recently moved across my 10 hosting domains to use the SQL Database. My SQL Server is MS-SQL 2000 on Win2k server. I am having a problem such that when I moved across my larger domains, I was unable to authenticate users on POP3 and Web. The email client would just sit there and eventually timeout. It was as if there was an ODBC connection open, but not allowing any requests through. I could telnet to the POP3 service without problem, but was unable to authenticate a user. So I have moved back across to the IMail user DB, but desperately want to move to SQL (as you can understand). Any ideas would be greatly appreciated. TIA Ryan Campbell O Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
