SQL Master Data Services 2019 - Website keeps prompting for login

• Pete Bishop

  Default port

  Points: 1466

  More actions

  September 28, 2022 at 4:12 pm

  Go to Answer

  #4093035

  I have two SQL 2019 servers running Master Data Services which are continually prompting for credentials when accessing the MDS website. I can't find an MDS logfile to see what is failing but I've reviewed all the articles I can find without success:

  • check that login account has access to MDS
  • check that Windows Authentication is enabled on the MDS website
  • ensure that Negotiate is the top Windows Authentication provider (I've also tried the other way around without success)

  Does anyone have any ideas:

  • What else I can try?
  • Where the root cause might be logged?

  Thanks.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 29, 2022 at 5:10 pm

  #4093548

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• September 30, 2022 at 8:15 am

  This was removed by the editor as SPAM

• September 30, 2022 at 8:16 am

  This was removed by the editor as SPAM

• Pete Bishop

  Default port

  Points: 1466

  More actions

  October 13, 2022 at 8:51 am

  Answer

  #4099037

  This may be a niche issue but the resolution (after logging with Microsoft) was as follows:

  1. SPNs on reporting services service account had to be updated to HTTPS/... as opposed to HTTP/... as they were originally
  2. Remove the RSWindowsNegotiate option from the reporting service configuration file

  Item 1 fixed the MDS issue but broke reporting services - it exhibited the same "looping credentials" problem

  Item 2 fixed the newly-created reporting services problem