Master Data Services–Business Rule Activation error and its fix


While preparing for a demonstration of SQL Server 2008 R2 Master Data Services – vanilla build – my colleague Lee Theofanis from Decision Resources came across an issue regarding business rule activation.

The Issue

After creating a business rule through the Master Data Manager portal, and then trying to activate it results in the following error – A database error has occurred. Contact your system administrator. See below screenshot.

image

Fix

After investigation by my colleague Lee, the issue occurs due to the incorrect permission settings for the Master data services application pool identity. 

The application pool identity that is created for the MDS application is set to have “mds_exec” database role.  There is currently a problem where the business rule publication process requires sysadmin or db_owner role.

This is a known issue that is being fixed in the first cumulative update for MDS that should be available shortly.

Follow the steps below as a workaround.

a) In IIS, look and see which user is specified for the application pool Identity:
clip_image001

b) In SQL Server Management Studio, find this same user under the MDS database > Security> Users

clip_image002

c) Right-click and make sure that the user has db_owner privileges on the database.

clip_image003

Comments (2)

  1. aw says:

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Depnaker
    http://www.lokerjobindo.com
    http://lokerjobindo.com
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Agustus
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20April
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Desember
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Februari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Januari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juli
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juni
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Maret
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Mei
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20November
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Oktober
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20September
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BursaKerja
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BRI
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Mandiri
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Banyak%20Posisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terkini
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D1
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D2
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D4
    http://www.lokerjobindo.com/2016_01_01_archive.html
    http://www.lokerjobindo.com/2016_02_01_archive.html
    http://www.lokerjobindo.com/2016_03_01_archive.html
    http://www.lokerjobindo.com/2016_04_01_archive.html
    http://www.lokerjobindo.com/2016_05_01_archive.html
    http://www.lokerjobindo.com/2016_06_01_archive.html
    http://www.lokerjobindo.com/2016_07_01_archive.html
    http://www.lokerjobindo.com/2016_08_01_archive.html
    http://www.lokerjobindo.com/2016_09_01_archive.html
    http://www.lokerjobindo.com/2016_10_01_archive.html
    http://www.lokerjobindo.com/2016_11_01_archive.html
    http://www.lokerjobindo.com/2016_12_01_archive.html
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-2016.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-januari-2016.html
    http://www.lokerjobindo.com/2015/08/info-lowongan-kerja-bulan-januari-2016.html

  2. wq says:

    http://www.michaelkorsoutlets-online.us.com/
    http://www.pandora-charms-canada.ca/ and
    http://www.the-north-face.ca/
    http://www.nikeshoesoutlet.org.uk/ it
    http://www.ralphlaurenoutlet.us.com/
    http://www.tiffany-jewelry.in.net/ covers
    http://www.thejoreseproject.com/
    http://www.rolex-watches-canada.ca/ the
    http://www.uggbootsclearance.com.co/ http://www.yoga-pants.ca/ following
    http://www.northfaceoutlet.com.co/
    http://www.truereligionjeans.net.co/ points:
    http://www.nike-air-max.com.au/
    http://www.toms–outlet.com.co/ ManagingMany
    http://www.oakley-outletstore.us.com/
    http://www.ralph-laurenoutlet.co.uk/ of
    http://www.ugg-boots-australia.com.au/
    http://www.guccihandbags.net.co/ you
    http://www.marcjacobs.us.com/ http://www.reebok.com.de/ new
    http://www.uptocoachoutlet.com/
    http://www.cheapoakleysunglasses.ar.com/ SQL
    http://www.louis-vuitton-taschen.com.de/
    http://www.nfl-jersey.us.com/ Server http://www.new-balance.ca/
    http://www.nike-air-force.de/ DBAs
    http://www.ralph-laurenoutlet.ca/
    http://www.true-religion.com.co/ may
    http://www.the-tnfjackets.us.com/ http://www.jimmychoo.net.co/ be
    http://www.adidas.com.se/
    http://www.basketballshoes.com.co/ wondering
    http://www.michael-kors.com.co/
    http://www.longchampoutlet.com.co/ what
    http://www.swarovski-australia.com.au/
    http://www.cheap-baseballbats.net/ are
    http://www.jordanrelease-dates.us.com/
    http://www.outletonline-michaelkors.com/ the
    http://www.newbalance-outlet.org/ http://www.longchamp.com.co/ things
    http://www.ray–ban.ca/
    http://www.hollister.us.org/ to http://www.uhren-shop.com.de/
    http://www.louis-vuittonblackfriday.com/ lookout
    http://www.chanel-bags.com.co/
    http://www.tnfjackets.us.com/ for http://www.nikefree-run.net/
    http://www.ray-ban-sunglasses-outlet.in.net/ to
    http://www.pradahandbags.net.co/
    http://www.poloralphlaurenoutlet.net.co/ effectively
    http://www.barbour-factory.com/ http://www.pradaoutlet.com.co/ maintain
    http://www.michael-kors.com.es/
    http://www.moncler-outlet.us.org/ a
    http://www.ralphlaurenoutlet-online.us.com/
    http://www.burberryoutletonlinesale.in.net/ production
    http://www.weddingdressesuk.org.uk/
    http://www.louisvuitton.jp.net/ SQL
    http://www.bebeclothing.in.net/ http://www.prada.com.de/ Server
    http://www.hilfigeroutlet.in.net/
    http://www.abercrombieand-fitch.ca/ database.
    http://www.celine-bags.org/