Master Data Service error access is denied

Question

I am trying to install Master Data Service on a SQL Server 2008 r2 enterprize edition OS is windows server 2008 r2 IIS 7.5 I followed all the steps correctly i.e installating MDS configuration manager , creating DB , Creating website/pool used a single windows id to create DB , made it MDS admin , ran app pool using it IIS windows authentication is also enabled still whenever i try to browse MDS site from IISmanager , i get Access is denied error please help

Answer 1

Hello

 

you must connect to MDS Website with the MDS Admin account and grant access to other users in User management 

what is the service account that you used in MDS IIS App Pool ?

 

---

Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem. _________________________________________________________ Regards, Xavier Averbouch, Consultant, Avanade France

Answer 2

i am using a AD windows ID as MDS Admin account

i am using this same ID to login into the server and trying to access MDS website

but website just doesnt opens up

Answer 3

but what is the service account that you used in IIS App Pool ?

---

Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem. _________________________________________________________ Regards, Xavier Averbouch, Consultant, Avanade France

Answer 4

First...Sorry I proposed as answer the previous question..it was a slip of the mouse. 

I think there are two possible problems here.  First is that the account that is running your Web Broswer does not have permissions to access the MDS site itself (it is not in the User and Group Permission function), or the account does not have permissions on the SQL server instance, or it does not have permission on the IIS instance/box.  Check all of these.

Second, I noticed that you did not mention in your original post that you set the "getHTTPEnabled" flag in the web.config file to true...did you do that? If not set it to true. (or set httpsGetEnabled to true if you are using secure sockets)..may I suggest that you also set, in your dev or test envoroment only, setting the includeExceptionDetailInFaults to true as well...it may save you some troubleshooting time)

 

Without setting one of these to true you can't connect.....e.g. <serviceMetadata httpGetEnabled="true" httpsGetEnabled="false"/>

Answer 5

I am having the same problem, server 2008 r2, iis 7.5, windows authentication enabled, authorization is to allow all users.  i installed mds and created the db and app pool under one user.  I can login to the mds web page when I use that initial installer user only.  I have logged in as that admin user to mds and added myself as a user through the web interface and when I try to login to the web page I get access denied unauthorized.    please advise.

 

 

Answer 6

The issues am having with MDS 'access denied' when using IE 8 256-bit most are Windows 7 users. 128-bit version of browser works fine. Any idea where to tweak the settings?

MDSrooks

Answer 7

I had the same issue. It occurred because I used the configuration manager to set up a new website. This new website was created without windows authentication enabled. I also had to disable anaonymous authentication to get this to work.

 

Hope that helps.

 

Mike

Answer 8

I had the same issue. It occurred because I used the configuration manager to set up a new website. This new website was created without windows authentication enabled. I also had to disable anaonymous authentication to get this to work.

 

Hope that helps.

 

Mike

Yes, I found this exact same issue when I was attempting to recreate an MDS site.

All authentication methods except Windows had to be disabled in IIS.

Answer 9



Answer 10

Answer 11

Answer 12

Answer 13

https://social.msdn.microsoft.com/Forums/en-US/2e2567a5-c44b-41ef-a7e8-c49424c51e7f/web-configuration-of-mds-2016-is-successful-but-not-able-to-access-within-server-or-outside-of?forum=sqlmds

---

Thanks Shiven:) If Answer is Helpful, Please Vote

Answer 14

After 9 years, on SQL 2017. This helped me. I had to disable the anonymous. 

---

Ganesh