locked
Permissions error in MDS RRS feed

  • Question

  • I've successfully installed CTP3 on two different systems.  In both cases, everything seems to work except the Import/Export silverlight app.  I keepgetting a 229 error, which I believe is some sort of database permissions problem.
    Thursday, October 13, 2011 11:36 AM

Answers

  • Got the same issue. It is a permission problem. When you add your MDS web app user to the "db_datareader" role within your MDS database then it works fine.... thats kind of a workaround for testing environments but defintely not for production. It seems to be the problem is within the "mds_exec" role - this role should define all necessary permissions within the MDS database for the MDS web application users.
    • Marked as answer by wsmckenz Saturday, October 15, 2011 2:43 AM
    Thursday, October 13, 2011 2:33 PM
  • We had the same issue, the script that we used to fix the permission issue on the MDS database is:

    GRANT SELECT ON SCHEMA::MDM TO  MDS_EXEC AS MDS_SCHEMA_USER;
    GRANT SELECT ON SCHEMA::stg TO  MDS_EXEC AS MDS_SCHEMA_USER;

    That follows the permission structure that seems to already be in place in MDS.

    Martins response should also work.  Just giving another possible solution.

     

    Thanks.

    • Marked as answer by wsmckenz Saturday, October 15, 2011 2:43 AM
    Friday, October 14, 2011 10:08 PM

All replies

  • Got the same issue. It is a permission problem. When you add your MDS web app user to the "db_datareader" role within your MDS database then it works fine.... thats kind of a workaround for testing environments but defintely not for production. It seems to be the problem is within the "mds_exec" role - this role should define all necessary permissions within the MDS database for the MDS web application users.
    • Marked as answer by wsmckenz Saturday, October 15, 2011 2:43 AM
    Thursday, October 13, 2011 2:33 PM
  • We had the same issue, the script that we used to fix the permission issue on the MDS database is:

    GRANT SELECT ON SCHEMA::MDM TO  MDS_EXEC AS MDS_SCHEMA_USER;
    GRANT SELECT ON SCHEMA::stg TO  MDS_EXEC AS MDS_SCHEMA_USER;

    That follows the permission structure that seems to already be in place in MDS.

    Martins response should also work.  Just giving another possible solution.

     

    Thanks.

    • Marked as answer by wsmckenz Saturday, October 15, 2011 2:43 AM
    Friday, October 14, 2011 10:08 PM
  • Thanks all, that did it.
    Saturday, October 15, 2011 2:43 AM