Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Business Alert Error :...
Microsoft Dynamics GP (Archived)

Business Alert Error :xp_sendmail erro

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,265

Dear All,

Followed KB915097 setup SQLMail created new profile as per kb but while running getting error "Test mail profile failed for jobserver" if I used default "Outlook" profile Test pass.

on GP side if I goes with "outlook" profile I am getting another error "The following error occured in SQL Server : xp_sendmail: Either there is no defaul mail client or current mail client cannot fulfill the messaging request. Please run Microsoft Outloook and set it as the default mail client"

if I used Database Mail option on SQL Server Management Studio-->Database Mail test mail is working but in GP getting same error..!!!

Any help will be highly appreciable.

Thanks

Sandip

*This post is locked for comments

  • Suggested answer
    John Lowther Profile Picture
    John Lowther 5,122 on at
    RE: Business Alert Error :xp_sendmail erro

    hi adeel333,

    It has actually been quite a while since I used the older xp_sendmail, but here are some resources and things to check that might be causing your problem.

    Read the kb article 915097 on Customer Source.

    Check out this blog post.

    Also, make check to see if the outlook profile on your SQL server is for the same windows account that is running the SQL Server Agent Service. If I remember correctly they have to be the same.

    Also, double check all the permissions as outlined in the kb article mentioned above.

     

    Hope this gets you headed in the right direction, and if it answers your question please mark it as answered.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Business Alert Error :xp_sendmail erro

    Sandip,

    Business alert is only supported for SQL server standart edition and make sure your SQL server agent is running. First try ro run that created business alert via SSMS SQL agent and try it on GP.

    If you have any doubt in setup Business alert, see below the link for your reference.

    blog.congruentindia.com/business-alert-in-dynamics-gp

  • soma Profile Picture
    soma 24,406 on at
    RE: Business Alert Error :xp_sendmail erro

    Josh Lother,

    Can you tell me the sql server version? Express or Standard.

  • adeel333 Profile Picture
    adeel333 485 on at
    RE: Business Alert Error :xp_sendmail erro

    Josh Lowther - I am having the same issue as sandip mentioned and I do not want to use DBMAIL - I want to use SQLMAIL only. I have 32 bit operating system and SQL 2008 R2 (32bit) - how can I get rid of this same issue ? please help.

  • John Lowther Profile Picture
    John Lowther 5,122 on at
    Re: Business Alert Error :xp_sendmail erro

    Hey Sandip,

    Check out the second comment on community.dynamics.com/.../sending-emails-from-business-alerts.aspx

    If that doesn't help drop me a line and I'll see vwhat I can do.

    John

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Business Alert Error :xp_sendmail erro

    Any help guys ?

    where as below SP is working

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name ='GPAlert',@recipients = 'sandip@abc.com',

    @body = 'Just testing the mail',

    @subject = 'Sending Mail using Database Mail' ;

    GO

    It work fine. Don't know why GP Business alerts is not working.

    How can I change " Dynamics GP Business Alert to "SP_Send_DbMail" ?

    Your earliest reply is highly appreciable.

    Thanks

    Sandip Jadhav

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans