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 |
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.
ReplyDeletePest control craigieburn
Great survey, I'm sure you're getting a great response. Access Control Systems
ReplyDeleteIts 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
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteTouchTec 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
ReplyDeleteCctv Camera In Mohali
Cctv Camera In Chandigarh
Cctv Camera Panchkula
Cctv Camera Zirakpur
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
ReplyDeleteI 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
ReplyDeleteThis 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