Hi,
I probably missed the start of this thread so excuse me if this has already
suggested.
This sounds like a SQL server permissions problem. There are two ways to set
this up, first is to create a SQL user (i.e. not NT account) which is
included in the DSN field as described in the knowledge base, or the second
option (I prefer this) you have to change the user that the IMail services
run as and give that user sufficient privileges on the SQL database I am not
sure about the minimum required (anybody want to hazard a guess) but the
user at least has to be able create/delete table structure (the ddladmin /
datareader / datawriter roles seems to work well). For the later option it
does help if the servers are in the same domain or are at least trusted in
the correct manner.
Hope this helps
Steve
Steven Moore
Internet Development Engineer
Research Machines
+44 1235 823522
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of david querusio
Sent: 08 June 2000 14:43
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] IMail 6 and SQL 7 Servers --
DifferentMachines?
I have yet to get this working. If you do, please let me know how. The 20
minuite e-mail solution is now at day 5. My DSN is set up correctly and is
used by other apps, but for some reason IMail refuses to create user
accounts.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Oblio Leitch
Sent: Wednesday, June 07, 2000 9:39 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] IMail 6 and SQL 7 Servers --
DifferentMachines?
At 6/7/00 07:25 PM, you wrote:
>Is it possible to configure IMail 6 to use an external SQL 7 database
>that's on a different machine?
Yes, just set up the DSN to point to the appropriate machine.
>If so, do they need to be on the same network?
Yes, ODBC administrative functions only work on a LAN.
>Adam
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
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 visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
