Search code examples
sql-serverauthenticationsql-server-2012master-data-services

Troubleshooting Master Data Services (MDS) Permission Authorization


I have been testing Master Data Services for future project. A few days ago MDS stopped authenticating with clients without any known reason. I am using SQL SERVER 2012 BI edition.

In general, I can access MDS page on the server using http://localhosts/mds; however, if I try to access http://servername/mds from either server or client I get an error message :

ERR_INVALID_AUTH_CREDENTIALS on Chrome or asked for credentials on IE. I cannot authenticate with my credentials.

Please advise


Solution

  • I have found the answer on the link below: Windows authentication failing in IIS 7.5

    There are 2 providers for Windows Authentication (Negotiate and NTLM). When setting the Website Authentication to Windows Authentication, while Windows Authentication is highlighted, click on the Providers link on the right pane or IIS Manager and move NTLM to the top. By default Negotiate is on top which is why you are getting an authentication prompt.