Resolved: Access denied Error SQL Server Master data services website

This is a resolution to the error " Access Denied" when you install SQL Server Master data services and try to browse the website. Few things I would like to discuss in order to resolve this error:

1- When you install Master Data Services using SQL Server installation media, during the installation you have a choice to add users to have access (Admin) on Master data services Roles, however if you forget to add anyone and complete installation, you will not have access to the Master Data Services Website Roles thus get an error " Access denied " when you browse the newly created website.

2- Only the person(User) who installed and created the website will be able to browse the contents. Once that particular user browse the contents, you get Master Data Services Website Page look like shown in Fig 2.0.

Error:
Fig 1.0



Resolution:

1- Click on User and Group Permissions
Fig 2.0


2- Click on Add (+) button. You have an option to add Groups as well, you need to click on Group instead of users in that case.

Fig 3.0


3- Provide the user name and verify with Active directory, once verified click ok

Fig 4.0



4- Once added, high light that particular user and click on Edit Icon as shown below

Fig 5.0



5- Click on Functions and select proper permission from drop down menu

Fig 6.0

6- Click on Edit again and select the functions you would like the user to perform. Once completed click on save and have user try again accessing the URL.



Fig 7.0


Fig 8.0



33 comments:

  1. creativity of writer is purely impressive. It has touched to the level of expertise with his writing. Everything is up to the mark. Written perfectly and I can use such information for my coming assignment.
    Pest control craigieburn

    ReplyDelete
  2. Great survey, I'm sure you're getting a great response. Access Control Systems

    ReplyDelete
  3. Its as if you had a great grasp on the subject matter, but you forgot to include your readers. Perhaps you should think about this from more than one angle. opencart data entry

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. TouchTec is a leading company in region with more than 10 years of experience that provides Security, Safety and Surveillance Solutions with high assurance to improve security and efficiencies for identity management, access to critical facilities, intelligence analysis, guest worker programs, and national identity programs
    Cctv Camera In Mohali
    Cctv Camera In Chandigarh
    Cctv Camera Panchkula
    Cctv Camera Zirakpur

    ReplyDelete
  6. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... Plombier Paris

    ReplyDelete
  7. I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. access control

    ReplyDelete
  8. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work security alarm

    ReplyDelete
  9. Information Technology (IT) debt is basically the cost of maintenance needed to bring all applications up to date. Shockingly, global "Information Technology (IT) debt" will reach $500 billion this year and could rise to $1 trillion by 2015! But why should you take IT debt seriously and begin to take steps to eliminate this issue from your business? https://cctvcamera75.weebly.com/

    ReplyDelete
  10. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. access control singapore

    ReplyDelete
  11. Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. access control in singapore

    ReplyDelete
  12. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. access card system to buy

    ReplyDelete
  13. Sustaining in a job is no great achievement, being the best of what you are and performing the best in whatever you do is! Wake up to the benefits of career success and stop searching the answer to how to develop a career.occupation

    ReplyDelete
  14. Are you looking to hire home camera installation services at reasonable prices? You must check out Touchtec, we have a flexible solution for your home security and provide the best HD Cctv camera, home security cameras. Visit our website to get to know more about us.

    ReplyDelete
  15. Cctv is now needed in everywhere whether it could be home, office or public place you need to install these cameras for high-security purpose. It kept away from burglars and misshapen. If you want to hire these Cctv camera Services in Mohali, then contact us.

    Cctv cameras Dealers in Chandigarh
    Cctv cameras Installation services
    Cctv Camera Specialist
    Importance home camera installation services
    Best outdoor Cctv camera

    ReplyDelete
  16. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. https://bestaccesscontrolsystems.tumblr.com/

    ReplyDelete
  17. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. http://61f3b1239fd23.site123.me/

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. https://accesscardsingapore.tumblr.com/

    ReplyDelete
  20. I have recently started a blog, the info you provide on this site has helped me greatly. Thanks for all of your time & work. https://biometricaccesscontrol.yolasite.com/

    ReplyDelete
  21. Making sure these important structural elements are correct not only ensures the Search Engines can correctly navigate their way around your website potomitan info

    ReplyDelete
  22. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. access card system to buy

    ReplyDelete
  23. State Insurance commissioners are getting questions "frequently" about these and other concerns, said Sandy Praeger,the Insurance commissioner in Kansas and chair of the Insurance and managed care committee for the National Association of Insurance Commissioners. What Is The Joint Insurance Policy

    ReplyDelete
  24. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. rolet online

    ReplyDelete
  25. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. price of access card system

    ReplyDelete
  26. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. best price biometric access control system

    ReplyDelete
  27. I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. buy online biometric access control system

    ReplyDelete
  28. healthier hair is of course mainly due to genetics but food supplementation can also help you get it; have a peek at this web-site

    ReplyDelete
  29. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. card access system in singapore

    ReplyDelete
  30. Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks https://site-7698619-8061-5329.mystrikingly.com/blog/10-ways-biometric-access-control-systems-can-improve-your-business

    ReplyDelete
  31. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. https://dooraccesssysteminsingapore.edublogs.org/2022/05/27/how-singapores-door-access-systems-became-so-popular/

    ReplyDelete
  32. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. order online biometric access control

    ReplyDelete
  33. very nice blog. it is informative. Looking for a highly secure HID proximity access card reader? We offer card access control systems, long range card reader allowing safe automatic entry.

    ReplyDelete