Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Unable to see subscription view in MDM database

Answered Unable to see subscription view in MDM database

  • Thursday, August 09, 2012 9:17 AM
     
     
    Sign In to Vote
    0

    Hi,

    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...

     

All Replies

  • Thursday, August 09, 2012 12:40 PM
     
     
    Sign In to Vote
    0

    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 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Borcard,

    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)

    Regards,
    Bin Long

    Bin Long

    TechNet Community Support