SQL Server 2019 Master Data Services website error

Kris 96 Reputation points
2021-11-04T05:14:02.897+00:00

I installed SQL Server 2019 Developer including Master Data Services on my Windows 10 machine. Then, I created MDS DB and Website with MDS Configuration Manager successfully. The web application was associated with an MDS DB. However, when I try to connect MDS site with web browsers (tried different browsers), I got below error.

SQL Server 2019 Master Data Services
Home > Error
Oops! Something went wrong.
The user does not have access to the application.

Referring to different tips in internet, I have tried different ways including:

  • IIS configuration, especially authentication
  • Creating with default website, new website
  • Using Microsoft account, local admin account
  • Uninstall SQL Server 2019 and reinstall

Not working. I have been trying to fix it over 20 hours. Can anyone help me out? Thanks.

Kris

146461-mds-db.jpg

146397-mds-web.jpg

146380-mds-error.jpg

Internet Information Services
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,767 questions
Accepted answer
  1. Kris 96 Reputation points
    2021-11-04T10:58:11.417+00:00

    Finally, I found the cause. My PC is Windows Home edition, not Pro, so Windows Authentication is not included, which is essential to run MDS Web application. After installing additional security package, the problem has been fixed. MDS Web application works well.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest