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



30 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. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. access card system to buy

    ReplyDelete
  12. 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
  13. 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
  14. 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
  15. 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
  16. This comment has been removed by the author.

    ReplyDelete
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. Your content is useful and entertaining. Maintain the wonderful work. erp customization examples

    ReplyDelete