A connection could not be made to the report server

While attempting to deploy from within VS2005 running on 2003 server we get the following error:

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://xxxxx:90/ReportServer.

Running sql2005 sp2 integrated w Sharepoint 2007

Thanks..

Can you navigate to the Report manager surface ? on http://xxxx:90/reports ? Is Sharepoint running in the same port as the reporting server ?

Jens K. Suessmeyer.

http.77www.sqlserver2005.de

|||

Hi - no attempting to get to /reports generates the following error: The operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)

Sharepoint is port 80 - rs is 90.

admin is the service account and anon access is disabled on the web side

Hope that answers the questions - we are new to using rs and visual studio

V

|||

Anonymous,

What sku are do you have for SQL RS 2005 SP2? Share Point Integrated mode is supported only for Enterprise, Developer, Standard, and Evaluation.

Mihaela

|||

Hi - we are using SQL2005 Standard & SP Enterprise. Just to provide more detail if it helps...

We did the SQL install - installed the additional services (report, analysis etc..) - then loaded SP2.. The install for the RS was not the default - just files only.

We recreated in IIS another website RSSITE using port 90

Downloaded and installed the Report add-in for SP2007

Went into Report Config went through the options for a native install

We were able to get to http://xxxx:90/reports

We then changed the installation to SP integrated

We went into SP admin and followed the setup steps including creating a doc library

We could get to http://xxxx:90/reportserver (however there was nothing there)

We then followed these directions to get a model created: http://www.sharepointblogs.com/helloitsliam/archive/2007/03/04/20410.aspx

All went well until the deploy option -

all service accounts are the admin account and all actions were executed on the 2003 server..

Thanks - hope this is helpful info....

|||

Anonymous,

It seems that you have the right sku for Reporting Services to be able to work in Share Point Integrated mode.

When you are working in Share Point integrated mode, the Report Manager feature is disabled, so the error you see when you try to connect to ../reports after switching to Share Point mode is expectable.

I would like to ask you to take a look int he Report Server log files and to see what errors you find there and to post them here.

Thank you,

Mihaela

|||

w3wp!library!1!04/02/2007-21:45:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode.

Each time we run the deploy from the VS application we see this error in the <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__04_02_2007_21_28_51.log</Path>

No other RS logs seem to update and nothing in the event logs...

(Mon Apr 02 21:28:56 2007.205463218) : Received Event
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************
(Mon Apr 02 21:28:56 2007.205463234) : Could not get pointer to binary resource for file:
(Mon Apr 02 21:28:56 2007.205463234) : \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll[AspNetMofResource](Mon Apr 02 21:28:56 2007.205463234) :
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************

The above was in our wmiprov.log - dont know if it helps...

Thanks

|||I'm seeing the same error under the same set of circumstances. Have you been able to resolve the issue?