Last post Jun 08, 2011 03:02 AM by You-Hu Fu
Jun 07, 2011 01:48 AM|Shaikh Wahid|LINK
I am trying to deploy the reports from Sql Server Business Intelligence Developement Tool 2005 and I am getting the following error:
"A connection could not be made to the report server http://server/ReportServer
The Underlying connection was closed: THe connection was closed unexpectedly.
After that I tried to deploy the same reports directly from server In that case I am getting the following error:
"The permissions granted to user 'domain\user' are insufficient for performing this operation"
And when I deplying on local system it is working fine.
Plase can anyone help me to sort out this issue.
Help would be appreciated.
Thanks & Regards,
Jun 07, 2011 05:13 AM|Ashutosh Pathak|LINK
does the user credentials, you are passing when accessing the report server have the roles below in Report server:
Browser, Content Manager, My Reports, Publisher
if not please try to give them permissions, you can do this by clicking on the properties tab when you first open the report viewer page
Jun 08, 2011 03:02 AM|You-Hu Fu|LINK
Just as Ashutosh's reply, please make sure the user you are using has enough permisstion to deploy the report to report server, you can refer to below link about Setting Permissions in Reporting Services, besides, please make sure the TargetURL is correctly,which
is your report server's URL rather than report manager. Below are the reference:
Report Manager: http://servername/Reports
Report Server: http://servername/ReportServer
For more information about How to: Set Deployment Properties (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms155802.aspx
Fore more information about Setting Permissions in Reporting Services, please see: