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