question

Kris-7804 avatar image
0 Votes"
Kris-7804 asked Kris-7804 answered

SQL Server 2019 Master Data Services website error

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


sql-server-generalwindows-server-iis
mds-db.jpg (15.1 KiB)
mds-web.jpg (43.2 KiB)
mds-error.jpg (29.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Kris-7804,

This error message is general. I could not find any useful information from this error message. May be something you missed during the configuration.
I follow the steps from this MS document to configure MDS, it works well for me. Suggest you reading the MS document to find if you missed something.
146348-screenshot-2021-11-04-155256.jpg


0 Votes 0 ·

1 Answer

Kris-7804 avatar image
0 Votes"
Kris-7804 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.