User Domain\User does not have required permissions.

Error : User Domain\User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Solution :

1. Right click on Internet Explorer and select Run as Administrator.

2. Now enter Report Manager URL in Internet Explorer. In my case it is

http://localhost/Reports/Pages/Folder.aspx 

3. Then click on Site Settings (Upper Right Corner).

4. Now you can see the screen looks like below screenshot.

5. Click on Security Tab from left menu and then click on New Role Assignment.

6. Now add group or username that you want to give access and select role. Here I select both roles. Then click on OK button.

Now your site settings page looks like below :

7. Now go to Home Page. Then click on Folder Settings.

8. Now add group or username that you want to give permission and select required roles. Here I select Browser, Content Manager & My Reports. Then click on OK button.

9. Now your Folder Settings screen looks like below:

After completing above steps, Open Internet Explorer normally and go to Report Manger URL. It will work without above mentioned error.

If any query, let me know.

For contact information, go to following link :

http://bhushan.extreme-advice.com/about-bhushan-shah/

SSRS- How to create Shared Schedule and how to utilize it

1.   Background

The aim of this article is to describe how to create shared schedule and its utilization in Reporting services.

2.  What is Shared Schedule?

 A shared schedule is a multipurpose schedule that provides ready-to-use schedule information to any number of reports. Shared schedules can be centrally managed, paused, and resumed. It can be utilized for the following:

• Report Subscription
• Report Snapshot
• Cache Refresh Plan/ Expiration Plan for Dataset and Report

3.   Prerequisite

•  Reporting Services should be configured
• SQL Agent service should run.
• Credential should store securely in the report server for the data source mapped to Report/Report Data set. Below is the screenshot from Data source property page:

.

4.  Steps to create shared schedule in SSRS:

                I.        For shared schedule, go to site setting then Schedule and Click on New schedule

 

              II.        Provide the details about schedule and click ok to create shared schedule: Here we are going to create schedule that will run first day of each month.

 

             III.        Here we can see shared schedule has been created.

 

            IV.        For Report Snapshot: To utilize it for Report Snapshot, go to the report property, Processing Option and select “Render this Report from Report Snapshot”. Here you can use shared schedule for creating the report snapshot at specific point of time.

 

              V.        For Report cache expiration: we can schedule cache expiration of any report. go to the report property, Processing Option and the select “Always run this report with most recent data ” and select the schedule for cache expiration.

 

            VI.        For Cache Refresh Plan: Select the “Cache Refresh Plan” and click on “New Cache Refresh Plan”

 

Now give the description of the Cache refresh plan and select the shared schedule:

Apply the same steps for Dataset Cache Refresh plan.

           VII.        Dataset Cache expiration:

 

          VIII.        Report subscription: In the Report property, select subscription and click on new subscription:

 

It will the subscription page. Fill the required details and select the shared schedule for the subscription

 

5.   Conclusion

By using the above steps, we can create shared schedule and can be utilize for Report subscription, Report Snapshot, Cache Refresh Plan and Cache expiration

----------------------------------------------------End of Document---------------------------------------------------