Answered by:
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 helpMonday, November 22, 2010 6:49 AM
Answers
-
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"/>
- Marked as answer by Jinchun ChenMicrosoft employee Wednesday, December 1, 2010 9:12 AM
Tuesday, November 30, 2010 5:43 PM
All replies
-
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 FranceMonday, November 22, 2010 4:30 PM -
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
Thursday, November 25, 2010 12:23 PM -
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- Proposed as answer by Obiwanken Tuesday, November 30, 2010 5:36 PM
- Unproposed as answer by Jinchun ChenMicrosoft employee Wednesday, December 1, 2010 9:12 AM
Monday, November 29, 2010 2:41 PM -
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"/>
- Marked as answer by Jinchun ChenMicrosoft employee Wednesday, December 1, 2010 9:12 AM
Tuesday, November 30, 2010 5:43 PM -
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.
Thursday, December 16, 2010 9:13 PM -
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
Monday, January 24, 2011 5:35 PM -
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
- Proposed as answer by Craig Baldwin Friday, August 26, 2011 4:35 AM
Wednesday, July 27, 2011 12:51 PM -
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.
Friday, August 26, 2011 4:34 AM -
- Proposed as answer by Sunil Bukkannagari Tuesday, August 30, 2016 1:15 PM
Wednesday, June 6, 2012 1:08 PM -
- Proposed as answer by Sunil Bukkannagari Tuesday, August 30, 2016 1:15 PM
- Unproposed as answer by Sunil Bukkannagari Tuesday, August 30, 2016 1:15 PM
Wednesday, June 6, 2012 1:09 PM -
Wednesday, June 6, 2012 1:10 PM
-
- Proposed as answer by Sunil Bukkannagari Tuesday, August 30, 2016 1:15 PM
Wednesday, June 6, 2012 2:09 PM -
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
Wednesday, March 25, 2020 3:07 AM -
After 9 years, on SQL 2017. This helped me. I had to disable the anonymous.
Ganesh
Sunday, April 12, 2020 5:52 PM