serving the solutions day and night

Pages

Tuesday, February 7, 2012

Deploying a SSRS report to the Server, SSRS Web Management Portal - User Roles and Permissions

1)Right click on the project. Select properties and there you will get to see the Deployment properties and you should see the TargetServerURL property as shown ihe below image. Set the TargetServerURL value (In the Reporting Services Configuration Tools dialog box, click Web Service URL in the left pane, the URLs below Report Server Web Service URLs just is the URL you should use as the TargetServerURL.)


2)Click on the ‘solution explorer project name’ and right click to select the Deploy option to publish the report to the server.

Once the report is deployed to the server we can see the output message indicating that the deploy is completed.

If you get the below error
"The permissions granted to user 'domain_name\daynight' are insufficient for performing this operation."
You must open Business Intelligence Development Studio with elevated permissions:
From the Start menu, click All Programs, click SQL Server 2008, right-click Business Intelligence Development Studio, and then click Run as administrator.

More information, please see: http://msdn.microsoft.com/en-us/library/bb630430.aspx

3)Copy and paste the URL on to the browser and navigate through the URL. This will allow us to see the list of projects deployed as shown in the screen below.

Here I deployed the 2 project, if you click the "Report Project1" project, it will navigate to the next page where you can see the report listed. Click the report name, then you can the report being generated.

SSRS Web Management Portal - User Roles and Permissions Assign a user or group to a system role
1)Open the Report Manager URL, http://localhost/reports or http://server_name/reports
2)Click on the Site Setting link at the top right corner. Click on Security link at the left side menu to proceed further. By default BUILTIN\Administrators user assigned to System Administrators role.


3)Click on the New Role Assignment menu button. An admin screen will appear with an option to enter the user name to which we need to assign the role. Enter the user name and select their role.

Assign a user or group to a role-based security for Home
1)Open the Report Manager URL, http://localhost/reports or http://server_name/reports
2)Click on the Folder Settings top menu. By default BUILTIN\Administrators user assigned to Content Manager role.
3)Click on the New Role Assignment menu button, it will navigate to the list roles that can be assigned to the user as shown in the screen below. Enter the user name and select their role.

3 comments:

Renato said...

How do we do that using Sql Server Data Tools (formerly BIDS). In Sql Server 2012, we no longer use reporting services configuration manager, I assume there is no longer a report server url for sharepoint integrated mode... My deployment attempts now fail using Sql Server Data Tools (VS2010 sp1) because it relies on a report server url... Any hints?

Daynight said...

What is the error? please give details?

Daynight said...

You can use the BIDS or upload the RDL files to the SharePoint Document Libraries directly.