web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 business alerts ...
Microsoft Dynamics GP (Archived)

GP 10 business alerts - how to use Database Mail?

(0) ShareShare
ReportReport
Posted on by Community Member

Is there a setting I'm missing to tell GP 10 to use SQL 2005's Database Mail instead of the older SQL Mail stored procedures? Or some other "quick" solution to use the new DB Mail procedures?

 I'm considering just rewriting the smRuleSendMail procedure that GP created to respond to business alerts to use the  DB Mail procedures, but I'm not sure if this could cause inadvertent issue with GP.

 Any Suggestions/ideas are welcome!

 Thanks,

 Tom

*This post is locked for comments

I have the same question (0)
  • Richard Prior Profile Picture
    Richard Prior 190 on at

    Gidday Tom - Richard here in Sydney.

     There is a Knowledgebase article  "KB915097" on Customersource, I wondered if you have spotted that yet.  This article describes both the setting up of SQL Mail and Database Mail.  The informtion on Database mail and the Store Procedures for Business Alerts as at the bottom of the page.  Mentioned are 4 replacement stored procs as SQL scripts, these are: KB915097_smRuleSendMail_DYNAMICS.sql, KB915097_smRuleTestSendMail_DYNAMICS.sql, KB915097_smRuleTestSendMail_Company.sql and KB915097_smRuleSendMail_Company.sql.

    These Store porcs replace those of the same name and use the database mail stored procs instead of those like xp_sendmail used by SQL mail.

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;915097

    While this article references 64 bit SQL 9 I have yet to implement it on 32 bit SQL 9 to confirm the instructions in the article together with the supplied stored procs work on both 32 and 64 bit SQL 9 with Dynamics GP 9 or 10.

     

    Richard

  • Saroku Profile Picture
    Saroku 45 on at

    Greetings Richard,

  • Saroku Profile Picture
    Saroku 45 on at

    <Browser issues.. argh> but anyways..

     Hello Richard..

    I have setup Database Mail on SQL2005 64-bit enterprise and can send test messages just fine.  I have Dyanmics 10 SP3 installed. However, when I try to run the scripts you mentioned, I get an access error that DYNGRP is not found.  I am logged into SQL Svr Management Studio as 'sa'.  Do you have any idea what I'm doing wrong? I'm assuming 'sa' doesn't have permissions to grant execute permissions on the group role..

     Here's the error I get on all four scripts..

    Msg 15151, Level 16, State 1, Line 1

    Cannot find the user 'DYNGRP', because it does not exist or you do not have permission.
  • Richard Prior Profile Picture
    Richard Prior 190 on at

    Hi Saroku

    Your error message suggests the scripts from Microsoft are referencing the USER  'DYNGRP' and not the ROLE 'DYNGRP'.  As you know 'DYNGRP' is a role and should be present in the DYNAMICS and all company databases.

    1. Confirm the database you are executing the the script against does have the role 'DYNGRP'
    2. Isolate the part of the script that generates your error to identify what statement results in the error.  (it may be there is a problem with the Microsoft supplied script which is more likley).

    Since my first exposure to SQL at 4.2 (???) I have yet to see the sa user having less than full permissions in the SQL engine.  However others may have seen this happen before and may like to comment, I dont think the rights of the 'sa' user is your problem.

     

    Richard  - in Sydney

  • Saroku Profile Picture
    Saroku 45 on at

    I found out that I was running the script against the master dbo instead on the individual dynamics and customer instances.  Thanks for your response though.. nice to there's help out there!

     Stephen - in Indianapolis

  • Richard Prior Profile Picture
    Richard Prior 190 on at

    Stephen - good to see you have it sorted out - Rich.

  • Carlos Cabrera Profile Picture
    Carlos Cabrera 200 on at

    Hola Richard

    Thank you very much for providing this information, thanks to you I was able to get the GP Business Alert to work.

    Once again, thank you very much

    Carlos  

  • Richard Prior Profile Picture
    Richard Prior 190 on at

    Your Welcome Carlos - good to see a post from a few years back helped you out.

    Cheers

    Rich

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans