RE: [IMail Forum] Can not login using SQL External DB - question

[Andrews, Bryan (CCI-Atlanta)]

Does anyone use SQL server (on a separate machine from imail) not on a
domain. I'm kind of stuck on this...


Bryan Andrews
Senior Web Administrator
Cox Communications, Inc.

                -----Original Message-----
                From:   Andrews, Bryan (CCI-Atlanta) 
                Sent:   Thursday, April 06, 2000 4:01 PM
                To:     '[EMAIL PROTECTED]'
                Subject:        RE: [IMail Forum] Can not login using SQL
External DB

                One more thing... because our dbase machine is not on a
domain I have the
                SQL server starting and running as a system account (as
opposed to a service
                account that we normally create in the domain for it to run
as).





                                -----Original Message-----
                                From:   Andrews, Bryan (CCI-Atlanta) 
                                Sent:   Thursday, April 06, 2000 3:44 PM
                                To:     '[EMAIL PROTECTED]'
                                Subject:        RE: [IMail Forum] Can not
login using SQL
                External DB

                                BTW the 2 machines are not on a domain...
(do they need to
                be?).


                                Bryan Andrews
                                Senior Web Administrator
                                Cox Communications, Inc.

                                                -----Original Message-----
                                                From:   Andrews, Bryan
(CCI-Atlanta) 
                                                Sent:   Thursday, April 06,
2000 3:35 PM
                                                To:
'[EMAIL PROTECTED]'
                                                Subject:        RE: [IMail
Forum] Can not
                login using SQL
                                External DB

                                                Do all the Imail services
have to run as
                such? Currently the
                                Database is
                                                entered with sa and blank
password... do I
                simply create an
                                account called
                                                sa on the local box to
imail? And then later
                specify
                                whatever user and
                                                password I give to access
the db?


                                                Bryan Andrews
                                                Senior Web Administrator
                                                Cox Communications, Inc.

        
-----Original Message-----
                                                                From:   Dan
Nguyen
                [mailto:[EMAIL PROTECTED]]
                                                                Sent:
Wednesday, April 05,
                2000 3:36 PM
                                                                To:
                [EMAIL PROTECTED]
                                                                Subject:
Re: [IMail
                Forum] Can not
                                login using SQL
                                                External DB

                                                                Yes, you'll
have to change
                so that Imail
                                Services will run
                                                under an account
                                                                which has
administrative
                rights.  For
                                testing, user
                                                administrator account .

                                                                Dan

        
-----Original Message-----
                                                                From: STEVEN
MOORE (IFL)
                <[EMAIL PROTECTED]>
                                                                To:
                '[EMAIL PROTECTED]'
        
<[EMAIL PROTECTED]>
                                                                Date:
Wednesday, April 05,
                2000 9:05 AM
                                                                Subject: RE:
[IMail Forum]
                Can not login
                                using SQL External
                                                DB


                                                                >Hiya,
                                                                >
                                                                >Does the
user that IMail
                runs as have the
                                correct
                                                permissions on the SQL
                                                                >server??
                                                                >
                                                                >Most people
change the user
                that the IMail
                                services run as
                                                to a different
                                                                >user
account than the local
                system account.
                                                                >
                                                                >
                                                                >Steve
                                                                >
                                                                >Steven
Moore
                                                                >Internet
Development
                Engineer
                                                                >Research
Machines
                                                                >+44 1235
823522
                                                                >
        
>-----Original Message-----
                                                                >From:
                [EMAIL PROTECTED]
                                        
        
>[mailto:[EMAIL PROTECTED]]On Behalf Of
                                                Craig Baetz
                                                                >Sent: 05
April 2000 17:30
                                                                >To:
                [EMAIL PROTECTED]
                                                                >Subject:
[IMail Forum] Can
                not login using
                                SQL External DB
                                                                >
                                                                >
                                                                >I am having
problems
                configuring an
                                external SQL DB, and
                                                hoping for a few
                                                                >ideas.
                                                                >
                                                                >Here is the
gist...  I have
                configured an
                                external SQL DB,
                                                and have no
                                                                >problem
adding users.  The
                problem is none
                                of them can log
                                                on, and mail
                                                                >addressed
to them is
                rejected.
                                                                >
                                                                >Any ideas
out there?
                                                                >
                                                                >Thanks in
advance
                                                                >
                                                                >
                                                                >Craig Baetz
                                                                >
                                                                >
                                                                >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.
                                                                >


                                        
        
_____________________________________________________

                                                                Build Your
Biz, E-Commerce,
                WebSite and more
                                online. 
                                                                Visit
http://www.hotbiz.com

                                                                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.
                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.