Showing posts with label business. Show all posts
Showing posts with label business. 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?

A connection could not be made to the report server http://[IP Address]/ReportServer

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh

Hi,

I too faced the same problem. I have a temporary solution . First copy these files in the machine ( Report Server ). copy the full folder i.e folder containing the reports and its handles(.vssscc files,.rptproj files). Then deploy it. This worked .

Regards

neevarp

A connection could not be made to the report server http://[IP Address]/ReportServer

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh

Hi,

I too faced the same problem. I have a temporary solution . First copy these files in the machine ( Report Server ). copy the full folder i.e folder containing the reports and its handles(.vssscc files,.rptproj files). Then deploy it. This worked .

Regards

neevarp

Thursday, March 22, 2012

A commitment to respond to your post within two business days

I thought there is someone at Microsoft checking the managed newsgroups and
helps MSDN subscribers in trouble.
Please feel free to look at, discuss and answer to my post on 2005-05-21
conserning out replication problem (unresolved yet).
When we pay for our MSDN subscription there was no 2 or 3 bussiness days
before Microsoft collects the money from our bank account,
Request Ltd.,
Software and Parking automation solutions,
Sofia-BG
No such commitment exists...these newsgroups are publicly available and are
responded to by the average person, MVPs and Microsoft employees on a purely
volunteer basis
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"see more" <seemore@.discussions.microsoft.com> wrote in message
news:466B54C8-1B37-44FC-806F-A774B1C3878F@.microsoft.com...
>I thought there is someone at Microsoft checking the managed newsgroups and
> helps MSDN subscribers in trouble.
> Please feel free to look at, discuss and answer to my post on 2005-05-21
> conserning out replication problem (unresolved yet).
> When we pay for our MSDN subscription there was no 2 or 3 bussiness days
> before Microsoft collects the money from our bank account,
> --
> Request Ltd.,
> Software and Parking automation solutions,
> Sofia-BG

Tuesday, March 20, 2012

A bit of Crystal Reports 8.5 help

Hi all, first post!

I'm working for a company that runs a business management system which uses an old version of Crystal Reports (version 8.5!) for reporting on pretty much anything the system can output.

I don't know how much it differs from the newer versions, but i'm new to the system (two days experience and counting) and I'm after a couple of pointers.

1) I am trying to output stock levels for products which are both in and out of stock. Now, due to some sillyness when the BMS was designed, if a product is out of stock, it has doesn't have a row in the bins_lots table (where stock levels are kept), rather than 0.
Therefore, if I do a report which outputs the stock levels of a product (part, items that are out of stock are missing from the report, rather than having a 0 next to their name.
Is it possible to tell Crystal that if a product exists but doesn't have an entry in bins_lots (where stock amounts are kept) then it should be 0?
I'd find this easy if it were a normal If Statement, but Crystal has to be difficult with its wierd way of doing conditionals.

2) Secondly, again due to the BMS design, if a product is on order, the amount in the order is logged in multiple purchase orders. Producing a query will give me duplicate entries for products. I know I can 'hide duplicates', but it results in a messy report.
Can I make Crystal add all of these numbers together (i.e. where product = 'AD-03', add quantity of due products together) and output the final result without using the subtotal/group functions.

All help appreciated :)1) Left join to the bins_lots table. When the amount column is null then there's no stock.
e.g. a formula to return the stock level would be (assuming your column is called amount)
if isnull({bins_lots.amount}) then 0 else {bins_lots.amount}

2) Well, I don't really know how you're going to add numbers without grouping / total functions. Why is grouping an issue? Why can't you group on the product, hide the detail, and print in the product group footer to get 1 record per product? Nothing messy there.