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
Your Welcome Carlos - good to see a post from a few years back helped you out.
Cheers
Rich
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
Stephen - good to see you have it sorted out - Rich.
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
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.
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
<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.
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
