SSRS - Report Deployment

After creating the report,I tried to deploy the report,I am going to share about the same in this post.

I have SSRS 2008 R2 installed on Windows 7.

Create a sample report,once its running fine,start deploying it by following below steps


In SSRS,under Solution Explorer,right-click on report project -> Build

Again,under Solution Explorer,right-click on report project -> Properties ->
Under Deployment -> TargetServerURL -> we need to metion the target URL.

For that All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools - > Reporting Services Configuration Manager.

Once you connect to Reporting Services Configuration Manager , under Web Service URL ,you will find an URL .





Enter that URL ,under Solution Explorer,right-click on report project -> Properties ->
Under Deployment -> TargetServerURL.

and then ,under Solution Explorer,right-click on report project -> Deploy

Once your deployment is successful , try to query catalog table in Report Server as shown below

• If you encounter permission problem,try like below

   Site Settings - > Security - > New Role Assignment - > add user with administrator role.

    Home - > Folder Settings - >  New Role Assignment - > add user with desired role.

• To install Internet Information Services,try like below

All Programs -> Control Panel - > Programs - > Turn Windows features on or off



Reference for detailed information[installing IIS] - http://www.iis.net/learn/install/installing-iis-7/installing-iis-on-windows-vista-and-windows-7

Reference for detailed information [Permission problem] - http://msdn.microsoft.com/en-us/library/bb630430%28v=sql.105%29.aspx