Master Data Services Gives error Login Failed when tried to login with user other than administrator (using which database was created)


  • I have a Master Data services web application successfully running with the Administrator user (with which database was created). But it gives error Login Failed, when I try to login using other windows user account (to which I have given access to all functions and model in MDS using administrator login)

    Following error is displayed, Please guide how to resolve this error

    Is it a MDS service related Or Database related ?


    Thursday, February 02, 2012 7:24 AM


  • This is surely database issue as error is thrown by Sql client.Check the credentials used for App pool have db_owner access to database.

    Wednesday, February 08, 2012 6:45 AM