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
Site Settings - > Security - > New Role Assignment - > add user with administrator role.
Home - > Folder Settings - > New Role Assignment - > add user with desired role.

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
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
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
No comments:
Post a Comment