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.

Fig 1.0


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


  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

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

  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

  4. This comment has been removed by the author.

  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

  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

  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

  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

  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?

  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

  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