Post reply

SQL MAIL ERROR !! HELP!!

  • January 11, 2004 at 10:46 pm

    #65761

    Hi Guru,

    I encounter a weird problem on SQL mail. I have configured many SQL mail servers and works fine! However, One of the SQL server can't start the SQL mail.  error message return

    Server: Msg 18030, Level 16, State 1, Line 0

    xp_startmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

    I have no problem to send mail from the server using MS Outlook and set it as the default mail client. Please advise!

     

     

  • January 12, 2004 at 3:01 am

    #489575

    just my 2ct.

    - did you configure the mail-profile when logged in as sql-agent-service-account ?

    - does your sql-agent-service-account has the needed authorities for that email-profile ?

    - Is it working when you sent a notification mail, selected wit a job ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • January 12, 2004 at 10:04 am

    #489610

    here is my other 2cents.  Please send test email from outlook to yourself to see if you receive email from that server.

    If you are unable to send email from outlook, you need to go back in and configure email according to alzdba sugestion.

     

    mom

  • January 13, 2004 at 1:58 am

    #489691

    Guys,

    Thanks for your feedback! I able to send mail from outlook and confirmed the no problem with the account. From SQL Server agent properties on mail session. I can't select the mail profile. I have the similar problem before and it worked after restart the server and select the correct user account. I did the same thing but can't work...

     

  • January 13, 2004 at 8:43 am

    #489765

    Did you login to the server using sql server agent account when you set your the email profile?  Your SQL Server Agent account also has to have the right to open that email profile.

    mom

  • January 14, 2004 at 1:50 am

    #489909

    Yup! I am using the correct account. the account is administrator equalvalent and other server server using the same account works fine.

  • January 15, 2004 at 11:03 pm

    #490357

    If this is a WIN2K server make sure the SQL Agent service acct is in the local admin group. Also in Outlook you need to make sure that the SQL Agent mail profile is the default profile for that acct. Also in the SQLAgent properties you need to verify the connection to SQL Server. Hope this helps.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply