Wednesday, March 28, 2012

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

No comments:

Post a Comment