Results 1 to 11 of 11

Thread: Sql Mail Problem

  1. #1
    Join Date
    Jun 2008
    Posts
    6

    Question Sql Mail Problem

    I Have Configured Two Different Outlook2003 Mail Profiles For Sql Mail And Sql Agent Mail. When I Do Testing The Message Comes Done Successfully But I Dont Receive And Mails In My Mailbox.

    But When I Stop My Sqlserver Agent All The Mail Comes To Me Which Were Pending, So To Recive Mail I Have To Stop Sql Mail Agent Whcih Is Not Correct...

    And Same Time When I Try To Access The Same Profile Of Sql Agent Mail Of Outlook 2003
    It Says That Its Pst Is In Use....

    So When I Stop Sql Agent It Allows Me To Use Outlook Oterwise It Gives Massage That Pst Is In Use......

    So Please Guide Me What Check I Should Make ....

    Thanks
    Mithun Gite

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's sql version and sp level?

  3. #3
    Join Date
    Jun 2008
    Posts
    6
    Thanks a lot for the reply below is the info. u asked.

    MS SQL SERVER 2000 STANDARD EDITION,
    VERSION 8.00 2039(SP4),
    OS>WINDOWS 2003 WITH SP1
    USING OUTLOOK2003

    thanks
    mithun gite

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    What's sql agent service account? Was mail profile created for that account?

  5. #5
    Join Date
    Jun 2008
    Posts
    6

    Question sql agent service account

    thanks for replying and giving ur preciouse time to my problem,,,
    my sql agen service account is domains administrator account and yes, i have created diff mail profile for it in outlook 2003.

    pls give me some hint for this problem .

    thanks
    mithun gite

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    How did you create mail profile? What do you mean 'created diff mail profile for it'?

  7. #7
    Join Date
    Jun 2008
    Posts
    6

    sql mail and agent problem

    diff mail profile for sql mail and sql agent.

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    For same account? Did you login windows with that account to create mail profile? What's mail server?

  9. #9
    Join Date
    Jun 2008
    Posts
    6

    sql mail and agent problem

    yes two diff profile for same account...
    and i loginto windows 2003 server and my mail server is thrid party linux basesd server with pop3 option enabled. i m not using exchange server

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    It's not easy to make sql mail work with third party mail server. Did you post the problem in Microsoft MSDN forum? They may have something for you.

  11. #11
    Join Date
    Jun 2008
    Posts
    6
    no not yet posted this problem in Microsoft MSDN forum, but i will do it today and will let u know their reply....

    thanks buddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •