THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Master Data Services Team

Blog for the Microsoft SQL Server Master Data Services (MDS) team. Blog posts are contributed by various team members.

Enabling Human Workflow – Part 3: Configuring Email Notification

(this post was contributed by Brian Barnett, Senior Software Engineer on the MDS Team)

In Part 1 you made the necessary model changes. In Part 2 you made the security changes to give the new groups the required security access and permissions . In this post we will continue with Step 7, configuring MDS to send out email notifications.

*Note - This post references some features that are forthcoming in the future release of MDS and not available in the CTPs.  It gives you an early look at what is coming to help plan for workflow scenarios such as this.

Step 7: Configure MDS to send email notifications

Select the Start | Programs | Microsoft SQL Server 2008 R2 | Master Data Services | Configuration Manager menu item.


Select Databases in the left panel. Then select Create Profile…


On the Create Database Mail Profile and Account screen fill in the information based on your environment. The Profile name and the Account name shown below are simply suggestions I've supplied but you are free to enter different names if you choose.


There is a System Setting called "Master Data Manager URL for Notifications".  The URL for your MDS application should be specified here.   Once the screen is completed click the OK button. Then click the Apply button. Database Mail should be set up and ready to use.

If desired, you can test it out in SQL Server Management Studio. Expand Management then right-click Database Mail. Select Send Test E-Mail…


In Part 4 we will wrap things up by creating the business rules that drive the human workflow.

Published Wednesday, February 17, 2010 8:18 AM by MDS Team
Filed under: , ,



Master Data Services Team said:

(this post was contributed by Brian Barnett, Senior Software Engineer on the MDS Team) Up until this

February 18, 2010 10:10 AM

Brian Berry said:

When I test the Database Mail function, I so not receive an email, and I see a strange error in the EventLog:

The activated proc '[mdm].[udpNotificationQueueActivate]' running on queue '' output the following:  'Cannot insert the value NULL into column 'User_ID', table 'MDM01.mdm.tblNotificationUsers'; column does not allow nulls. INSERT fails.'

The table "tblNotificationUsers" has no data in it.

What am I missing?

March 25, 2010 4:24 PM

MDS Team said:

Hi Brian,

That was an issue in the Nov CTP release but has been fixed.



March 29, 2010 2:45 PM
New Comments to this post are disabled
Privacy Statement