Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
Master Data Services Gives error Login Failed when tried to login with user other than administrator (using which database was created)

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

  • Thursday, February 02, 2012 7:24 AM
     
     
    Sign In to Vote
    0

    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 ?

    i

     

All Replies

  • Wednesday, February 08, 2012 6:45 AM
     
     Answered
    Sign In to Vote
    0

    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.