Thursday, August 09, 2012 9:17 AM
I'm doing a POC on SQL 2012 focused on MDS (version : 11.0.2100.60 )
I have generated a subscription view from one entity.
I didn't get any error message.
Nevertheless, I browse the mdm database and I don't see any SQL view created whith the name I put during the subscription view creation.
Is there something to do with access rights to the mdm database ?
If somebody can help me, could be great...
Thursday, August 09, 2012 12:40 PM
As a workaround I add the database role "db_owner" to my account and it works...
It seems something is missing when giving rights to "integration management".
is anybody can confirm what I suppose ?
Thanks a lot.
Monday, August 13, 2012 10:14 AMModerator
In Master Data Services, there are two types of administrators: model administrators, and the Master Data Services system administrator. In this case, you must be a model administrator.
For more information, please see:
Administrators (Master Data Services): http://technet.microsoft.com/en-us/library/ff487051(v=sql.105)
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Sunday, August 19, 2012 2:50 PM