Showing posts with label vs2005. Show all posts
Showing posts with label vs2005. Show all posts

Sunday, March 25, 2012

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

Hello Guys,

Please take me out from this hell. I created report using VS2005 Business Intelligence Project. It builds fine. I can also see data in the design time. But when I am trying to deploy it gives me this error.

TITLE: Microsoft Report Designer

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


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>
<!--
[HttpException]: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied.
at System.Web.FileChangesMonitor.FindDirectoryMonitor(String dir, Boolean addIfNotFound, Boolean throwOnError)
at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback)
at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback)
at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
[ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied. (c:\inetpub\wwwroot\web.config)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()
at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()
at System.Web.Management.HealthMonitoringManager..ctor()
at System.Web.Management.HealthMonitoringManager.Manager()
at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK


Hello Rahul,

Since you're getting access denied errors on 'c:\inetpub\wwwroot', can you make sure you have access to that directory? Also, check the security settings within IIS.

Jarret

|||

What happens when you try to navigate to http://localhost/ReportServer ?

|||

Try using www.sysinternals.com filemon to determine what the cause of the access denied error is.

Here is a similar message with resolution:

http://weblog.gpconsulting.com/archive/2005/08/26/181.aspx

cheers,

Andrew

|||

Hello Guys,

Thanks fro your reply.

Jarret: Security Settings witht the IIS is fine.

GregSQL : Here is the error when I run on IE

Server Error in '/ReportServer' Application.


Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied.

Source Error:

[No relevant source lines]


Source File: c:\inetpub\wwwroot\web.config Line: 0


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210


Andrew - T4G : I already gone throgh that link, but does not worth.

|||

Did you try filemon?

Here are some detailed steps to troubleshoot.

http://tinyurl.com/3647cg

|||Your report server is not configured properly. Most likely has something to do with IIS and/or the web publishing directory c:\Inetpub\wwwroot.|||

Below is the output of Filemon When I try to run http://localhost/Reports/ in IE,

47 11:04:36 AM aspnet_wp.exe:632 QUERY INFORMATION C:\inetpub\wwwroot\web.config NOT FOUND Attributes: Error
48 11:04:36 AM aspnet_wp.exe:632 QUERY INFORMATION C:\inetpub\wwwroot\web.config NOT FOUND Attributes: Error
49 11:04:36 AM aspnet_wp.exe:632 QUERY INFORMATION C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\PrecompiledApp.config NOT FOUND Attributes: Error

This is just for the information, no web.comfig is present in wwwroot and no PrecompiledApp.config is present in C:\...\ReportManager directory. The ReportManager and ReportServer directories is the virtual directory on the IIS, which is automatically made, if you choose, default configuration while installing SQL Server 2005.

The only config files present in the C:\...\ReportManager directory are:

RSWebApplication.config, Web.config, rsmgrpolicy.config

and in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer are:

rsreportserver.config, rssrvpolicy.config, Web.config

What I can trouble shoot with the above information?

Thursday, March 22, 2012

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?sql

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?

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
The project could not be deployed to the 'localhost' server because of the following connectivity problems: A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
The project could not be deployed to the 'localhost' server because of the following connectivity problems: A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?sql