Wednesday, February 15, 2012

Error While Depoloying Report Model Project

Hi,

I am trying to deploy my report model project to remote server which is our QA environment using Visual Studio. In my Project Property I have set the Traget Data source folder and model folder and URL. But I am getting this error any idea?

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

A connection could not be made to the report server "ReportServer URL for my remote server"

. (Microsoft Semantic Model Designer)

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

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.SemanticQueryDesign)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportingServices.ModelDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportingServices.ModelDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportingServices.ModelDesigner.Project.ModelClientManager.GetCredentials(String url)
at Microsoft.ReportingServices.ModelDesigner.Project.ModelProjectDeployer.PrepareDeploy()

What kind of permission/role do I need to have inorder to deploy report model project on to the server. I am able to deploy same project on my local machine using visual studio.

Thanks!!!

You are not using the right address for the report server or the Report WebService is not working properly, you will have to provide the adress of the Report Server WebService address which is by default http://localhost/ReportServer (on the localhost). browse to this address in your IE to see if the address is working and Reporting Server is responding.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Hi,

I found the solution actually the issue is how the folders structure.

In our QA environment we have different folders for different projects.

This is how I was trying before:

Target DataSourceFolder: Data Sources

Target ModelsFolder: Models

TargetURL: http://servername/reportserver/CRAS1

Notice the folder name at the end of the URL.(thats the project folder I wanted this Model project to be in)

This is how its now and its working:

Target DataSourceFolder: CRAS1/Data Sources

Target ModelsFolder: CRAS1/Models

TargetURL: http://servername/reportserver

I hope this helps to someone like me who does this kind of stupid mistake.

Thanks

Ashwini

No comments:

Post a Comment