Do you really need to use SQL Authentication, Why not change the user that
IMail services logon as to a different user and then give that user
permission in your database. Then you do not need to worry about getting SQL
Auth working.
Steve
Steven Moore
Internet Development Engineer
Research Machines
+44 1235 823522
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Stefan Borg
> Sent: 25 June 2001 18:10
> To: [EMAIL PROTECTED]
> Subject: Re: [IMail Forum] POP3 fails manual restart
>
>
> Hi Hawk,
>
> SP1 of SQL 2000 does not solve any problem with Imail as far
> as I know. The
> problem was there before, and is still there after upgrading
> to SP1. The
> only thing which is solved which can have an effect with some
> combinations
> of Imail, is the ODBC of SQL which is installed by SP1. The
> first SQL driver
> was 2000.80.194.00 which caused headaches when connecting to
> another SQL
> server requiring SQL authentication. The new driver is
> 2000.80.380.00 and
> fixes loging problems on SQL.
>
> I needed SQL to be local on the machine in order to replicate
> the few SQL
> tables containing the accounts data from the primary SQL
> server. This in
> case the primary SQL database is down for maintenance, the
> local SQL tables
> would still alllow users to login to Imail. I guess you fix
> one problem, and
> you create another one...
>
> Hoping Imail 7.0 would be less of a headache with SQL!!!
>
> Thanks,
> Stefan
>
>
> >From: Hawk <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: Re: [IMail Forum] POP3 fails manual restart
> >Date: Mon, 25 Jun 2001 12:08:23 -0400
> >
> >At 10:48 AM 6/25/2001 -0400, Korey Verlsteffen wrote:
> >>Yes, I've experienced the same problem.
> >>
> >>Solution. Do not run SQL on the same machine with Imail.
> >>
> >
> >Korey,
> >
> >I still had the same problem.
> >
> >a) Imail 6.06 w/ patches applied Server 1: (Quad 450, 1GB RAM)
> >
> >b) SQL2000 Enterprise with MDAC 2.6 Server 2: (Quad 450, 1GB RAM)
> >
> >Then I switched to Imail internal Database, no problems. I
> did not know
> >that there was a SP1 for SQL2000, is this my problem?
> >
> >
> >
> >>----- Original Message -----
> >>From: "Peter Arthur" <[EMAIL PROTECTED]>
> >>To: <[EMAIL PROTECTED]>
> >>Sent: Monday, June 25, 2001 10:35 AM
> >>Subject: [IMail Forum] POP3 fails manual restart
> >>
> >>
> >> > Hi all,
> >> >
> >> > Has anybody experienced this problem:
> >> >
> >> > Imail Version 6.06 (with all the most current updates)
> >> > Windows 2000 Advanced Server - SP2
> >> > Microsoft SQL Server 2000 - SP1
> >> >
> >> > Upon restart of machine, POP3 starts properly without
> problems. If I
> >>try
> >>to
> >> > restart the POP3 service from the services panel, it
> starts without
> >>giving
> >> > any error, but pop3 clients fail to connect and a port
> scan on port 110
> >> > shows port 110 as "free". Then to make it work again, a
> system restart
> >>is
> >> > required!
> >> >
> >> > Imail services are starting with the Domain
> Administrator account, and
> >>I
> >> > also tried the local system account without any difference...
> >> >
> >> > Anybody has any useful information?
> >> >
> >>____________________________________________________________
> _____________
> >> > Get Your Private, Free E-mail from MSN Hotmail at
> >>http://www.hotmail.com.
> >> >
> >> >
> >> > 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/
> >> >
> >>
> >>
> >>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/
> >
> >
> >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/
>
> ______________________________________________________________
> ___________
> Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
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/
Visit our website at http://www.rm.com
Standard Disclaimer:This message is confidential. You should not copy it or
disclose its contents to anyone. You may use and apply the information only
for the intended purpose. Internet communications are not secure and
therefore RM does not accept legal responsibility for the contents of this
message. Any views or opinions presented are only those of the author and
not those of RM. If this email has come to you in error please delete it
and any attachments. Please note that RM may intercept incoming and
outgoing e-mail communications.
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/
