Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts

Monday, March 19, 2012

Error on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
MarcusI just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||I just reinstalled SQL Server and applied the most recent service
pack. Still no go. Anyone?
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||On Mon, 20 Aug 2007 22:13:29 -0000, Marcus <holysmokes99@.hotmail.com>
wrote:
>I just reinstalled SQL Server and applied the most recent service
>pack. Still no go. Anyone?
>Marcus
I suggest asking in microsoft.public.sqlserver.integrationsvcs, rather
than in the .server group.
Roy Harvey
Beacon Falls, CT
Posted by arithm at 9:47 AM 0 comments
Labels: , , , , , , , , , , , , ,

Sunday, February 26, 2012

Error Message trying to deploy report.

I saw this posted about 6 weeks ago, but have not had the time to look. Could use some help.

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\web.config' 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\web.config' because access is denied.
at System.Web.DirectoryMonitor.AddFileMonitor(String file)
at System.Web.DirectoryMonitor.StartMonitoringFile(String file, FileChangeEventHandler callback, String alias)
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\web.config' 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

Thanks!

Terry

Hello Terry,

You might want to take a look at this post, this user had the same issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=745372&SiteID=1

Jarret

|||I had the same problem, but when I allowed the NETWORK SERVICE account full permission on inetpub/wwwroot the problem went away. Here is the real question, why the hell is is looking at inetpub/wwwroot when the reportserver files are not even in wwwroot?|||YOu will need to allow the Worker process the IIS is running with access to the path mentioned in the error message.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Yes, but why is it mentioning that path when there are no other references to it in the project? The path in the error is wwwroot\web.config. This is not where my project is and nothing in my project is looking there, so where is it getting this path from?

Posted by arithm at 9:29 PM 0 comments
Labels: , , , , , , , , , , , ,
Subscribe to: Posts (Atom)