I just installed SQL Server 2005 (Reporting Services) on my collegues laptop
(Windows XP, SP2) and when we try to deploy the reports we get the message:
"A connection could not be made with report server at
http://localhost/ReportServer"
Everything is running (green checks) in the Reporting Services configuration
manager. We get the error, "Page not found." when we just try to open
http://<machinename>/Reports or http://localhost/Reports. I see the virtual
directories in IIS, all services seem to be running correctly.
Please help! I have installed reporting services about 10 times and have
not run into this problem before. The only issue that we had initially was
that the IIS default web site would not run because there was a conflict on
TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
problem should it.
Thank you,
Laurie
--
LaurieTWhat happens when you try going to http://localhost/?
Have you tried http://localhost:81/Reports, since that's what you changed
the port to?
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>I just installed SQL Server 2005 (Reporting Services) on my collegues
>laptop
> (Windows XP, SP2) and when we try to deploy the reports we get the
> message:
> "A connection could not be made with report server at
> http://localhost/ReportServer"
> Everything is running (green checks) in the Reporting Services
> configuration
> manager. We get the error, "Page not found." when we just try to open
> http://<machinename>/Reports or http://localhost/Reports. I see the
> virtual
> directories in IIS, all services seem to be running correctly.
> Please help! I have installed reporting services about 10 times and have
> not run into this problem before. The only issue that we had initially
> was
> that the IIS default web site would not run because there was a conflict
> on
> TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> problem should it.
> Thank you,
> Laurie
> --
> LaurieT|||Clint -- Thanks, I tried this and still got some errors (although different
than I was seeing before).
I got this error when trying http://localhost:81/Reports
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
----
A name was started with an invalid character. Error processing resource
'http://localhost:81/Reports'. Line 1, Position 2
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag..."
Any ideas?
Thank you.
--
LaurieT
"Clint" wrote:
> What happens when you try going to http://localhost/?
> Have you tried http://localhost:81/Reports, since that's what you changed
> the port to?
> Clint
> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> >I just installed SQL Server 2005 (Reporting Services) on my collegues
> >laptop
> > (Windows XP, SP2) and when we try to deploy the reports we get the
> > message:
> > "A connection could not be made with report server at
> > http://localhost/ReportServer"
> >
> > Everything is running (green checks) in the Reporting Services
> > configuration
> > manager. We get the error, "Page not found." when we just try to open
> > http://<machinename>/Reports or http://localhost/Reports. I see the
> > virtual
> > directories in IIS, all services seem to be running correctly.
> >
> > Please help! I have installed reporting services about 10 times and have
> > not run into this problem before. The only issue that we had initially
> > was
> > that the IIS default web site would not run because there was a conflict
> > on
> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > problem should it.
> >
> > Thank you,
> > Laurie
> > --
> > LaurieT
>
>|||Sorry, I got nothing else. :) I'm pretty much an RS newbie. Hopefully
someone else can chime in for you.
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:71DB89B9-F5F4-445E-A480-95A635B73ECB@.microsoft.com...
> Clint -- Thanks, I tried this and still got some errors (although
> different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
>> What happens when you try going to http://localhost/?
>> Have you tried http://localhost:81/Reports, since that's what you changed
>> the port to?
>> Clint
>> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
>> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>> >I just installed SQL Server 2005 (Reporting Services) on my collegues
>> >laptop
>> > (Windows XP, SP2) and when we try to deploy the reports we get the
>> > message:
>> > "A connection could not be made with report server at
>> > http://localhost/ReportServer"
>> >
>> > Everything is running (green checks) in the Reporting Services
>> > configuration
>> > manager. We get the error, "Page not found." when we just try to open
>> > http://<machinename>/Reports or http://localhost/Reports. I see the
>> > virtual
>> > directories in IIS, all services seem to be running correctly.
>> >
>> > Please help! I have installed reporting services about 10 times and
>> > have
>> > not run into this problem before. The only issue that we had initially
>> > was
>> > that the IIS default web site would not run because there was a
>> > conflict
>> > on
>> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't
>> > be a
>> > problem should it.
>> >
>> > Thank you,
>> > Laurie
>> > --
>> > LaurieT
>>|||laurie,
I had the same problem and Now it has been fixed.i looked online and
here is what i found:
1)The FIX
For IIS MMC: Right click My Computer...then click manage...under
services and applications....expand IIS
then right click the "reports" virtual directory, select property and
then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2.something. For some reason, after you installed reporting
services,
the version of the ASP.NET was removed from the asp.net tab. click ok
2)New Problem
Then you get this new problem when you go to http://localhost/Reports/
--my comment Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException:
Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the
IIS metabase (e.g. IIS://servername/W3SVC). For information on
modifying metabase permissions, please see
http://support.microsoft.com/?kbid=267904 .
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
+3609369 System.Web.CachedPathData.GetPathData(String path) +406
System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
(String sectionName, Type type, ResultsIndex index) +134
2) The FIX
To correct the problem To repair IIS mappings for ASP.NET, run the
Aspnet_regiis.exe utlity. To do so, follow these steps:
Click Start, and then click Run.
Type cmd, and then click OK.
At the command prompt, type the following command, and then press
ENTER:
"\<Windows folder>\Microsoft.NET\Framework\<Version
Number>\aspnet_regiis.exe" -i
NOTE:Replace <Windows folder> with the name of the directory where the
operating system is installed and replace <Version Number> with the
.NET Framework version installed on your computer. Or you could do a
seach for the .exe file and locate the directory
You can find the above reference at
http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
Now try going to http://computername/reports/
Hope it helps,
Sharan Doddakashi
LaurieT wrote:
> Clint -- Thanks, I tried this and still got some errors (although different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
> > What happens when you try going to http://localhost/?
> >
> > Have you tried http://localhost:81/Reports, since that's what you changed
> > the port to?
> >
> > Clint
> >
> > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > >laptop
> > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > message:
> > > "A connection could not be made with report server at
> > > http://localhost/ReportServer"
> > >
> > > Everything is running (green checks) in the Reporting Services
> > > configuration
> > > manager. We get the error, "Page not found." when we just try to open
> > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > virtual
> > > directories in IIS, all services seem to be running correctly.
> > >
> > > Please help! I have installed reporting services about 10 times and have
> > > not run into this problem before. The only issue that we had initially
> > > was
> > > that the IIS default web site would not run because there was a conflict
> > > on
> > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > problem should it.
> > >
> > > Thank you,
> > > Laurie
> > > --
> > > LaurieT
> >
> >
> >|||Sharan,
Thanks for the valuable solution. That was very helpful, precisely to
the point and it solved the issue.
Good Work!
Shailesh
HELP wrote:
> laurie,
> I had the same problem and Now it has been fixed.i looked online and
> here is what i found:
> 1)The FIX
> For IIS MMC: Right click My Computer...then click manage...under
> services and applications....expand IIS
> then right click the "reports" virtual directory, select property and
> then under the
> ASP.NET tab select asp.net version that belongs to the .NET framework
> version 2.something. For some reason, after you installed reporting
> services,
> the version of the ASP.NET was removed from the asp.net tab. click ok
> 2)New Problem
> Then you get this new problem when you go to http://localhost/Reports/
> --my comment Failed to access IIS metabase.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
> Exception Details: System.Web.Hosting.HostingEnvironmentException:
> Failed to access IIS metabase.
> The process account used to run ASP.NET must have read access to the
> IIS metabase (e.g. IIS://servername/W3SVC). For information on
> modifying metabase permissions, please see
> http://support.microsoft.com/?kbid=267904 .
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Stack Trace:
> [HostingEnvironmentException: Failed to access IIS metabase.]
> System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
> +3609369 System.Web.CachedPathData.GetPathData(String path) +406
> System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
> (String sectionName, Type type, ResultsIndex index) +134
>
> 2) The FIX
> To correct the problem To repair IIS mappings for ASP.NET, run the
> Aspnet_regiis.exe utlity. To do so, follow these steps:
> Click Start, and then click Run.
> Type cmd, and then click OK.
> At the command prompt, type the following command, and then press
> ENTER:
> "\<Windows folder>\Microsoft.NET\Framework\<Version
> Number>\aspnet_regiis.exe" -i
> NOTE:Replace <Windows folder> with the name of the directory where the
> operating system is installed and replace <Version Number> with the
> .NET Framework version installed on your computer. Or you could do a
> seach for the .exe file and locate the directory
> You can find the above reference at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
> Now try going to http://computername/reports/
> Hope it helps,
> Sharan Doddakashi
>
> LaurieT wrote:
> > Clint -- Thanks, I tried this and still got some errors (although different
> > than I was seeing before).
> >
> > I got this error when trying http://localhost:81/Reports
> >
> > "The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://localhost:81/Reports'. Line 1, Position 2
> >
> > <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.HomePag..."
> >
> > Any ideas?
> >
> > Thank you.
> > --
> > LaurieT
> >
> >
> > "Clint" wrote:
> >
> > > What happens when you try going to http://localhost/?
> > >
> > > Have you tried http://localhost:81/Reports, since that's what you changed
> > > the port to?
> > >
> > > Clint
> > >
> > > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > > >laptop
> > > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > > message:
> > > > "A connection could not be made with report server at
> > > > http://localhost/ReportServer"
> > > >
> > > > Everything is running (green checks) in the Reporting Services
> > > > configuration
> > > > manager. We get the error, "Page not found." when we just try to open
> > > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > > virtual
> > > > directories in IIS, all services seem to be running correctly.
> > > >
> > > > Please help! I have installed reporting services about 10 times and have
> > > > not run into this problem before. The only issue that we had initially
> > > > was
> > > > that the IIS default web site would not run because there was a conflict
> > > > on
> > > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > > problem should it.
> > > >
> > > > Thank you,
> > > > Laurie
> > > > --
> > > > LaurieT
> > >
> > >
> > >
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Sunday, March 25, 2012
A connection could not be made to the report server http://localhost/Reports.
hi all,
i have been trying to Deploy my report and it keeps giving me this
error.
When i go to IIS and browse on reports the Reporting Services page
comes on fine.
And typing http://localhost/Reports renders the Reporting Services
page too. The problem is when i try to deploy, i keep getting this
error.
Please Help!!
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server http://localhost/Reports.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Reports is the portal. ReportServer is reporting services. Try
http://servername/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepali" <dchikkam@.gmail.com> wrote in message
news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
> hi all,
> i have been trying to Deploy my report and it keeps giving me this
> error.
> When i go to IIS and browse on reports the Reporting Services page
> comes on fine.
> And typing http://localhost/Reports renders the Reporting Services
> page too. The problem is when i try to deploy, i keep getting this
> error.
> Please Help!!
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/Reports.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>|||On typing http://localhost/ReportServer,
it renders one of the folders that i had created on the portals.
localhost/ReportServer - /
----
Friday, July 27, 2007 2:01 PM <dir> Practice
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any help is greatly appreciated.
On Jul 27, 3:50 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Reports is the portal. ReportServer is reporting services. Tryhttp://servername/ReportServer
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Deepali" <dchik...@.gmail.com> wrote in message
> news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
>
> > hi all,
> > i have been trying to Deploy my report and it keeps giving me this
> > error.
> > When i go to IIS and browse on reports the Reporting Services page
> > comes on fine.
> > And typinghttp://localhost/Reports renders the Reporting Services
> > page too. The problem is when i try to deploy, i keep getting this
> > error.
> > Please Help!!
> > TITLE: Microsoft Report Designer
> > --
> > A connection could not be made to the report server
> >http://localhost/Reports.
> > --
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > --
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> > --
> > BUTTONS:
> > OK
> > -- Hide quoted text -
> - Show quoted text -|||ok figured it out. the TargetServerURL was pointing to http://localhost/Reports
and changed it to
http://localhost/ReportServer and it started working perfectly.
thanks Bruce .
i have been trying to Deploy my report and it keeps giving me this
error.
When i go to IIS and browse on reports the Reporting Services page
comes on fine.
And typing http://localhost/Reports renders the Reporting Services
page too. The problem is when i try to deploy, i keep getting this
error.
Please Help!!
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server http://localhost/Reports.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Reports is the portal. ReportServer is reporting services. Try
http://servername/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepali" <dchikkam@.gmail.com> wrote in message
news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
> hi all,
> i have been trying to Deploy my report and it keeps giving me this
> error.
> When i go to IIS and browse on reports the Reporting Services page
> comes on fine.
> And typing http://localhost/Reports renders the Reporting Services
> page too. The problem is when i try to deploy, i keep getting this
> error.
> Please Help!!
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/Reports.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>|||On typing http://localhost/ReportServer,
it renders one of the folders that i had created on the portals.
localhost/ReportServer - /
----
Friday, July 27, 2007 2:01 PM <dir> Practice
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any help is greatly appreciated.
On Jul 27, 3:50 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Reports is the portal. ReportServer is reporting services. Tryhttp://servername/ReportServer
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Deepali" <dchik...@.gmail.com> wrote in message
> news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
>
> > hi all,
> > i have been trying to Deploy my report and it keeps giving me this
> > error.
> > When i go to IIS and browse on reports the Reporting Services page
> > comes on fine.
> > And typinghttp://localhost/Reports renders the Reporting Services
> > page too. The problem is when i try to deploy, i keep getting this
> > error.
> > Please Help!!
> > TITLE: Microsoft Report Designer
> > --
> > A connection could not be made to the report server
> >http://localhost/Reports.
> > --
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > --
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> > --
> > BUTTONS:
> > OK
> > -- Hide quoted text -
> - Show quoted text -|||ok figured it out. the TargetServerURL was pointing to http://localhost/Reports
and changed it to
http://localhost/ReportServer and it started working perfectly.
thanks Bruce .
Thursday, March 22, 2012
A connection could not be made to report server
Hi,
:Every time I try to Deploy report I get this error
A connection could not be made to report server
http:// localhost/reports/pages/folder.aspx
I have already tried:
1. Define my user
2. I can see the report manager from the browser
3. change to asp.net 2
4. find out that the IIS user is not anonymous
!Please help me , I am trying to solve this problem for weeks
Thank you
AviIn the VS 2005 Report Project properties dialog what's the value for the
TargetServerURL property?
http://localhost/ReportServer?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> Hi,
> :Every time I try to Deploy report I get this error
> A connection could not be made to report server
> http:// localhost/reports/pages/folder.aspx
> I have already tried:
> 1. Define my user
> 2. I can see the report manager from the browser
> 3. change to asp.net 2
> 4. find out that the IIS user is not anonymous
> !Please help me , I am trying to solve this problem for weeks
> Thank you
> Avi
>|||:the TargetServerURL property is
http:// localhost/reports/pages/folder.aspx
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> In the VS 2005 Report Project properties dialog what's the value for the
> TargetServerURL property?
> http://localhost/ReportServer?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > Hi,
> > :Every time I try to Deploy report I get this error
> >
> > A connection could not be made to report server
> > http:// localhost/reports/pages/folder.aspx
> >
> > I have already tried:
> > 1. Define my user
> > 2. I can see the report manager from the browser
> > 3. change to asp.net 2
> > 4. find out that the IIS user is not anonymous
> >
> > !Please help me , I am trying to solve this problem for weeks
> >
> > Thank you
> >
> > Avi
> >|||Try:
http:// localhost/reportserver
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160684262.288244.239240@.i42g2000cwa.googlegroups.com...
:the TargetServerURL property is
http:// localhost/reports/pages/folder.aspx
Steve MunLeeuw ?:
> In the VS 2005 Report Project properties dialog what's the value for the
> TargetServerURL property?
> http://localhost/ReportServer?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > Hi,
> > :Every time I try to Deploy report I get this error
> >
> > A connection could not be made to report server
> > http:// localhost/reports/pages/folder.aspx
> >
> > I have already tried:
> > 1. Define my user
> > 2. I can see the report manager from the browser
> > 3. change to asp.net 2
> > 4. find out that the IIS user is not anonymous
> >
> > !Please help me , I am trying to solve this problem for weeks
> >
> > Thank you
> >
> > Avi
> >|||!Thank you
.It was the problem.
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> Try:
> http:// localhost/reportserver
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160684262.288244.239240@.i42g2000cwa.googlegroups.com...
> :the TargetServerURL property is
> http:// localhost/reports/pages/folder.aspx
>
> Steve MunLeeuw ?:
> > In the VS 2005 Report Project properties dialog what's the value for the
> > TargetServerURL property?
> > http://localhost/ReportServer?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > > Hi,
> > > :Every time I try to Deploy report I get this error
> > >
> > > A connection could not be made to report server
> > > http:// localhost/reports/pages/folder.aspx
> > >
> > > I have already tried:
> > > 1. Define my user
> > > 2. I can see the report manager from the browser
> > > 3. change to asp.net 2
> > > 4. find out that the IIS user is not anonymous
> > >
> > > !Please help me , I am trying to solve this problem for weeks
> > >
> > > Thank you
> > >
> > > Avi
> > >sql
:Every time I try to Deploy report I get this error
A connection could not be made to report server
http:// localhost/reports/pages/folder.aspx
I have already tried:
1. Define my user
2. I can see the report manager from the browser
3. change to asp.net 2
4. find out that the IIS user is not anonymous
!Please help me , I am trying to solve this problem for weeks
Thank you
AviIn the VS 2005 Report Project properties dialog what's the value for the
TargetServerURL property?
http://localhost/ReportServer?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> Hi,
> :Every time I try to Deploy report I get this error
> A connection could not be made to report server
> http:// localhost/reports/pages/folder.aspx
> I have already tried:
> 1. Define my user
> 2. I can see the report manager from the browser
> 3. change to asp.net 2
> 4. find out that the IIS user is not anonymous
> !Please help me , I am trying to solve this problem for weeks
> Thank you
> Avi
>|||:the TargetServerURL property is
http:// localhost/reports/pages/folder.aspx
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> In the VS 2005 Report Project properties dialog what's the value for the
> TargetServerURL property?
> http://localhost/ReportServer?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > Hi,
> > :Every time I try to Deploy report I get this error
> >
> > A connection could not be made to report server
> > http:// localhost/reports/pages/folder.aspx
> >
> > I have already tried:
> > 1. Define my user
> > 2. I can see the report manager from the browser
> > 3. change to asp.net 2
> > 4. find out that the IIS user is not anonymous
> >
> > !Please help me , I am trying to solve this problem for weeks
> >
> > Thank you
> >
> > Avi
> >|||Try:
http:// localhost/reportserver
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160684262.288244.239240@.i42g2000cwa.googlegroups.com...
:the TargetServerURL property is
http:// localhost/reports/pages/folder.aspx
Steve MunLeeuw ?:
> In the VS 2005 Report Project properties dialog what's the value for the
> TargetServerURL property?
> http://localhost/ReportServer?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > Hi,
> > :Every time I try to Deploy report I get this error
> >
> > A connection could not be made to report server
> > http:// localhost/reports/pages/folder.aspx
> >
> > I have already tried:
> > 1. Define my user
> > 2. I can see the report manager from the browser
> > 3. change to asp.net 2
> > 4. find out that the IIS user is not anonymous
> >
> > !Please help me , I am trying to solve this problem for weeks
> >
> > Thank you
> >
> > Avi
> >|||!Thank you
.It was the problem.
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> Try:
> http:// localhost/reportserver
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160684262.288244.239240@.i42g2000cwa.googlegroups.com...
> :the TargetServerURL property is
> http:// localhost/reports/pages/folder.aspx
>
> Steve MunLeeuw ?:
> > In the VS 2005 Report Project properties dialog what's the value for the
> > TargetServerURL property?
> > http://localhost/ReportServer?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160682021.955195.311490@.h48g2000cwc.googlegroups.com...
> > > Hi,
> > > :Every time I try to Deploy report I get this error
> > >
> > > A connection could not be made to report server
> > > http:// localhost/reports/pages/folder.aspx
> > >
> > > I have already tried:
> > > 1. Define my user
> > > 2. I can see the report manager from the browser
> > > 3. change to asp.net 2
> > > 4. find out that the IIS user is not anonymous
> > >
> > > !Please help me , I am trying to solve this problem for weeks
> > >
> > > Thank you
> > >
> > > Avi
> > >sql
A conceptual question about RS (when is it usefull)
In my department we are trying to benefit from the RS: we create a lot of
reports for the Marketing, and generally supply them through an Excel
spresdsheet:
1. Ad hoc reports with data which won't be updated.
2. Reports connected to views which are updated once they are oppened by the
user (=the Excel spredsheet is oppened).
3. Reports connected to tables which are daily updated (if the view is to
heavy).
In all the three situations, the RS doesn't help us.
I guess this tool is usefull for information departments who want to publish
reports to many subacribers at once
or to subscribers who need a "hard copy" of the report (=to print it)
or for interactive reports in which the user has to choose values (a year or
a customer or a product) and we don't want to write code.
Am I right?
Any comment or suggestion will be wellcome!RS is not excel and Excel is no RS. You have gotten used to Excel for
reporting and that is fine but it seems to me that you are approaching this
specifically from the viewpoint of a spreadsheet. If you look at what RS can
do you will find that you will be designing reports in a whole new way.
You say that RS doesn't help you. If you are already really skilled in Excel
and want to keep doing things the way you are then fine. It seems to me you
have already made your decision.
Some capabilities of RS:
1. You can schedule long running reports to run at a certain time, then the
user will use that snapshot.
2. Lots of caching configurations you can do
3. Drill through. This is huge. Instead of one mega report, put the data
they need and then provide links that pull up additional information in
reports passing the parameters to the report.
I'm not sure why you say RS doesn't help you in the three items you list.
Seems like it does for #3 for sure. Perhaps #2 as well.
As far as interactive reports, you can set defaults so the user doesn't have
to make a decision but can change it if they want to.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Geri Reshef" <GeriR@.Dubek.co.il> wrote in message
news:%23NwTAWI%23EHA.3260@.TK2MSFTNGP14.phx.gbl...
> In my department we are trying to benefit from the RS: we create a lot of
> reports for the Marketing, and generally supply them through an Excel
> spresdsheet:
> 1. Ad hoc reports with data which won't be updated.
> 2. Reports connected to views which are updated once they are oppened by
the
> user (=the Excel spredsheet is oppened).
> 3. Reports connected to tables which are daily updated (if the view is to
> heavy).
> In all the three situations, the RS doesn't help us.
> I guess this tool is usefull for information departments who want to
publish
> reports to many subacribers at once
> or to subscribers who need a "hard copy" of the report (=to print it)
> or for interactive reports in which the user has to choose values (a year
or
> a customer or a product) and we don't want to write code.
> Am I right?
> Any comment or suggestion will be wellcome!
>
reports for the Marketing, and generally supply them through an Excel
spresdsheet:
1. Ad hoc reports with data which won't be updated.
2. Reports connected to views which are updated once they are oppened by the
user (=the Excel spredsheet is oppened).
3. Reports connected to tables which are daily updated (if the view is to
heavy).
In all the three situations, the RS doesn't help us.
I guess this tool is usefull for information departments who want to publish
reports to many subacribers at once
or to subscribers who need a "hard copy" of the report (=to print it)
or for interactive reports in which the user has to choose values (a year or
a customer or a product) and we don't want to write code.
Am I right?
Any comment or suggestion will be wellcome!RS is not excel and Excel is no RS. You have gotten used to Excel for
reporting and that is fine but it seems to me that you are approaching this
specifically from the viewpoint of a spreadsheet. If you look at what RS can
do you will find that you will be designing reports in a whole new way.
You say that RS doesn't help you. If you are already really skilled in Excel
and want to keep doing things the way you are then fine. It seems to me you
have already made your decision.
Some capabilities of RS:
1. You can schedule long running reports to run at a certain time, then the
user will use that snapshot.
2. Lots of caching configurations you can do
3. Drill through. This is huge. Instead of one mega report, put the data
they need and then provide links that pull up additional information in
reports passing the parameters to the report.
I'm not sure why you say RS doesn't help you in the three items you list.
Seems like it does for #3 for sure. Perhaps #2 as well.
As far as interactive reports, you can set defaults so the user doesn't have
to make a decision but can change it if they want to.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Geri Reshef" <GeriR@.Dubek.co.il> wrote in message
news:%23NwTAWI%23EHA.3260@.TK2MSFTNGP14.phx.gbl...
> In my department we are trying to benefit from the RS: we create a lot of
> reports for the Marketing, and generally supply them through an Excel
> spresdsheet:
> 1. Ad hoc reports with data which won't be updated.
> 2. Reports connected to views which are updated once they are oppened by
the
> user (=the Excel spredsheet is oppened).
> 3. Reports connected to tables which are daily updated (if the view is to
> heavy).
> In all the three situations, the RS doesn't help us.
> I guess this tool is usefull for information departments who want to
publish
> reports to many subacribers at once
> or to subscribers who need a "hard copy" of the report (=to print it)
> or for interactive reports in which the user has to choose values (a year
or
> a customer or a product) and we don't want to write code.
> Am I right?
> Any comment or suggestion will be wellcome!
>
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.
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.
a beginners question about linking data
I have just started (yesterday) to use Crystal Reports. I'm almost embarest to ask this question, it may be a simple step or it maybe impossible.
I'm trying to make a report that will show a trend over three months.
My question is, I have a folder named "database", in that folder are 500 folders. Each folder is a workorder that has going through the plant. Can I pull data out of each of these 500 folders into one report? If so could someone point me in the right direction. I can get the data from one of the work order folders but don't know how to get it from all of them.
The database folder contains two .db files, two .px files and one .net file, and the other 500 folders. the work order folders, contains 16 .db files, 16 .px files (there all refre to different processes in the workorder), one .ini file, and one .mb file.
And the database is on my harddrive.
any advise would be apreciated.I'm afraid that you have to develop a small application to read the data from all the folders and save it in a new file and then use crystal reports
By the way, your data is a paradox database|||That's what I was afraid of. Could you tell what kind of application it would be? If I knew what it was, there maybe something in the appliction that we use to collect the data. It already has templates for crystal reports for a single work order, this I found by digging around in application files.
I knew the database was a paradox from reading the help files in crystal, but I don't really know that must (yet) about databases.
Thanks jggtz of the reply.|||Would I need something like MySQL?|||My advice is that you find help close around you from somebody that already know some programming language, like Visual Basic, to help you to develop that small an easy application that collect data from all the desired folders and print the reports
Or
As you said before, maybe there is an "Export" option in the application you use to collect data and that could be helpful if it has the right features
Or
If you want to work a liitle more, you can attach (link) to Access all the neccesary .db files and manually (or by a sql query) append all the data into a single one table to then print the reports
I'm trying to make a report that will show a trend over three months.
My question is, I have a folder named "database", in that folder are 500 folders. Each folder is a workorder that has going through the plant. Can I pull data out of each of these 500 folders into one report? If so could someone point me in the right direction. I can get the data from one of the work order folders but don't know how to get it from all of them.
The database folder contains two .db files, two .px files and one .net file, and the other 500 folders. the work order folders, contains 16 .db files, 16 .px files (there all refre to different processes in the workorder), one .ini file, and one .mb file.
And the database is on my harddrive.
any advise would be apreciated.I'm afraid that you have to develop a small application to read the data from all the folders and save it in a new file and then use crystal reports
By the way, your data is a paradox database|||That's what I was afraid of. Could you tell what kind of application it would be? If I knew what it was, there maybe something in the appliction that we use to collect the data. It already has templates for crystal reports for a single work order, this I found by digging around in application files.
I knew the database was a paradox from reading the help files in crystal, but I don't really know that must (yet) about databases.
Thanks jggtz of the reply.|||Would I need something like MySQL?|||My advice is that you find help close around you from somebody that already know some programming language, like Visual Basic, to help you to develop that small an easy application that collect data from all the desired folders and print the reports
Or
As you said before, maybe there is an "Export" option in the application you use to collect data and that could be helpful if it has the right features
Or
If you want to work a liitle more, you can attach (link) to Access all the neccesary .db files and manually (or by a sql query) append all the data into a single one table to then print the reports
a beginners question about linking data
I have just started (yesterday) to use Crystal Reports. I'm almost embarest to ask this question, it may be a simple step or it maybe impossible.
I'm trying to make a report that will show a trend over three months.
My question is, I have a folder named "database", in that folder are 500 folders. Each folder is a workorder that has going through the plant. Can I pull data out of each of these 500 folders into one report? If so could someone point me in the right direction. I can get the data from one of the work order folders but don't know how to get it from all of them.
The database folder contains two .db files, two .px files and one .net file, and the other 500 folders. the work order folders, contains 16 .db files, 16 .px files (there all refre to different processes in the workorder), one .ini file, and one .mb file.
And the database is on my harddrive.
any advise would be apreciated.I'm afraid that you have to develop a small application to read the data from all the folders and save it in a new file and then use crystal reports
By the way, your data is a paradox database|||That's what I was afraid of. Could you tell what kind of application it would be? If I knew what it was, there maybe something in the appliction that we use to collect the data. It already has templates for crystal reports for a single work order, this I found by digging around in application files.
I knew the database was a paradox from reading the help files in crystal, but I don't really know that must (yet) about databases.
Thanks jggtz of the reply.|||Would I need something like MySQL?|||My advice is that you find help close around you from somebody that already know some programming language, like Visual Basic, to help you to develop that small an easy application that collect data from all the desired folders and print the reports
Or
As you said before, maybe there is an "Export" option in the application you use to collect data and that could be helpful if it has the right features
Or
If you want to work a liitle more, you can attach (link) to Access all the neccesary .db files and manually (or by a sql query) append all the data into a single one table to then print the reports
I'm trying to make a report that will show a trend over three months.
My question is, I have a folder named "database", in that folder are 500 folders. Each folder is a workorder that has going through the plant. Can I pull data out of each of these 500 folders into one report? If so could someone point me in the right direction. I can get the data from one of the work order folders but don't know how to get it from all of them.
The database folder contains two .db files, two .px files and one .net file, and the other 500 folders. the work order folders, contains 16 .db files, 16 .px files (there all refre to different processes in the workorder), one .ini file, and one .mb file.
And the database is on my harddrive.
any advise would be apreciated.I'm afraid that you have to develop a small application to read the data from all the folders and save it in a new file and then use crystal reports
By the way, your data is a paradox database|||That's what I was afraid of. Could you tell what kind of application it would be? If I knew what it was, there maybe something in the appliction that we use to collect the data. It already has templates for crystal reports for a single work order, this I found by digging around in application files.
I knew the database was a paradox from reading the help files in crystal, but I don't really know that must (yet) about databases.
Thanks jggtz of the reply.|||Would I need something like MySQL?|||My advice is that you find help close around you from somebody that already know some programming language, like Visual Basic, to help you to develop that small an easy application that collect data from all the desired folders and print the reports
Or
As you said before, maybe there is an "Export" option in the application you use to collect data and that could be helpful if it has the right features
Or
If you want to work a liitle more, you can attach (link) to Access all the neccesary .db files and manually (or by a sql query) append all the data into a single one table to then print the reports
Sunday, March 11, 2012
8.5x11.0 Landscape reports insert extra page?
I can't seem to get a landscape report to render properly no matter what I try. It always inserts an extra page between each page of data. The report is sized to 10.5 x 7.00. If I remove portions of the report and resize to 8.0x10.5 it prints fine.
Anybody have any ideas on this?Are you talking render on the web page or when you export?
I had this issue with export to PDF or TIFF and I have to
make the page width > 12 to get it to work correctly.
>--Original Message--
>I can't seem to get a landscape report to render properly
no matter what I try. It always inserts an extra page
between each page of data. The report is sized to 10.5 x
7.00. If I remove portions of the report and resize to
8.0x10.5 it prints fine.
>Anybody have any ideas on this?
>.
>
Anybody have any ideas on this?Are you talking render on the web page or when you export?
I had this issue with export to PDF or TIFF and I have to
make the page width > 12 to get it to work correctly.
>--Original Message--
>I can't seem to get a landscape report to render properly
no matter what I try. It always inserts an extra page
between each page of data. The report is sized to 10.5 x
7.00. If I remove portions of the report and resize to
8.0x10.5 it prints fine.
>Anybody have any ideas on this?
>.
>
Tuesday, March 6, 2012
64-bit Reporting Services 2005 single-threading?
We're running on an AMD 8-core Opteron, with Enterprise RS 2005 64-bit.
It seems that when we have multiple users running reports at the same time,
the mdx queries get executed in parallel to the AS database, but the
processing of the data by reporting services is done in a single-thread mode.
E.g. a report run by itself takes 15 seconds. Same report run by 5 people can
take 3:30 to return (with the w3wp taking up the equivalent of only 1 core).
My laptop running RS 2005 processes these simultaneous report faster than our
Opteron!!!
We played with setting the # of workers on the IIS Appl Pool, and it does
seem to cause multiple reports to be processed simultaneously, but I don't
think this is the best solution. I think we are running the equivalent of 8
copies of reporting services on the box in this configuration -- I see 8 RS
logs being generated.
Is there a setting in either IIS or RS 2005 to make it process requests in
parallel?
SteveHi Steve,
Me too, interested to know the answer to your question. If you find out -
please update.
Thanks,
Al
"SteveIrwin" wrote:
...
> Is there a setting in either IIS or RS 2005 to make it process requests in
> parallel?
> Steve|||It looks like the App Pool that gets created for RS has CPUAffinity assign to
it, I think. When you create another App Pool in IIS, and switch the
Reporting Services vdir to use the new pool, then it behaves like a regular
website -- one worker process that answers all requests that come to it,
spawning multiple threads if necessary.
So it comes down to how you want to have RS to work: do you want one worker
that spawns threads to handle requests, or have multiple workers that will
each take up only one cpu/core for each request, then move on to the next
request. It would be interested to see any whitepapers on this subject.
Steve
"TheTechie" wrote:
> Hi Steve,
> Me too, interested to know the answer to your question. If you find out -
> please update.
> Thanks,
> Al
> "SteveIrwin" wrote:
> ...
> > Is there a setting in either IIS or RS 2005 to make it process requests in
> > parallel?
> >
> > Steve
It seems that when we have multiple users running reports at the same time,
the mdx queries get executed in parallel to the AS database, but the
processing of the data by reporting services is done in a single-thread mode.
E.g. a report run by itself takes 15 seconds. Same report run by 5 people can
take 3:30 to return (with the w3wp taking up the equivalent of only 1 core).
My laptop running RS 2005 processes these simultaneous report faster than our
Opteron!!!
We played with setting the # of workers on the IIS Appl Pool, and it does
seem to cause multiple reports to be processed simultaneously, but I don't
think this is the best solution. I think we are running the equivalent of 8
copies of reporting services on the box in this configuration -- I see 8 RS
logs being generated.
Is there a setting in either IIS or RS 2005 to make it process requests in
parallel?
SteveHi Steve,
Me too, interested to know the answer to your question. If you find out -
please update.
Thanks,
Al
"SteveIrwin" wrote:
...
> Is there a setting in either IIS or RS 2005 to make it process requests in
> parallel?
> Steve|||It looks like the App Pool that gets created for RS has CPUAffinity assign to
it, I think. When you create another App Pool in IIS, and switch the
Reporting Services vdir to use the new pool, then it behaves like a regular
website -- one worker process that answers all requests that come to it,
spawning multiple threads if necessary.
So it comes down to how you want to have RS to work: do you want one worker
that spawns threads to handle requests, or have multiple workers that will
each take up only one cpu/core for each request, then move on to the next
request. It would be interested to see any whitepapers on this subject.
Steve
"TheTechie" wrote:
> Hi Steve,
> Me too, interested to know the answer to your question. If you find out -
> please update.
> Thanks,
> Al
> "SteveIrwin" wrote:
> ...
> > Is there a setting in either IIS or RS 2005 to make it process requests in
> > parallel?
> >
> > Steve
Monday, February 13, 2012
405 Error when passing parameters to reports - IIS and Reporting Services
When trying to use a report that requests parameters, while in Visual
Studio everything works fine. I can preview the report and select a
parameter, click view report and the report works. When I deploy the
report to the server and test on the web site, after I select the
parameter from the drop down and click the View Report button I get an
error in the selection criteria fram that says...
(Clip)
The page cannot be displayed
The page you are looking for cannot be displayed because the page
address is incorrect.
----
Please try the following:
If you typed the page address in the Address bar, check that it is
entered correctly.
Open the finreports.mc.vanderbilt.edu home page and then look for
links to the information you want.
HTTP 405 - Resource not allowed
Internet Information Services
----
Technical Information (for support personnel)
More information:
Microsoft Support
(/Clip)
The Report page itself stays blank. When checking the IIS logs, I
see..
(Clip)
443 POST /ReportServer
%2fDepartment+of+Finance+Reports%2fDNFB+Test+Data 405 1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
(/Clip)
It's giving a 405 error on the post to the ReportServer path. This
report, and other reports, work perfectly when used without any
parameters, it's only giving this error when I add parameters for the
user to select.
Does anyone have any ideas? I'm sure it's something I've overlooked,
but I've been gazing at this so long just trying to get Report Server
working in an SSL and Domain locked environment that I'm cross-eyed.
I need an outside view and opinion.
Thanks for any help anyone can give.
TnNytehawkFound the fix to this a couple of hours after I posted, but Google
Groups didn't have my message up until much later so I couldn't reply
to it.
The fix was to add to the ReportServer Virtual Directory Application
Configuration Extension Mapping
Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
Extension: *
Verbs: All Verbs
Script Engine: Checked
Once I added this, everything works like a charm.|||Hello. I have the same problem! Could you write some additional informations
how to solve this problem?
Regards
â'TnNytehawkâ' pisze:
> Found the fix to this a couple of hours after I posted, but Google
> Groups didn't have my message up until much later so I couldn't reply
> to it.
> The fix was to add to the ReportServer Virtual Directory Application
> Configuration Extension Mapping
> Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
> Extension: *
> Verbs: All Verbs
> Script Engine: Checked
> Once I added this, everything works like a charm.
>
Studio everything works fine. I can preview the report and select a
parameter, click view report and the report works. When I deploy the
report to the server and test on the web site, after I select the
parameter from the drop down and click the View Report button I get an
error in the selection criteria fram that says...
(Clip)
The page cannot be displayed
The page you are looking for cannot be displayed because the page
address is incorrect.
----
Please try the following:
If you typed the page address in the Address bar, check that it is
entered correctly.
Open the finreports.mc.vanderbilt.edu home page and then look for
links to the information you want.
HTTP 405 - Resource not allowed
Internet Information Services
----
Technical Information (for support personnel)
More information:
Microsoft Support
(/Clip)
The Report page itself stays blank. When checking the IIS logs, I
see..
(Clip)
443 POST /ReportServer
%2fDepartment+of+Finance+Reports%2fDNFB+Test+Data 405 1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
(/Clip)
It's giving a 405 error on the post to the ReportServer path. This
report, and other reports, work perfectly when used without any
parameters, it's only giving this error when I add parameters for the
user to select.
Does anyone have any ideas? I'm sure it's something I've overlooked,
but I've been gazing at this so long just trying to get Report Server
working in an SSL and Domain locked environment that I'm cross-eyed.
I need an outside view and opinion.
Thanks for any help anyone can give.
TnNytehawkFound the fix to this a couple of hours after I posted, but Google
Groups didn't have my message up until much later so I couldn't reply
to it.
The fix was to add to the ReportServer Virtual Directory Application
Configuration Extension Mapping
Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
Extension: *
Verbs: All Verbs
Script Engine: Checked
Once I added this, everything works like a charm.|||Hello. I have the same problem! Could you write some additional informations
how to solve this problem?
Regards
â'TnNytehawkâ' pisze:
> Found the fix to this a couple of hours after I posted, but Google
> Groups didn't have my message up until much later so I couldn't reply
> to it.
> The fix was to add to the ReportServer Virtual Directory Application
> Configuration Extension Mapping
> Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
> Extension: *
> Verbs: All Verbs
> Script Engine: Checked
> Once I added this, everything works like a charm.
>
404 Request failed error
Hi
Iam reposting this as my qs seems to have submerged in a deluge of questions !
I have a .net application that lists all the reports within a specific
folder using RS.children methodand then calls a specific selected report in
Report viewer. My application code and reporting services are in two
different servers however in the same domain. The problem is that when I call
my .NET application it gives me this error on Line 85:
The request failed with HTTP status 404: Not Found.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 404: Not Found.
Source Error:
Line 84: RS.Credentials = System.Net.CredentialCache.DefaultCredentials
Line 85: Dim items As CatalogItem()
Line 86: items = RS.ListChildren("/eCMSDashboard", True)
iam setting the Server.URL property to http://<<Servername>>/ReportServer
Please Help !!
Thanks
PriyaI believe that after line 84 you should have something like this :
rs.Url = http://<<Servername>>/ReportServer
Thereafter line 85 and the rest will follow.
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:228D12EA-CC82-4015-AA6E-5BA7799CBEC3@.microsoft.com...
> Hi
> Iam reposting this as my qs seems to have submerged in a deluge of
> questions !
> I have a .net application that lists all the reports within a specific
> folder using RS.children methodand then calls a specific selected report
> in
> Report viewer. My application code and reporting services are in two
> different servers however in the same domain. The problem is that when I
> call
> my .NET application it gives me this error on Line 85:
> The request failed with HTTP status 404: Not Found.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The request failed with HTTP
> status 404: Not Found.
> Source Error:
> Line 84: RS.Credentials => System.Net.CredentialCache.DefaultCredentials
> Line 85: Dim items As CatalogItem()
> Line 86: items = RS.ListChildren("/eCMSDashboard", True)
> iam setting the Server.URL property to http://<<Servername>>/ReportServer
> Please Help !!
> Thanks
> Priya
>
Iam reposting this as my qs seems to have submerged in a deluge of questions !
I have a .net application that lists all the reports within a specific
folder using RS.children methodand then calls a specific selected report in
Report viewer. My application code and reporting services are in two
different servers however in the same domain. The problem is that when I call
my .NET application it gives me this error on Line 85:
The request failed with HTTP status 404: Not Found.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 404: Not Found.
Source Error:
Line 84: RS.Credentials = System.Net.CredentialCache.DefaultCredentials
Line 85: Dim items As CatalogItem()
Line 86: items = RS.ListChildren("/eCMSDashboard", True)
iam setting the Server.URL property to http://<<Servername>>/ReportServer
Please Help !!
Thanks
PriyaI believe that after line 84 you should have something like this :
rs.Url = http://<<Servername>>/ReportServer
Thereafter line 85 and the rest will follow.
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:228D12EA-CC82-4015-AA6E-5BA7799CBEC3@.microsoft.com...
> Hi
> Iam reposting this as my qs seems to have submerged in a deluge of
> questions !
> I have a .net application that lists all the reports within a specific
> folder using RS.children methodand then calls a specific selected report
> in
> Report viewer. My application code and reporting services are in two
> different servers however in the same domain. The problem is that when I
> call
> my .NET application it gives me this error on Line 85:
> The request failed with HTTP status 404: Not Found.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The request failed with HTTP
> status 404: Not Found.
> Source Error:
> Line 84: RS.Credentials => System.Net.CredentialCache.DefaultCredentials
> Line 85: Dim items As CatalogItem()
> Line 86: items = RS.ListChildren("/eCMSDashboard", True)
> iam setting the Server.URL property to http://<<Servername>>/ReportServer
> Please Help !!
> Thanks
> Priya
>
403 Forbidden Error
Hi,
We have configured the SRS report in IIS 6.0. We are able to see the reports
in the servers but if we click on report we are getting 403 Forbidden error.
Can you please let know the resolution on the same?
ManjunathanOn Dec 7, 8:57 am, Manjunathan <Manjunat...@.discussions.microsoft.com>
wrote:
> Hi,
> We have configured the SRS report in IIS 6.0. We are able to see the reports
> in the servers but if we click on report we are getting 403 Forbidden error.
> Can you please let know the resolution on the same?
> Manjunathan
This link might be helpful.
http://msdn2.microsoft.com/en-us/library/ms159778.aspx
Regards,
Enrique Martinez
Sr. Software Consultant
We have configured the SRS report in IIS 6.0. We are able to see the reports
in the servers but if we click on report we are getting 403 Forbidden error.
Can you please let know the resolution on the same?
ManjunathanOn Dec 7, 8:57 am, Manjunathan <Manjunat...@.discussions.microsoft.com>
wrote:
> Hi,
> We have configured the SRS report in IIS 6.0. We are able to see the reports
> in the servers but if we click on report we are getting 403 Forbidden error.
> Can you please let know the resolution on the same?
> Manjunathan
This link might be helpful.
http://msdn2.microsoft.com/en-us/library/ms159778.aspx
Regards,
Enrique Martinez
Sr. Software Consultant
403 Error
I've been tasked with moving several reports from a pre-production
environment to production. Sounded easy enough for me; except they left out
that the production environment has some SSRS issues. I've been working
through these and have resolved most of them. The remaining one is very
perplexing, and I can't seem to pinpoint the root cause of the error message.
The management console works just fine, and I'm also able to deploy existing
reports to the new server, however, SSRS is not able to render any reports.
I constantly receive a 403 Forbidden error. Both systems are using Windows
Server 2003 and SQL Server 2005, although they are different service pack
versions. I have duplicated all security permissions from the pre-production
box to the production one, to no avail. The Event Viewer has finally logged
an error message, but it's all Greek to me. The error is listed below.
If anyone could provide some insight, I would be very gratefull.
TIA,
Chris
Error Message:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/10/2007 4:45:29 PM
Event time (UTC): 7/10/2007 11:45:29 PM
Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
Event sequence: 191
Event occurrence: 4
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: *****
Process information:
Process ID: 4020
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL:
http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address:
User:
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
isAbortable, String url, Stream outputStream, String& mimeType, String&
fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
styleSheetName)
at
Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context)
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.On Jul 10, 8:14 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> I've been tasked with moving several reports from a pre-production
> environment to production. Sounded easy enough for me; except they left out
> that the production environment has some SSRS issues. I've been working
> through these and have resolved most of them. The remaining one is very
> perplexing, and I can't seem to pinpoint the root cause of the error message.
> The management console works just fine, and I'm also able to deploy existing
> reports to the new server, however, SSRS is not able to render any reports.
> I constantly receive a 403 Forbidden error. Both systems are using Windows
> Server 2003 and SQL Server 2005, although they are different service pack
> versions. I have duplicated all security permissions from the pre-production
> box to the production one, to no avail. The Event Viewer has finally logged
> an error message, but it's all Greek to me. The error is listed below.
> If anyone could provide some insight, I would be very gratefull.
> TIA,
> Chris
> Error Message:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 7/10/2007 4:45:29 PM
> Event time (UTC): 7/10/2007 11:45:29 PM
> Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> Event sequence: 191
> Event occurrence: 4
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> Trust level: RosettaMgr
> Application Virtual Path: /Reports
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportManager\
> Machine name: *****
> Process information:
> Process ID: 4020
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: WebException
> Exception message: The remote server returned an error: (403) Forbidden.
> Request information:
> Request URL:
> http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> Request path: /Reports/Reserved.ReportViewerWebControl.axd
> User host address:
> User:
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> isAbortable, String url, Stream outputStream, String& mimeType, String&
> fileNameExtension)
> at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> styleSheetName)
> at
> Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context)
> at
> System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> Custom event details:
> For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
You may want to recreate the website under a different name/virtual
directory. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Jul 10, 8:14 pm, Christopher Robin
> <ChristopherRo...@.discussions.microsoft.com> wrote:
> > I've been tasked with moving several reports from a pre-production
> > environment to production. Sounded easy enough for me; except they left out
> > that the production environment has some SSRS issues. I've been working
> > through these and have resolved most of them. The remaining one is very
> > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > The management console works just fine, and I'm also able to deploy existing
> > reports to the new server, however, SSRS is not able to render any reports.
> > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > Server 2003 and SQL Server 2005, although they are different service pack
> > versions. I have duplicated all security permissions from the pre-production
> > box to the production one, to no avail. The Event Viewer has finally logged
> > an error message, but it's all Greek to me. The error is listed below.
> >
> > If anyone could provide some insight, I would be very gratefull.
> >
> > TIA,
> > Chris
> >
> > Error Message:
> >
> > Event code: 3005
> > Event message: An unhandled exception has occurred.
> > Event time: 7/10/2007 4:45:29 PM
> > Event time (UTC): 7/10/2007 11:45:29 PM
> > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > Event sequence: 191
> > Event occurrence: 4
> > Event detail code: 0
> >
> > Application information:
> > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > Trust level: RosettaMgr
> > Application Virtual Path: /Reports
> > Application Path: C:\Program Files\Microsoft SQL
> > Server\MSSQL.3\Reporting Services\ReportManager\
> > Machine name: *****
> >
> > Process information:
> > Process ID: 4020
> > Process name: w3wp.exe
> > Account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Exception information:
> > Exception type: WebException
> > Exception message: The remote server returned an error: (403) Forbidden.
> >
> > Request information:
> > Request URL:
> > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > User host address:
> > User:
> > Is authenticated: True
> > Authentication Type: Negotiate
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Thread information:
> > Thread ID: 1
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > Is impersonating: True
> > Stack trace: at
> > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > fileNameExtension)
> > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > styleSheetName)
> > at
> > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > context)
> > at
> > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously)
> >
> > Custom event details:
> >
> > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
>
> You may want to recreate the website under a different name/virtual
> directory. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Hi Enrique,
I don't fully understand, what happened, but your suggestion worked
beautifully. Reporting Services is now showing the report I deployed, and
I'm not the only one that can access it.
Thanks for the help.
Chris|||On Jul 11, 12:52 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> "EMartinez" wrote:
> > On Jul 10, 8:14 pm, Christopher Robin
> > <ChristopherRo...@.discussions.microsoft.com> wrote:
> > > I've been tasked with moving several reports from a pre-production
> > > environment to production. Sounded easy enough for me; except they left out
> > > that the production environment has some SSRS issues. I've been working
> > > through these and have resolved most of them. The remaining one is very
> > > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > > The management console works just fine, and I'm also able to deploy existing
> > > reports to the new server, however, SSRS is not able to render any reports.
> > > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > > Server 2003 and SQL Server 2005, although they are different service pack
> > > versions. I have duplicated all security permissions from the pre-production
> > > box to the production one, to no avail. The Event Viewer has finally logged
> > > an error message, but it's all Greek to me. The error is listed below.
> > > If anyone could provide some insight, I would be very gratefull.
> > > TIA,
> > > Chris
> > > Error Message:
> > > Event code: 3005
> > > Event message: An unhandled exception has occurred.
> > > Event time: 7/10/2007 4:45:29 PM
> > > Event time (UTC): 7/10/2007 11:45:29 PM
> > > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > > Event sequence: 191
> > > Event occurrence: 4
> > > Event detail code: 0
> > > Application information:
> > > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > > Trust level: RosettaMgr
> > > Application Virtual Path: /Reports
> > > Application Path: C:\Program Files\Microsoft SQL
> > > Server\MSSQL.3\Reporting Services\ReportManager\
> > > Machine name: *****
> > > Process information:
> > > Process ID: 4020
> > > Process name: w3wp.exe
> > > Account name: NT AUTHORITY\NETWORK SERVICE
> > > Exception information:
> > > Exception type: WebException
> > > Exception message: The remote server returned an error: (403) Forbidden.
> > > Request information:
> > > Request URL:
> > > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > > User host address:
> > > User:
> > > Is authenticated: True
> > > Authentication Type: Negotiate
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Thread information:
> > > Thread ID: 1
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Is impersonating: True
> > > Stack trace: at
> > > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > > fileNameExtension)
> > > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > > styleSheetName)
> > > at
> > > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > > context)
> > > at
> > > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > > completedSynchronously)
> > > Custom event details:
> > > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
> > You may want to recreate the website under a different name/virtual
> > directory. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Hi Enrique,
> I don't fully understand, what happened, but your suggestion worked
> beautifully. Reporting Services is now showing the report I deployed, and
> I'm not the only one that can access it.
> Thanks for the help.
> Chris
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
environment to production. Sounded easy enough for me; except they left out
that the production environment has some SSRS issues. I've been working
through these and have resolved most of them. The remaining one is very
perplexing, and I can't seem to pinpoint the root cause of the error message.
The management console works just fine, and I'm also able to deploy existing
reports to the new server, however, SSRS is not able to render any reports.
I constantly receive a 403 Forbidden error. Both systems are using Windows
Server 2003 and SQL Server 2005, although they are different service pack
versions. I have duplicated all security permissions from the pre-production
box to the production one, to no avail. The Event Viewer has finally logged
an error message, but it's all Greek to me. The error is listed below.
If anyone could provide some insight, I would be very gratefull.
TIA,
Chris
Error Message:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/10/2007 4:45:29 PM
Event time (UTC): 7/10/2007 11:45:29 PM
Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
Event sequence: 191
Event occurrence: 4
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: *****
Process information:
Process ID: 4020
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL:
http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address:
User:
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
isAbortable, String url, Stream outputStream, String& mimeType, String&
fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
styleSheetName)
at
Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context)
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.On Jul 10, 8:14 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> I've been tasked with moving several reports from a pre-production
> environment to production. Sounded easy enough for me; except they left out
> that the production environment has some SSRS issues. I've been working
> through these and have resolved most of them. The remaining one is very
> perplexing, and I can't seem to pinpoint the root cause of the error message.
> The management console works just fine, and I'm also able to deploy existing
> reports to the new server, however, SSRS is not able to render any reports.
> I constantly receive a 403 Forbidden error. Both systems are using Windows
> Server 2003 and SQL Server 2005, although they are different service pack
> versions. I have duplicated all security permissions from the pre-production
> box to the production one, to no avail. The Event Viewer has finally logged
> an error message, but it's all Greek to me. The error is listed below.
> If anyone could provide some insight, I would be very gratefull.
> TIA,
> Chris
> Error Message:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 7/10/2007 4:45:29 PM
> Event time (UTC): 7/10/2007 11:45:29 PM
> Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> Event sequence: 191
> Event occurrence: 4
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> Trust level: RosettaMgr
> Application Virtual Path: /Reports
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportManager\
> Machine name: *****
> Process information:
> Process ID: 4020
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: WebException
> Exception message: The remote server returned an error: (403) Forbidden.
> Request information:
> Request URL:
> http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> Request path: /Reports/Reserved.ReportViewerWebControl.axd
> User host address:
> User:
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> isAbortable, String url, Stream outputStream, String& mimeType, String&
> fileNameExtension)
> at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> styleSheetName)
> at
> Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context)
> at
> System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> Custom event details:
> For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
You may want to recreate the website under a different name/virtual
directory. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Jul 10, 8:14 pm, Christopher Robin
> <ChristopherRo...@.discussions.microsoft.com> wrote:
> > I've been tasked with moving several reports from a pre-production
> > environment to production. Sounded easy enough for me; except they left out
> > that the production environment has some SSRS issues. I've been working
> > through these and have resolved most of them. The remaining one is very
> > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > The management console works just fine, and I'm also able to deploy existing
> > reports to the new server, however, SSRS is not able to render any reports.
> > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > Server 2003 and SQL Server 2005, although they are different service pack
> > versions. I have duplicated all security permissions from the pre-production
> > box to the production one, to no avail. The Event Viewer has finally logged
> > an error message, but it's all Greek to me. The error is listed below.
> >
> > If anyone could provide some insight, I would be very gratefull.
> >
> > TIA,
> > Chris
> >
> > Error Message:
> >
> > Event code: 3005
> > Event message: An unhandled exception has occurred.
> > Event time: 7/10/2007 4:45:29 PM
> > Event time (UTC): 7/10/2007 11:45:29 PM
> > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > Event sequence: 191
> > Event occurrence: 4
> > Event detail code: 0
> >
> > Application information:
> > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > Trust level: RosettaMgr
> > Application Virtual Path: /Reports
> > Application Path: C:\Program Files\Microsoft SQL
> > Server\MSSQL.3\Reporting Services\ReportManager\
> > Machine name: *****
> >
> > Process information:
> > Process ID: 4020
> > Process name: w3wp.exe
> > Account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Exception information:
> > Exception type: WebException
> > Exception message: The remote server returned an error: (403) Forbidden.
> >
> > Request information:
> > Request URL:
> > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > User host address:
> > User:
> > Is authenticated: True
> > Authentication Type: Negotiate
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Thread information:
> > Thread ID: 1
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > Is impersonating: True
> > Stack trace: at
> > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > fileNameExtension)
> > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > styleSheetName)
> > at
> > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > context)
> > at
> > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously)
> >
> > Custom event details:
> >
> > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
>
> You may want to recreate the website under a different name/virtual
> directory. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Hi Enrique,
I don't fully understand, what happened, but your suggestion worked
beautifully. Reporting Services is now showing the report I deployed, and
I'm not the only one that can access it.
Thanks for the help.
Chris|||On Jul 11, 12:52 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> "EMartinez" wrote:
> > On Jul 10, 8:14 pm, Christopher Robin
> > <ChristopherRo...@.discussions.microsoft.com> wrote:
> > > I've been tasked with moving several reports from a pre-production
> > > environment to production. Sounded easy enough for me; except they left out
> > > that the production environment has some SSRS issues. I've been working
> > > through these and have resolved most of them. The remaining one is very
> > > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > > The management console works just fine, and I'm also able to deploy existing
> > > reports to the new server, however, SSRS is not able to render any reports.
> > > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > > Server 2003 and SQL Server 2005, although they are different service pack
> > > versions. I have duplicated all security permissions from the pre-production
> > > box to the production one, to no avail. The Event Viewer has finally logged
> > > an error message, but it's all Greek to me. The error is listed below.
> > > If anyone could provide some insight, I would be very gratefull.
> > > TIA,
> > > Chris
> > > Error Message:
> > > Event code: 3005
> > > Event message: An unhandled exception has occurred.
> > > Event time: 7/10/2007 4:45:29 PM
> > > Event time (UTC): 7/10/2007 11:45:29 PM
> > > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > > Event sequence: 191
> > > Event occurrence: 4
> > > Event detail code: 0
> > > Application information:
> > > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > > Trust level: RosettaMgr
> > > Application Virtual Path: /Reports
> > > Application Path: C:\Program Files\Microsoft SQL
> > > Server\MSSQL.3\Reporting Services\ReportManager\
> > > Machine name: *****
> > > Process information:
> > > Process ID: 4020
> > > Process name: w3wp.exe
> > > Account name: NT AUTHORITY\NETWORK SERVICE
> > > Exception information:
> > > Exception type: WebException
> > > Exception message: The remote server returned an error: (403) Forbidden.
> > > Request information:
> > > Request URL:
> > > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > > User host address:
> > > User:
> > > Is authenticated: True
> > > Authentication Type: Negotiate
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Thread information:
> > > Thread ID: 1
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Is impersonating: True
> > > Stack trace: at
> > > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > > fileNameExtension)
> > > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > > styleSheetName)
> > > at
> > > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > > context)
> > > at
> > > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > > completedSynchronously)
> > > Custom event details:
> > > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
> > You may want to recreate the website under a different name/virtual
> > directory. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Hi Enrique,
> I don't fully understand, what happened, but your suggestion worked
> beautifully. Reporting Services is now showing the report I deployed, and
> I'm not the only one that can access it.
> Thanks for the help.
> Chris
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
401.3 Error on Reports folder
Hi,
I have created a test setup of SQL 2000 Report Services on my laptop. I can
access the report server link and run the reports fine. The OS is Win2003 SP1
(I have done the KB 896861 workaround too).
In IIS, when I browse to the Reports folder, I get the error -
Error message 401.3: You do not have permission to view this directory or
page using the credentials you supplied (access denied due to ACLs). Ask the
Web server's administrator to give you access to 'C:\Inetpub\SQL Reporting
Services\ReportManager'.
I get the same error whether the authentication method is anonymous or
Integrated.
If I try to browse on home.aspx page under reports folder, I get no error
and it works.
Can anyone help? Thank you.See if you enabled and set the default content page for this
application directory (Reports) in IIS to Home.aspx
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Tried it. No luck. Still same error.
I have given permissions to all of the users and groups on my system, still
receiving the error.
"Jens" wrote:
> See if you enabled and set the default content page for this
> application directory (Reports) in IIS to Home.aspx
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Is the website running on another Application pool than the Report
Server virual directory ? That probably the cause of it (found that on
the internet)
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||No it is not.
"Jens" wrote:
> Is the website running on another Application pool than the Report
> Server virual directory ? That probably the cause of it (found that on
> the internet)
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
I have created a test setup of SQL 2000 Report Services on my laptop. I can
access the report server link and run the reports fine. The OS is Win2003 SP1
(I have done the KB 896861 workaround too).
In IIS, when I browse to the Reports folder, I get the error -
Error message 401.3: You do not have permission to view this directory or
page using the credentials you supplied (access denied due to ACLs). Ask the
Web server's administrator to give you access to 'C:\Inetpub\SQL Reporting
Services\ReportManager'.
I get the same error whether the authentication method is anonymous or
Integrated.
If I try to browse on home.aspx page under reports folder, I get no error
and it works.
Can anyone help? Thank you.See if you enabled and set the default content page for this
application directory (Reports) in IIS to Home.aspx
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Tried it. No luck. Still same error.
I have given permissions to all of the users and groups on my system, still
receiving the error.
"Jens" wrote:
> See if you enabled and set the default content page for this
> application directory (Reports) in IIS to Home.aspx
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Is the website running on another Application pool than the Report
Server virual directory ? That probably the cause of it (found that on
the internet)
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||No it is not.
"Jens" wrote:
> Is the website running on another Application pool than the Report
> Server virual directory ? That probably the cause of it (found that on
> the internet)
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
401 error?
When I try to access the reports site using
http://myserver/reports
I get the following error
The request failed with HTTP status 401: Unauthorized.
Is there any error happening with respect to web service level' If so how
can I track that service'I am having the same issue. Reporting Services was successfully installed
several months ago and rran beautifully but has gone belly up on a mission
critical application. I am busily RTFMing but if anybody has any bright
ideas I'd be eternally grateful!
"sqlster" wrote:
> When I try to access the reports site using
> http://myserver/reports
> I get the following error
> The request failed with HTTP status 401: Unauthorized.
> Is there any error happening with respect to web service level' If so how
> can I track that service'
>|||dbahawk wrote:
> I am having the same issue. Reporting Services was successfully installed
> several months ago and rran beautifully but has gone belly up on a mission
> critical application. I am busily RTFMing but if anybody has any bright
> ideas I'd be eternally grateful!
> "sqlster" wrote:
>
>>When I try to access the reports site using
>>http://myserver/reports
>>I get the following error
>>The request failed with HTTP status 401: Unauthorized.
>>Is there any error happening with respect to web service level' If so how
>>can I track that service'
looks like you're trying to access IIS anonymously, or anonymous access
allowed at IIS side.
Both will cause this error.|||Thanks for your swift reply!
However, I do have anonymous access turned off for the websites _Reports_
and _ReportServer_
When I try to connect to a previously working report, I get the following
error:
Here is the error and stack trace:
[begin error message]
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with HTTP status 401: Unauthorized.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) +143
coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +744
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
[end of error message]|||I should also add that I am able to log into the site
[domaininfo]/ReportServer and run these manually, so the reporting services
installation does not seem to be the problem. It's getting access to
[domaininfo]\Reports that is the hangup here.
"dbahawk" wrote:
> Thanks for your swift reply!
> However, I do have anonymous access turned off for the websites _Reports_
> and _ReportServer_
>
> When I try to connect to a previously working report, I get the following
> error:
> Here is the error and stack trace:
> [begin error message]
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [WebException: The request failed with HTTP status 401: Unauthorized.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) +143
> coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +744
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
> [end of error message]
>|||I found the references to the DisableLoopbackCheck registry entry and applied
it to our development server. Worked great so I applied it to the production
box where it also worked like a charm.
All is good again :)
"dbahawk" wrote:
> I should also add that I am able to log into the site
> [domaininfo]/ReportServer and run these manually, so the reporting services
> installation does not seem to be the problem. It's getting access to
> [domaininfo]\Reports that is the hangup here.
>
> "dbahawk" wrote:
> > Thanks for your swift reply!
> >
> > However, I do have anonymous access turned off for the websites _Reports_
> > and _ReportServer_
> >
> >
> > When I try to connect to a previously working report, I get the following
> > error:
> >
> > Here is the error and stack trace:
> >
> > [begin error message]
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> >
> > [WebException: The request failed with HTTP status 401: Unauthorized.]
> >
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +218
> > coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) +143
> > coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +744
> >
> >
> > ----
> > Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> > Version:1.1.4322.2300
> >
> > [end of error message]
> >
> >
http://myserver/reports
I get the following error
The request failed with HTTP status 401: Unauthorized.
Is there any error happening with respect to web service level' If so how
can I track that service'I am having the same issue. Reporting Services was successfully installed
several months ago and rran beautifully but has gone belly up on a mission
critical application. I am busily RTFMing but if anybody has any bright
ideas I'd be eternally grateful!
"sqlster" wrote:
> When I try to access the reports site using
> http://myserver/reports
> I get the following error
> The request failed with HTTP status 401: Unauthorized.
> Is there any error happening with respect to web service level' If so how
> can I track that service'
>|||dbahawk wrote:
> I am having the same issue. Reporting Services was successfully installed
> several months ago and rran beautifully but has gone belly up on a mission
> critical application. I am busily RTFMing but if anybody has any bright
> ideas I'd be eternally grateful!
> "sqlster" wrote:
>
>>When I try to access the reports site using
>>http://myserver/reports
>>I get the following error
>>The request failed with HTTP status 401: Unauthorized.
>>Is there any error happening with respect to web service level' If so how
>>can I track that service'
looks like you're trying to access IIS anonymously, or anonymous access
allowed at IIS side.
Both will cause this error.|||Thanks for your swift reply!
However, I do have anonymous access turned off for the websites _Reports_
and _ReportServer_
When I try to connect to a previously working report, I get the following
error:
Here is the error and stack trace:
[begin error message]
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with HTTP status 401: Unauthorized.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) +143
coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +744
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
[end of error message]|||I should also add that I am able to log into the site
[domaininfo]/ReportServer and run these manually, so the reporting services
installation does not seem to be the problem. It's getting access to
[domaininfo]\Reports that is the hangup here.
"dbahawk" wrote:
> Thanks for your swift reply!
> However, I do have anonymous access turned off for the websites _Reports_
> and _ReportServer_
>
> When I try to connect to a previously working report, I get the following
> error:
> Here is the error and stack trace:
> [begin error message]
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [WebException: The request failed with HTTP status 401: Unauthorized.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) +143
> coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +744
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
> [end of error message]
>|||I found the references to the DisableLoopbackCheck registry entry and applied
it to our development server. Worked great so I applied it to the production
box where it also worked like a charm.
All is good again :)
"dbahawk" wrote:
> I should also add that I am able to log into the site
> [domaininfo]/ReportServer and run these manually, so the reporting services
> installation does not seem to be the problem. It's getting access to
> [domaininfo]\Reports that is the hangup here.
>
> "dbahawk" wrote:
> > Thanks for your swift reply!
> >
> > However, I do have anonymous access turned off for the websites _Reports_
> > and _ReportServer_
> >
> >
> > When I try to connect to a previously working report, I get the following
> > error:
> >
> > Here is the error and stack trace:
> >
> > [begin error message]
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> >
> > [WebException: The request failed with HTTP status 401: Unauthorized.]
> >
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +218
> > coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) +143
> > coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +744
> >
> >
> > ----
> > Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> > Version:1.1.4322.2300
> >
> > [end of error message]
> >
> >
400: Bad Request
I am getting an "The request failed with HTTP status 400: Bad Request " Error in Report Manager Webpage. http://servername/Reports
The Reportserver itself and reports works fine (http://servername/reportserver).
Reports render OK and i am still able to connect to reportserver by management studio.
The Reportserver itself and reports works fine (http://servername/reportserver).
Reports render OK and i am still able to connect to reportserver by management studio.
The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller.
Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change.
There are no errors in the eventlog.
I need some help - please
HANNESI have already checked the following posts
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=284929&SiteID=1
(I did not understend the "RSWebApplication.config" file - as soon as i write in the a reportserver url the website returns an execption - so this config must be empty I guess)
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=479636&SiteID=1|||This post gave me the finale hint (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=165851&SiteID=1) - but I do not habe a specific IP address bound to the website - but I had specific hostheaders and it seems the reportmanager needs at least one binding with no hosthader in my environment - therefor I added a fifth binding with no hosthander, no specific IP and default Port
Hannes
4.5 16bit to 9...help!
I am a complete Crystal reports novice and am throwing myself at your mercy...i have a number of reports compiled under Crystal 4.5 16bit years ago by someone who has now left my company. They are compiled reports that run on users machines who don't have Crystal installed..and they have always worked just fine. I now need to get the same reports running under Crystal 9 but the first thing i noticed is that there is no compile report option, i have tried also compiling them under Crystal 7 32 bit but they still do no work. Is there any easy way of getting my 4.5 16bit .rpt's to work under 7 or 9 ?
Help!!I think that saving the report in a later version of Crystal is enough to convert it, but I'm not positive.
Have you updated the users machine to include the version 9 dlls? I know that when I switched from version 6 to version 8.5, I had trouble with a dll called p2smon.dll. Version 6 of p2smon has something in it that my reports utilize that version 8.5 doesn't support. (Like you, the reports I use were created by a person who no longer works at my company).
Here's a link to a thread I've posted about my Crystal problems with backward compatibility. It has links to other threads. Maybe you'll find something useful?
http://www.dev-archive.com/forum/showthread.php?s=&threadid=283044|||Thanks for your prompt reply..i tried various things. One thing i couldn't understand is that In Crystal 7 help one of the runtime files that is meant to be distributed with the report is called crrun32.exe. I can't find a copy of this file anywhere...
Help!!I think that saving the report in a later version of Crystal is enough to convert it, but I'm not positive.
Have you updated the users machine to include the version 9 dlls? I know that when I switched from version 6 to version 8.5, I had trouble with a dll called p2smon.dll. Version 6 of p2smon has something in it that my reports utilize that version 8.5 doesn't support. (Like you, the reports I use were created by a person who no longer works at my company).
Here's a link to a thread I've posted about my Crystal problems with backward compatibility. It has links to other threads. Maybe you'll find something useful?
http://www.dev-archive.com/forum/showthread.php?s=&threadid=283044|||Thanks for your prompt reply..i tried various things. One thing i couldn't understand is that In Crystal 7 help one of the runtime files that is meant to be distributed with the report is called crrun32.exe. I can't find a copy of this file anywhere...
Saturday, February 11, 2012
4 different criteria, Crystal Reports 7
Hi,
I have a report that I need some help with. I have 4 different evaluations and if either set of 2 is true, I want to have them displayed on the resulting report.
This is what I put it, maybe someone can offer some suggestions to help it work right.
{MasterLog.DateOff} = (CurrentDate) And
{MasterLog.TimeOff} < (DateTime(0,0,0,6,30,00))
Or
{MasterLog.DateOff} = Date(Year(CurrentDate), Month(CurrentDate), Day(CurrentDate) - 1) And
{MasterLog.TimeOff} > (DateTime(0,0,0,6,30,00))
This report is looking for any row that is equil to today and the time field is less than 6:30 AM. Or Yesterday's date and that rows time greater than 6:30 AM.
The 2 fields are date/time fields not converted to date in the report options. I formatted them in the report but I dont think that is where the problem is. I believe its in my formula.
If either set of criteria is true, then print that row in the report.
What I get back is all of yesterdays rows but none of todays rows that fit the criteria. I did make sure that there was data to show in the database.
Its a MSaccess 2002 format.
Any suggestions? Further clarifications?
intercepterAnd after spending a couple hours working further, I have my solution.
It appears first off I wasnt formatting correctly for the database fields I was using. Also, I should have enclosed the 2 sets of criteria in ( ) between the or.
So, the resuting formula is:
({MasterLog.DateOff} = Date(Year(CurrentDate), Month(CurrentDate), Day(CurrentDate) - 1) and
{MasterLog.TimeOff} >= DateTime (1899, 12, 30,06, 30, 00)) or
({MasterLog.TimeOff} <= DateTime (1899, 12, 30,06, 30, 00) and
{MasterLog.DateOff} = CurrentDate)
I hope this helps someone else.
intercepter
I have a report that I need some help with. I have 4 different evaluations and if either set of 2 is true, I want to have them displayed on the resulting report.
This is what I put it, maybe someone can offer some suggestions to help it work right.
{MasterLog.DateOff} = (CurrentDate) And
{MasterLog.TimeOff} < (DateTime(0,0,0,6,30,00))
Or
{MasterLog.DateOff} = Date(Year(CurrentDate), Month(CurrentDate), Day(CurrentDate) - 1) And
{MasterLog.TimeOff} > (DateTime(0,0,0,6,30,00))
This report is looking for any row that is equil to today and the time field is less than 6:30 AM. Or Yesterday's date and that rows time greater than 6:30 AM.
The 2 fields are date/time fields not converted to date in the report options. I formatted them in the report but I dont think that is where the problem is. I believe its in my formula.
If either set of criteria is true, then print that row in the report.
What I get back is all of yesterdays rows but none of todays rows that fit the criteria. I did make sure that there was data to show in the database.
Its a MSaccess 2002 format.
Any suggestions? Further clarifications?
intercepterAnd after spending a couple hours working further, I have my solution.
It appears first off I wasnt formatting correctly for the database fields I was using. Also, I should have enclosed the 2 sets of criteria in ( ) between the or.
So, the resuting formula is:
({MasterLog.DateOff} = Date(Year(CurrentDate), Month(CurrentDate), Day(CurrentDate) - 1) and
{MasterLog.TimeOff} >= DateTime (1899, 12, 30,06, 30, 00)) or
({MasterLog.TimeOff} <= DateTime (1899, 12, 30,06, 30, 00) and
{MasterLog.DateOff} = CurrentDate)
I hope this helps someone else.
intercepter
4 days and still can't get my report to depoly (help)...
I have had a great deal of success in the past on other systems with
deploying reports...
BUT now, to save my life, I haven't been able to get the first report
to deploy. I get these
errors:
A connection could not be made to the report server http://###.###.##.###/reportserver.
Additional information:
The attempt to connect to the reoprt server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
I change the TargetServerURL (after remote desktoping to the Report
Server itself) to:
http://GCC/ReportServer or http://localhost/ReportServer and get
another type of error:
A connection could not be made to the report server http://localhost/reportserver
The request failed with HTTP status 404: Bad Request
(System.Web.Service)
I've tried all the configurations I know and granted all permissions
and turned off the firewall.
Any help (especially at this point) is very appreciated.
Thanks,
TrintFirst things first. You need to make sure that you can open up Report
Manager (that is the portal that ships with RS). Sure, there won't be any
reports if none have been deployed but that is fine. It will show you that
everything is setup and working and that you have rights.
It sounds like in your case the easiest thing to do is to first remote
desktop to the server and then do this:
http://localhost/Reports/Pages/Folder.aspx
Do not try anything else until this comes up for you. If you have been
changing permissions in the database or in IIS after installing RS then you
have most likely just messed things up. You should never have to be doing
either one. Everything from a security perspective can be done using Report
Manager.
If IIS has set the two RS websites to anonymous then this will come up but
you will not be able to deploy because with anonymous no-one has rights to
deploy.
RS uses roles. Read up on how roles are used.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>I have had a great deal of success in the past on other systems with
> deploying reports...
> BUT now, to save my life, I haven't been able to get the first report
> to deploy. I get these
> errors:
> A connection could not be made to the report server
> http://###.###.##.###/reportserver.
> Additional information:
> The attempt to connect to the reoprt server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> I change the TargetServerURL (after remote desktoping to the Report
> Server itself) to:
> http://GCC/ReportServer or http://localhost/ReportServer and get
> another type of error:
> A connection could not be made to the report server
> http://localhost/reportserver
> The request failed with HTTP status 404: Bad Request
> (System.Web.Service)
> I've tried all the configurations I know and granted all permissions
> and turned off the firewall.
> Any help (especially at this point) is very appreciated.
> Thanks,
> Trint
>|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> First things first. You need to make sure that you can open up Report
> Manager (that is the portal that ships with RS). Sure, there won't be any
> reports if none have been deployed but that is fine. It will show you that
> everything is setup and working and that you have rights.
> It sounds like in your case the easiest thing to do is to first remote
> desktop to the server and then do this:
> http://localhost/Reports/Pages/Folder.aspx
> Do not try anything else until this comes up for you. If you have been
> changing permissions in the database or in IIS after installing RS then you
> have most likely just messed things up. You should never have to be doing
> either one. Everything from a security perspective can be done using Report
> Manager.
> If IIS has set the two RS websites to anonymous then this will come up but
> you will not be able to deploy because with anonymous no-one has rights to
> deploy.
> RS uses roles. Read up on how roles are used.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>
> >I have had a great deal of success in the past on other systems with
> > deploying reports...
> > BUT now, to save my life, I haven't been able to get the first report
> > to deploy. I get these
> > errors:
> > A connection could not be made to the report server
> > http://###.###.##.###/reportserver.
> > Additional information:
> > The attempt to connect to the reoprt server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > I change the TargetServerURL (after remote desktoping to the Report
> > Server itself) to:
> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
> > another type of error:
> > A connection could not be made to the report server
> >http://localhost/reportserver
> > The request failed with HTTP status 404: Bad Request
> > (System.Web.Service)
> > I've tried all the configurations I know and granted all permissions
> > and turned off the firewall.
> > Any help (especially at this point) is very appreciated.
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I'm going to try this right now! Please stay with me on this
I will be right back with you.
Thanks for your help!
Trint|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> First things first. You need to make sure that you can open up Report
> Manager (that is the portal that ships with RS). Sure, there won't be any
> reports if none have been deployed but that is fine. It will show you that
> everything is setup and working and that you have rights.
> It sounds like in your case the easiest thing to do is to first remote
> desktop to the server and then do this:
> http://localhost/Reports/Pages/Folder.aspx
> Do not try anything else until this comes up for you. If you have been
> changing permissions in the database or in IIS after installing RS then you
> have most likely just messed things up. You should never have to be doing
> either one. Everything from a security perspective can be done using Report
> Manager.
> If IIS has set the two RS websites to anonymous then this will come up but
> you will not be able to deploy because with anonymous no-one has rights to
> deploy.
> RS uses roles. Read up on how roles are used.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>
> >I have had a great deal of success in the past on other systems with
> > deploying reports...
> > BUT now, to save my life, I haven't been able to get the first report
> > to deploy. I get these
> > errors:
> > A connection could not be made to the report server
> > http://###.###.##.###/reportserver.
> > Additional information:
> > The attempt to connect to the reoprt server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > I change the TargetServerURL (after remote desktoping to the Report
> > Server itself) to:
> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
> > another type of error:
> > A connection could not be made to the report server
> >http://localhost/reportserver
> > The request failed with HTTP status 404: Bad Request
> > (System.Web.Service)
> > I've tried all the configurations I know and granted all permissions
> > and turned off the firewall.
> > Any help (especially at this point) is very appreciated.
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
Something is bad...I get the Reporting Services type screen, you know,
it's not the avereage
looking html page with the two lines at the top, a big red X in a red
circle and the message after the lines:
"The request failed with HTTP status 400: Bad Request."
and that's all there is on the page.
I could get that, unless i used the full ip address of the server it's
on, because I would just get the same
message on a regular http page using "localhost" or gcc, which is the
virtual folder.
Thanks for you help!
I sure hope I don't have to drive ALL the way over to Virginia (where
my server is) and reinstall SQL '05
Trint|||Run the program files->Microsoft SQL 2005->Configuration Tools -> reporting
services configuration
Make sure you have no red X's.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> First things first. You need to make sure that you can open up Report
>> Manager (that is the portal that ships with RS). Sure, there won't be any
>> reports if none have been deployed but that is fine. It will show you
>> that
>> everything is setup and working and that you have rights.
>> It sounds like in your case the easiest thing to do is to first remote
>> desktop to the server and then do this:
>> http://localhost/Reports/Pages/Folder.aspx
>> Do not try anything else until this comes up for you. If you have been
>> changing permissions in the database or in IIS after installing RS then
>> you
>> have most likely just messed things up. You should never have to be doing
>> either one. Everything from a security perspective can be done using
>> Report
>> Manager.
>> If IIS has set the two RS websites to anonymous then this will come up
>> but
>> you will not be able to deploy because with anonymous no-one has rights
>> to
>> deploy.
>> RS uses roles. Read up on how roles are used.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>>
>> >I have had a great deal of success in the past on other systems with
>> > deploying reports...
>> > BUT now, to save my life, I haven't been able to get the first report
>> > to deploy. I get these
>> > errors:
>> > A connection could not be made to the report server
>> > http://###.###.##.###/reportserver.
>> > Additional information:
>> > The attempt to connect to the reoprt server failed. Check your
>> > connection information and that the report server is a compatible
>> > version. (Microsoft.ReportingServices.Designer)
>> > I change the TargetServerURL (after remote desktoping to the Report
>> > Server itself) to:
>> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
>> > another type of error:
>> > A connection could not be made to the report server
>> >http://localhost/reportserver
>> > The request failed with HTTP status 404: Bad Request
>> > (System.Web.Service)
>> > I've tried all the configurations I know and granted all permissions
>> > and turned off the firewall.
>> > Any help (especially at this point) is very appreciated.
>> > Thanks,
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> Something is bad...I get the Reporting Services type screen, you know,
> it's not the avereage
> looking html page with the two lines at the top, a big red X in a red
> circle and the message after the lines:
> "The request failed with HTTP status 400: Bad Request."
> and that's all there is on the page.
> I could get that, unless i used the full ip address of the server it's
> on, because I would just get the same
> message on a regular http page using "localhost" or gcc, which is the
> virtual folder.
> Thanks for you help!
> I sure hope I don't have to drive ALL the way over to Virginia (where
> my server is) and reinstall SQL '05
> Trint
>|||On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Run the program files->Microsoft SQL 2005->Configuration Tools -> reporting
> services configuration
> Make sure you have no red X's.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>
> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> First things first. You need to make sure that you can open up Report
> >> Manager (that is the portal that ships with RS). Sure, there won't be any
> >> reports if none have been deployed but that is fine. It will show you
> >> that
> >> everything is setup and working and that you have rights.
> >> It sounds like in your case the easiest thing to do is to first remote
> >> desktop to the server and then do this:
> >>http://localhost/Reports/Pages/Folder.aspx
> >> Do not try anything else until this comes up for you. If you have been
> >> changing permissions in the database or in IIS after installing RS then
> >> you
> >> have most likely just messed things up. You should never have to be doing
> >> either one. Everything from a security perspective can be done using
> >> Report
> >> Manager.
> >> If IIS has set the two RS websites to anonymous then this will come up
> >> but
> >> you will not be able to deploy because with anonymous no-one has rights
> >> to
> >> deploy.
> >> RS uses roles. Read up on how roles are used.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >I have had a great deal of success in the past on other systems with
> >> > deploying reports...
> >> > BUT now, to save my life, I haven't been able to get the first report
> >> > to deploy. I get these
> >> > errors:
> >> > A connection could not be made to the report server
> >> > http://###.###.##.###/reportserver.
> >> > Additional information:
> >> > The attempt to connect to the reoprt server failed. Check your
> >> > connection information and that the report server is a compatible
> >> > version. (Microsoft.ReportingServices.Designer)
> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> > Server itself) to:
> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> > another type of error:
> >> > A connection could not be made to the report server
> >> >http://localhost/reportserver
> >> > The request failed with HTTP status 404: Bad Request
> >> > (System.Web.Service)
> >> > I've tried all the configurations I know and granted all permissions
> >> > and turned off the firewall.
> >> > Any help (especially at this point) is very appreciated.
> >> > Thanks,
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > Something is bad...I get the Reporting Services type screen, you know,
> > it's not the avereage
> > looking html page with the two lines at the top, a big red X in a red
> > circle and the message after the lines:
> > "The request failed with HTTP status 400: Bad Request."
> > and that's all there is on the page.
> > I could get that, unless i used the full ip address of the server it's
> > on, because I would just get the same
> > message on a regular http page using "localhost" or gcc, which is the
> > virtual folder.
> > Thanks for you help!
> > I sure hope I don't have to drive ALL the way over to Virginia (where
> > my server is) and reinstall SQL '05
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I have one red x. It is on "Web Service Identity".
Thanks,
Trint|||That's your problem. Nothing will work without that. Report Manager (the
portal that ships with RS) uses web services. You need to get that Green.
For ASP.Net Service account I have NT Authority\NetworkService
For the application pools I use ReportServer for both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Run the program files->Microsoft SQL 2005->Configuration Tools ->
>> reporting
>> services configuration
>> Make sure you have no red X's.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>>
>> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> First things first. You need to make sure that you can open up Report
>> >> Manager (that is the portal that ships with RS). Sure, there won't be
>> >> any
>> >> reports if none have been deployed but that is fine. It will show you
>> >> that
>> >> everything is setup and working and that you have rights.
>> >> It sounds like in your case the easiest thing to do is to first remote
>> >> desktop to the server and then do this:
>> >>http://localhost/Reports/Pages/Folder.aspx
>> >> Do not try anything else until this comes up for you. If you have been
>> >> changing permissions in the database or in IIS after installing RS
>> >> then
>> >> you
>> >> have most likely just messed things up. You should never have to be
>> >> doing
>> >> either one. Everything from a security perspective can be done using
>> >> Report
>> >> Manager.
>> >> If IIS has set the two RS websites to anonymous then this will come up
>> >> but
>> >> you will not be able to deploy because with anonymous no-one has
>> >> rights
>> >> to
>> >> deploy.
>> >> RS uses roles. Read up on how roles are used.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>> >> >I have had a great deal of success in the past on other systems with
>> >> > deploying reports...
>> >> > BUT now, to save my life, I haven't been able to get the first
>> >> > report
>> >> > to deploy. I get these
>> >> > errors:
>> >> > A connection could not be made to the report server
>> >> > http://###.###.##.###/reportserver.
>> >> > Additional information:
>> >> > The attempt to connect to the reoprt server failed. Check your
>> >> > connection information and that the report server is a compatible
>> >> > version. (Microsoft.ReportingServices.Designer)
>> >> > I change the TargetServerURL (after remote desktoping to the Report
>> >> > Server itself) to:
>> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
>> >> > another type of error:
>> >> > A connection could not be made to the report server
>> >> >http://localhost/reportserver
>> >> > The request failed with HTTP status 404: Bad Request
>> >> > (System.Web.Service)
>> >> > I've tried all the configurations I know and granted all permissions
>> >> > and turned off the firewall.
>> >> > Any help (especially at this point) is very appreciated.
>> >> > Thanks,
>> >> >Trint- Hide quoted text -
>> >> - Show quoted text -
>> > Bruce,
>> > Something is bad...I get the Reporting Services type screen, you know,
>> > it's not the avereage
>> > looking html page with the two lines at the top, a big red X in a red
>> > circle and the message after the lines:
>> > "The request failed with HTTP status 400: Bad Request."
>> > and that's all there is on the page.
>> > I could get that, unless i used the full ip address of the server it's
>> > on, because I would just get the same
>> > message on a regular http page using "localhost" or gcc, which is the
>> > virtual folder.
>> > Thanks for you help!
>> > I sure hope I don't have to drive ALL the way over to Virginia (where
>> > my server is) and reinstall SQL '05
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I have one red x. It is on "Web Service Identity".
> Thanks,
> Trint
>|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> That's your problem. Nothing will work without that. Report Manager (the
> portal that ships with RS) uses web services. You need to get that Green.
> For ASP.Net Service account I have NT Authority\NetworkService
> For the application pools I use ReportServer for both.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> reporting
> >> services configuration
> >> Make sure you have no red X's.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> First things first. You need to make sure that you can open up Report
> >> >> Manager (that is the portal that ships with RS). Sure, there won't be
> >> >> any
> >> >> reports if none have been deployed but that is fine. It will show you
> >> >> that
> >> >> everything is setup and working and that you have rights.
> >> >> It sounds like in your case the easiest thing to do is to first remote
> >> >> desktop to the server and then do this:
> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> Do not try anything else until this comes up for you. If you have been
> >> >> changing permissions in the database or in IIS after installing RS
> >> >> then
> >> >> you
> >> >> have most likely just messed things up. You should never have to be
> >> >> doing
> >> >> either one. Everything from a security perspective can be done using
> >> >> Report
> >> >> Manager.
> >> >> If IIS has set the two RS websites to anonymous then this will come up
> >> >> but
> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> rights
> >> >> to
> >> >> deploy.
> >> >> RS uses roles. Read up on how roles are used.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >I have had a great deal of success in the past on other systems with
> >> >> > deploying reports...
> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> > report
> >> >> > to deploy. I get these
> >> >> > errors:
> >> >> > A connection could not be made to the report server
> >> >> > http://###.###.##.###/reportserver.
> >> >> > Additional information:
> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> > connection information and that the report server is a compatible
> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> >> > Server itself) to:
> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> > another type of error:
> >> >> > A connection could not be made to the report server
> >> >> >http://localhost/reportserver
> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> > (System.Web.Service)
> >> >> > I've tried all the configurations I know and granted all permissions
> >> >> > and turned off the firewall.
> >> >> > Any help (especially at this point) is very appreciated.
> >> >> > Thanks,
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > Something is bad...I get the Reporting Services type screen, you know,
> >> > it's not the avereage
> >> > looking html page with the two lines at the top, a big red X in a red
> >> > circle and the message after the lines:
> >> > "The request failed with HTTP status 400: Bad Request."
> >> > and that's all there is on the page.
> >> > I could get that, unless i used the full ip address of the server it's
> >> > on, because I would just get the same
> >> > message on a regular http page using "localhost" or gcc, which is the
> >> > virtual folder.
> >> > Thanks for you help!
> >> > I sure hope I don't have to drive ALL the way over to Virginia (where
> >> > my server is) and reinstall SQL '05
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I have one red x. It is on "Web Service Identity".
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
What do I do to fix this?
I need your help and am very appreciative.
Thanks,
Trint|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> That's your problem. Nothing will work without that. Report Manager (the
> portal that ships with RS) uses web services. You need to get that Green.
> For ASP.Net Service account I have NT Authority\NetworkService
> For the application pools I use ReportServer for both.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> reporting
> >> services configuration
> >> Make sure you have no red X's.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> First things first. You need to make sure that you can open up Report
> >> >> Manager (that is the portal that ships with RS). Sure, there won't be
> >> >> any
> >> >> reports if none have been deployed but that is fine. It will show you
> >> >> that
> >> >> everything is setup and working and that you have rights.
> >> >> It sounds like in your case the easiest thing to do is to first remote
> >> >> desktop to the server and then do this:
> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> Do not try anything else until this comes up for you. If you have been
> >> >> changing permissions in the database or in IIS after installing RS
> >> >> then
> >> >> you
> >> >> have most likely just messed things up. You should never have to be
> >> >> doing
> >> >> either one. Everything from a security perspective can be done using
> >> >> Report
> >> >> Manager.
> >> >> If IIS has set the two RS websites to anonymous then this will come up
> >> >> but
> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> rights
> >> >> to
> >> >> deploy.
> >> >> RS uses roles. Read up on how roles are used.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >I have had a great deal of success in the past on other systems with
> >> >> > deploying reports...
> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> > report
> >> >> > to deploy. I get these
> >> >> > errors:
> >> >> > A connection could not be made to the report server
> >> >> > http://###.###.##.###/reportserver.
> >> >> > Additional information:
> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> > connection information and that the report server is a compatible
> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> >> > Server itself) to:
> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> > another type of error:
> >> >> > A connection could not be made to the report server
> >> >> >http://localhost/reportserver
> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> > (System.Web.Service)
> >> >> > I've tried all the configurations I know and granted all permissions
> >> >> > and turned off the firewall.
> >> >> > Any help (especially at this point) is very appreciated.
> >> >> > Thanks,
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > Something is bad...I get the Reporting Services type screen, you know,
> >> > it's not the avereage
> >> > looking html page with the two lines at the top, a big red X in a red
> >> > circle and the message after the lines:
> >> > "The request failed with HTTP status 400: Bad Request."
> >> > and that's all there is on the page.
> >> > I could get that, unless i used the full ip address of the server it's
> >> > on, because I would just get the same
> >> > message on a regular http page using "localhost" or gcc, which is the
> >> > virtual folder.
> >> > Thanks for you help!
> >> > I sure hope I don't have to drive ALL the way over to Virginia (where
> >> > my server is) and reinstall SQL '05
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I have one red x. It is on "Web Service Identity".
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I did as you said and the (more information on this error) gave me
this:
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
directory must first be created before performing this operation.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
applicationPool)
Thanks,
Trint|||Open up IIS Manager and see if you have the two websites: Reports and
ReportServer. If you do not then something went wrong during your install
and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
Services). Make sure that the login you use to the server is a member of the
local administrator group when installing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
> On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> That's your problem. Nothing will work without that. Report Manager (the
>> portal that ships with RS) uses web services. You need to get that Green.
>> For ASP.Net Service account I have NT Authority\NetworkService
>> For the application pools I use ReportServer for both.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>>
>> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
>> >> reporting
>> >> services configuration
>> >> Make sure you have no red X's.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> >> > wrote:
>> >> >> First things first. You need to make sure that you can open up
>> >> >> Report
>> >> >> Manager (that is the portal that ships with RS). Sure, there won't
>> >> >> be
>> >> >> any
>> >> >> reports if none have been deployed but that is fine. It will show
>> >> >> you
>> >> >> that
>> >> >> everything is setup and working and that you have rights.
>> >> >> It sounds like in your case the easiest thing to do is to first
>> >> >> remote
>> >> >> desktop to the server and then do this:
>> >> >>http://localhost/Reports/Pages/Folder.aspx
>> >> >> Do not try anything else until this comes up for you. If you have
>> >> >> been
>> >> >> changing permissions in the database or in IIS after installing RS
>> >> >> then
>> >> >> you
>> >> >> have most likely just messed things up. You should never have to be
>> >> >> doing
>> >> >> either one. Everything from a security perspective can be done
>> >> >> using
>> >> >> Report
>> >> >> Manager.
>> >> >> If IIS has set the two RS websites to anonymous then this will come
>> >> >> up
>> >> >> but
>> >> >> you will not be able to deploy because with anonymous no-one has
>> >> >> rights
>> >> >> to
>> >> >> deploy.
>> >> >> RS uses roles. Read up on how roles are used.
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>> >> >> >I have had a great deal of success in the past on other systems
>> >> >> >with
>> >> >> > deploying reports...
>> >> >> > BUT now, to save my life, I haven't been able to get the first
>> >> >> > report
>> >> >> > to deploy. I get these
>> >> >> > errors:
>> >> >> > A connection could not be made to the report server
>> >> >> > http://###.###.##.###/reportserver.
>> >> >> > Additional information:
>> >> >> > The attempt to connect to the reoprt server failed. Check your
>> >> >> > connection information and that the report server is a compatible
>> >> >> > version. (Microsoft.ReportingServices.Designer)
>> >> >> > I change the TargetServerURL (after remote desktoping to the
>> >> >> > Report
>> >> >> > Server itself) to:
>> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
>> >> >> > another type of error:
>> >> >> > A connection could not be made to the report server
>> >> >> >http://localhost/reportserver
>> >> >> > The request failed with HTTP status 404: Bad Request
>> >> >> > (System.Web.Service)
>> >> >> > I've tried all the configurations I know and granted all
>> >> >> > permissions
>> >> >> > and turned off the firewall.
>> >> >> > Any help (especially at this point) is very appreciated.
>> >> >> > Thanks,
>> >> >> >Trint- Hide quoted text -
>> >> >> - Show quoted text -
>> >> > Bruce,
>> >> > Something is bad...I get the Reporting Services type screen, you
>> >> > know,
>> >> > it's not the avereage
>> >> > looking html page with the two lines at the top, a big red X in a
>> >> > red
>> >> > circle and the message after the lines:
>> >> > "The request failed with HTTP status 400: Bad Request."
>> >> > and that's all there is on the page.
>> >> > I could get that, unless i used the full ip address of the server
>> >> > it's
>> >> > on, because I would just get the same
>> >> > message on a regular http page using "localhost" or gcc, which is
>> >> > the
>> >> > virtual folder.
>> >> > Thanks for you help!
>> >> > I sure hope I don't have to drive ALL the way over to Virginia
>> >> > (where
>> >> > my server is) and reinstall SQL '05
>> >> >Trint- Hide quoted text -
>> >> - Show quoted text -
>> > Bruce,
>> > I have one red x. It is on "Web Service Identity".
>> > Thanks,
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I did as you said and the (more information on this error) gave me
> this:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
> directory must first be created before performing this operation.
>
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
> applicationPool)
> Thanks,
> Trint
>|||On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Open up IIS Manager and see if you have the two websites: Reports and
> ReportServer. If you do not then something went wrong during your install
> and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> Services). Make sure that the login you use to the server is a member of =the
> local administrator group when installing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
>
> > On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> That's your problem. Nothing will work without that. Report Manager (t=he
> >> portal that ships with RS) uses web services. You need to get that Gre=en.
> >> For ASP.Net Service account I have NT Authority\NetworkService
> >> For the application pools I use ReportServer for both.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> >> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> >> reporting
> >> >> services configuration
> >> >> Make sure you have no red X's.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.c=om>
> >> >> > wrote:
> >> >> >> First things first. You need to make sure that you can open up
> >> >> >> Report
> >> >> >> Manager (that is the portal that ships with RS). Sure, there won='t
> >> >> >> be
> >> >> >> any
> >> >> >> reports if none have been deployed but that is fine. It will show
> >> >> >> you
> >> >> >> that
> >> >> >> everything is setup and working and that you have rights.
> >> >> >> It sounds like in your case the easiest thing to do is to first
> >> >> >> remote
> >> >> >> desktop to the server and then do this:
> >> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> >> Do not try anything else until this comes up for you. If you have
> >> >> >> been
> >> >> >> changing permissions in the database or in IIS after installing =RS
> >> >> >> then
> >> >> >> you
> >> >> >> have most likely just messed things up. You should never have to= be
> >> >> >> doing
> >> >> >> either one. Everything from a security perspective can be done
> >> >> >> using
> >> >> >> Report
> >> >> >> Manager.
> >> >> >> If IIS has set the two RS websites to anonymous then this will c=ome
> >> >> >> up
> >> >> >> but
> >> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> >> rights
> >> >> >> to
> >> >> >> deploy.
> >> >> >> RS uses roles. Read up on how roles are used.
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >> >I have had a great deal of success in the past on other systems
> >> >> >> >with
> >> >> >> > deploying reports...
> >> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> >> > report
> >> >> >> > to deploy. I get these
> >> >> >> > errors:
> >> >> >> > A connection could not be made to the report server
> >> >> >> > http://###.###.##.###/reportserver.
> >> >> >> > Additional information:
> >> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> >> > connection information and that the report server is a compati=ble
> >> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> >> > I change the TargetServerURL (after remote desktoping to the
> >> >> >> > Report
> >> >> >> > Server itself) to:
> >> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> >> > another type of error:
> >> >> >> > A connection could not be made to the report server
> >> >> >> >http://localhost/reportserver
> >> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> >> > (System.Web.Service)
> >> >> >> > I've tried all the configurations I know and granted all
> >> >> >> > permissions
> >> >> >> > and turned off the firewall.
> >> >> >> > Any help (especially at this point) is very appreciated.
> >> >> >> > Thanks,
> >> >> >> >Trint- Hide quoted text -
> >> >> >> - Show quoted text -
> >> >> > Bruce,
> >> >> > Something is bad...I get the Reporting Services type screen, you
> >> >> > know,
> >> >> > it's not the avereage
> >> >> > looking html page with the two lines at the top, a big red X in a
> >> >> > red
> >> >> > circle and the message after the lines:
> >> >> > "The request failed with HTTP status 400: Bad Request."
> >> >> > and that's all there is on the page.
> >> >> > I could get that, unless i used the full ip address of the server
> >> >> > it's
> >> >> > on, because I would just get the same
> >> >> > message on a regular http page using "localhost" or gcc, which is
> >> >> > the
> >> >> > virtual folder.
> >> >> > Thanks for you help!
> >> >> > I sure hope I don't have to drive ALL the way over to Virginia
> >> >> > (where
> >> >> > my server is) and reinstall SQL '05
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > I have one red x. It is on "Web Service Identity".
> >> > Thanks,
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I did as you said and the (more information on this error) gave me
> > this:
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
> > directory must first be created before performing this operation.
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIde=ntit=ADy(String
> > applicationPool)
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
Both of those virtual directories exist.
Reports, ReportServer and Reporting Services. They are all under
Default Website.
Thanks,
Trint|||Trint, you should only have two websites. Did you install more than once?
The only suggestion I have on cleaning this up is to Uninstall RS. Then
re-install it. Something is definitely wrong with your setup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Open up IIS Manager and see if you have the two websites: Reports and
> ReportServer. If you do not then something went wrong during your install
> and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> Services). Make sure that the login you use to the server is a member of
> the
> local administrator group when installing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
Snip
Bruce,
Both of those virtual directories exist.
Reports, ReportServer and Reporting Services. They are all under
Default Website.
Thanks,
Trint|||On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Trint, you should only have two websites. Did you install more than once?
> The only suggestion I have on cleaning this up is to Uninstall RS. Then
> re-install it. Something is definitely wrong with your setup.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:> Open up IIS Manager and see if you have the two websites: Reports and
> > ReportServer. If you do not then something went wrong during your install
> > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> > Services). Make sure that the login you use to the server is a member of
> > the
> > local administrator group when installing.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> Snip
> Bruce,
> Both of those virtual directories exist.
> Reports, ReportServer and Reporting Services. They are all under
> Default Website.
> Thanks,Trint
I think you are right...Seems like I remember having a problem on the
first install.
Do I delete one of them?
Thanks,
Trint|||On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> >Trint, you should only have two websites. Did you install more than once?
> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> > re-install it. Something is definitely wrong with your setup.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:> Open up IIS Manager and see if you have the two websites: Reports and
> > > ReportServer. If you do not then something went wrong during your install
> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> > > Services). Make sure that the login you use to the server is a member of
> > > the
> > > local administrator group when installing.
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > Snip
> > Bruce,
> > Both of those virtual directories exist.
> > Reports, ReportServer and Reporting Services. They are all under
> > Default Website.
> > Thanks,Trint
> I think you are right...Seems like I remember having a problem on the
> first install.
> Do I delete one of them?
> Thanks,Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I see why I tried installing it twice...
When I click on the "Reporting Services" virtual directory, I see all
the
needed virtual folders except "Reports".
Could I just try to delete the Reporting Services virtual directory
and see
if that fixes it and leave the ones alone that are directly under
default websites?
Thanks,
Trint|||I don't know if the reporting services configuration tool will allow you to
pick the correct virtual directory or not. See if it allows you to pick. If
it is just showing it and not allowing you to pick then it is reading
registry values or database values from somewhere and an unistall reinstall
would be best. If you unistall then if the websites are still around you
should manually delete them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
>> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> wrote:
>>
>>
>> >Trint, you should only have two websites. Did you install more than
>> >once?
>> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
>> > re-install it. Something is definitely wrong with your setup.
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> > "trint" <trinity.sm...@.gmail.com> wrote in message
>> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
>> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:> Open up IIS Manager and see if you have the two websites:
>> > Reports and
>> > > ReportServer. If you do not then something went wrong during your
>> > > install
>> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
>> > > Reporting
>> > > Services). Make sure that the login you use to the server is a member
>> > > of
>> > > the
>> > > local administrator group when installing.
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > Snip
>> > Bruce,
>> > Both of those virtual directories exist.
>> > Reports, ReportServer and Reporting Services. They are all under
>> > Default Website.
>> > Thanks,Trint
>> I think you are right...Seems like I remember having a problem on the
>> first install.
>> Do I delete one of them?
>> Thanks,Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I see why I tried installing it twice...
> When I click on the "Reporting Services" virtual directory, I see all
> the
> needed virtual folders except "Reports".
> Could I just try to delete the Reporting Services virtual directory
> and see
> if that fixes it and leave the ones alone that are directly under
> default websites?
> Thanks,
> Trint
>|||On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I don't know if the reporting services configuration tool will allow you to
> pick the correct virtual directory or not. See if it allows you to pick. If
> it is just showing it and not allowing you to pick then it is reading
> registry values or database values from somewhere and an unistall reinstall
> would be best. If you unistall then if the websites are still around you
> should manually delete them.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> wrote:
> >> >Trint, you should only have two websites. Did you install more than
> >> >once?
> >> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> >> > re-install it. Something is definitely wrong with your setup.
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:> Open up IIS Manager and see if you have the two websites:
> >> > Reports and
> >> > > ReportServer. If you do not then something went wrong during your
> >> > > install
> >> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
> >> > > Reporting
> >> > > Services). Make sure that the login you use to the server is a member
> >> > > of
> >> > > the
> >> > > local administrator group when installing.
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > Snip
> >> > Bruce,
> >> > Both of those virtual directories exist.
> >> > Reports, ReportServer and Reporting Services. They are all under
> >> > Default Website.
> >> > Thanks,Trint
> >> I think you are right...Seems like I remember having a problem on the
> >> first install.
> >> Do I delete one of them?
> >> Thanks,Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I see why I tried installing it twice...
> > When I click on the "Reporting Services" virtual directory, I see all
> > the
> > needed virtual folders except "Reports".
> > Could I just try to delete the Reporting Services virtual directory
> > and see
> > if that fixes it and leave the ones alone that are directly under
> > default websites?
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
You have no idea how much I appreciate your assistance.
If anything else pops up, I can't think of anyone else I'd rather
answer my questions...If you can't give me a contact, I understand...
But thank you so much...I'm sure I'll get it running correctly soon.
Trinit|||On Sep 26, 5:29 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > I don't know if the reporting services configuration tool will allow you to
> > pick the correct virtual directory or not. See if it allows you to pick. If
> > it is just showing it and not allowing you to pick then it is reading
> > registry values or database values from somewhere and an unistall reinstall
> > would be best. If you unistall then if the websites are still around you
> > should manually delete them.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> > > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> > >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > >> wrote:
> > >> >Trint, you should only have two websites. Did you install more than
> > >> >once?
> > >> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> > >> > re-install it. Something is definitely wrong with your setup.
> > >> > --
> > >> > Bruce Loehle-Conger
> > >> > MVP SQL Server Reporting Services
> > >> > "trint" <trinity.sm...@.gmail.com> wrote in message
> > >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > >> > wrote:> Open up IIS Manager and see if you have the two websites:
> > >> > Reports and
> > >> > > ReportServer. If you do not then something went wrong during your
> > >> > > install
> > >> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
> > >> > > Reporting
> > >> > > Services). Make sure that the login you use to the server is a member
> > >> > > of
> > >> > > the
> > >> > > local administrator group when installing.
> > >> > > --
> > >> > > Bruce Loehle-Conger
> > >> > > MVP SQL Server Reporting Services
> > >> > Snip
> > >> > Bruce,
> > >> > Both of those virtual directories exist.
> > >> > Reports, ReportServer and Reporting Services. They are all under
> > >> > Default Website.
> > >> > Thanks,Trint
> > >> I think you are right...Seems like I remember having a problem on the
> > >> first install.
> > >> Do I delete one of them?
> > >> Thanks,Trint- Hide quoted text -
> > >> - Show quoted text -
> > > Bruce,
> > > I see why I tried installing it twice...
> > > When I click on the "Reporting Services" virtual directory, I see all
> > > the
> > > needed virtual folders except "Reports".
> > > Could I just try to delete the Reporting Services virtual directory
> > > and see
> > > if that fixes it and leave the ones alone that are directly under
> > > default websites?
> > > Thanks,
> > >Trint- Hide quoted text -
> > - Show quoted text -
> Bruce,
> You have no idea how much I appreciate your assistance.
> If anything else pops up, I can't think of anyone else I'd rather
> answer my questions...If you can't give me a contact, I understand...
> But thank you so much...I'm sure I'll get it running correctly soon.
> Trinit- Hide quoted text -
> - Show quoted text -
Here is what fixed my problem:
I disabled the Execution Account with the Reporting Services
Configuration Manager.
Thanks,
Trint
deploying reports...
BUT now, to save my life, I haven't been able to get the first report
to deploy. I get these
errors:
A connection could not be made to the report server http://###.###.##.###/reportserver.
Additional information:
The attempt to connect to the reoprt server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
I change the TargetServerURL (after remote desktoping to the Report
Server itself) to:
http://GCC/ReportServer or http://localhost/ReportServer and get
another type of error:
A connection could not be made to the report server http://localhost/reportserver
The request failed with HTTP status 404: Bad Request
(System.Web.Service)
I've tried all the configurations I know and granted all permissions
and turned off the firewall.
Any help (especially at this point) is very appreciated.
Thanks,
TrintFirst things first. You need to make sure that you can open up Report
Manager (that is the portal that ships with RS). Sure, there won't be any
reports if none have been deployed but that is fine. It will show you that
everything is setup and working and that you have rights.
It sounds like in your case the easiest thing to do is to first remote
desktop to the server and then do this:
http://localhost/Reports/Pages/Folder.aspx
Do not try anything else until this comes up for you. If you have been
changing permissions in the database or in IIS after installing RS then you
have most likely just messed things up. You should never have to be doing
either one. Everything from a security perspective can be done using Report
Manager.
If IIS has set the two RS websites to anonymous then this will come up but
you will not be able to deploy because with anonymous no-one has rights to
deploy.
RS uses roles. Read up on how roles are used.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>I have had a great deal of success in the past on other systems with
> deploying reports...
> BUT now, to save my life, I haven't been able to get the first report
> to deploy. I get these
> errors:
> A connection could not be made to the report server
> http://###.###.##.###/reportserver.
> Additional information:
> The attempt to connect to the reoprt server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> I change the TargetServerURL (after remote desktoping to the Report
> Server itself) to:
> http://GCC/ReportServer or http://localhost/ReportServer and get
> another type of error:
> A connection could not be made to the report server
> http://localhost/reportserver
> The request failed with HTTP status 404: Bad Request
> (System.Web.Service)
> I've tried all the configurations I know and granted all permissions
> and turned off the firewall.
> Any help (especially at this point) is very appreciated.
> Thanks,
> Trint
>|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> First things first. You need to make sure that you can open up Report
> Manager (that is the portal that ships with RS). Sure, there won't be any
> reports if none have been deployed but that is fine. It will show you that
> everything is setup and working and that you have rights.
> It sounds like in your case the easiest thing to do is to first remote
> desktop to the server and then do this:
> http://localhost/Reports/Pages/Folder.aspx
> Do not try anything else until this comes up for you. If you have been
> changing permissions in the database or in IIS after installing RS then you
> have most likely just messed things up. You should never have to be doing
> either one. Everything from a security perspective can be done using Report
> Manager.
> If IIS has set the two RS websites to anonymous then this will come up but
> you will not be able to deploy because with anonymous no-one has rights to
> deploy.
> RS uses roles. Read up on how roles are used.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>
> >I have had a great deal of success in the past on other systems with
> > deploying reports...
> > BUT now, to save my life, I haven't been able to get the first report
> > to deploy. I get these
> > errors:
> > A connection could not be made to the report server
> > http://###.###.##.###/reportserver.
> > Additional information:
> > The attempt to connect to the reoprt server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > I change the TargetServerURL (after remote desktoping to the Report
> > Server itself) to:
> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
> > another type of error:
> > A connection could not be made to the report server
> >http://localhost/reportserver
> > The request failed with HTTP status 404: Bad Request
> > (System.Web.Service)
> > I've tried all the configurations I know and granted all permissions
> > and turned off the firewall.
> > Any help (especially at this point) is very appreciated.
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I'm going to try this right now! Please stay with me on this
I will be right back with you.
Thanks for your help!
Trint|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> First things first. You need to make sure that you can open up Report
> Manager (that is the portal that ships with RS). Sure, there won't be any
> reports if none have been deployed but that is fine. It will show you that
> everything is setup and working and that you have rights.
> It sounds like in your case the easiest thing to do is to first remote
> desktop to the server and then do this:
> http://localhost/Reports/Pages/Folder.aspx
> Do not try anything else until this comes up for you. If you have been
> changing permissions in the database or in IIS after installing RS then you
> have most likely just messed things up. You should never have to be doing
> either one. Everything from a security perspective can be done using Report
> Manager.
> If IIS has set the two RS websites to anonymous then this will come up but
> you will not be able to deploy because with anonymous no-one has rights to
> deploy.
> RS uses roles. Read up on how roles are used.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>
> >I have had a great deal of success in the past on other systems with
> > deploying reports...
> > BUT now, to save my life, I haven't been able to get the first report
> > to deploy. I get these
> > errors:
> > A connection could not be made to the report server
> > http://###.###.##.###/reportserver.
> > Additional information:
> > The attempt to connect to the reoprt server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > I change the TargetServerURL (after remote desktoping to the Report
> > Server itself) to:
> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
> > another type of error:
> > A connection could not be made to the report server
> >http://localhost/reportserver
> > The request failed with HTTP status 404: Bad Request
> > (System.Web.Service)
> > I've tried all the configurations I know and granted all permissions
> > and turned off the firewall.
> > Any help (especially at this point) is very appreciated.
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
Something is bad...I get the Reporting Services type screen, you know,
it's not the avereage
looking html page with the two lines at the top, a big red X in a red
circle and the message after the lines:
"The request failed with HTTP status 400: Bad Request."
and that's all there is on the page.
I could get that, unless i used the full ip address of the server it's
on, because I would just get the same
message on a regular http page using "localhost" or gcc, which is the
virtual folder.
Thanks for you help!
I sure hope I don't have to drive ALL the way over to Virginia (where
my server is) and reinstall SQL '05
Trint|||Run the program files->Microsoft SQL 2005->Configuration Tools -> reporting
services configuration
Make sure you have no red X's.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> First things first. You need to make sure that you can open up Report
>> Manager (that is the portal that ships with RS). Sure, there won't be any
>> reports if none have been deployed but that is fine. It will show you
>> that
>> everything is setup and working and that you have rights.
>> It sounds like in your case the easiest thing to do is to first remote
>> desktop to the server and then do this:
>> http://localhost/Reports/Pages/Folder.aspx
>> Do not try anything else until this comes up for you. If you have been
>> changing permissions in the database or in IIS after installing RS then
>> you
>> have most likely just messed things up. You should never have to be doing
>> either one. Everything from a security perspective can be done using
>> Report
>> Manager.
>> If IIS has set the two RS websites to anonymous then this will come up
>> but
>> you will not be able to deploy because with anonymous no-one has rights
>> to
>> deploy.
>> RS uses roles. Read up on how roles are used.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>>
>> >I have had a great deal of success in the past on other systems with
>> > deploying reports...
>> > BUT now, to save my life, I haven't been able to get the first report
>> > to deploy. I get these
>> > errors:
>> > A connection could not be made to the report server
>> > http://###.###.##.###/reportserver.
>> > Additional information:
>> > The attempt to connect to the reoprt server failed. Check your
>> > connection information and that the report server is a compatible
>> > version. (Microsoft.ReportingServices.Designer)
>> > I change the TargetServerURL (after remote desktoping to the Report
>> > Server itself) to:
>> >http://GCC/ReportServerorhttp://localhost/ReportServerand get
>> > another type of error:
>> > A connection could not be made to the report server
>> >http://localhost/reportserver
>> > The request failed with HTTP status 404: Bad Request
>> > (System.Web.Service)
>> > I've tried all the configurations I know and granted all permissions
>> > and turned off the firewall.
>> > Any help (especially at this point) is very appreciated.
>> > Thanks,
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> Something is bad...I get the Reporting Services type screen, you know,
> it's not the avereage
> looking html page with the two lines at the top, a big red X in a red
> circle and the message after the lines:
> "The request failed with HTTP status 400: Bad Request."
> and that's all there is on the page.
> I could get that, unless i used the full ip address of the server it's
> on, because I would just get the same
> message on a regular http page using "localhost" or gcc, which is the
> virtual folder.
> Thanks for you help!
> I sure hope I don't have to drive ALL the way over to Virginia (where
> my server is) and reinstall SQL '05
> Trint
>|||On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Run the program files->Microsoft SQL 2005->Configuration Tools -> reporting
> services configuration
> Make sure you have no red X's.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>
> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> First things first. You need to make sure that you can open up Report
> >> Manager (that is the portal that ships with RS). Sure, there won't be any
> >> reports if none have been deployed but that is fine. It will show you
> >> that
> >> everything is setup and working and that you have rights.
> >> It sounds like in your case the easiest thing to do is to first remote
> >> desktop to the server and then do this:
> >>http://localhost/Reports/Pages/Folder.aspx
> >> Do not try anything else until this comes up for you. If you have been
> >> changing permissions in the database or in IIS after installing RS then
> >> you
> >> have most likely just messed things up. You should never have to be doing
> >> either one. Everything from a security perspective can be done using
> >> Report
> >> Manager.
> >> If IIS has set the two RS websites to anonymous then this will come up
> >> but
> >> you will not be able to deploy because with anonymous no-one has rights
> >> to
> >> deploy.
> >> RS uses roles. Read up on how roles are used.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >I have had a great deal of success in the past on other systems with
> >> > deploying reports...
> >> > BUT now, to save my life, I haven't been able to get the first report
> >> > to deploy. I get these
> >> > errors:
> >> > A connection could not be made to the report server
> >> > http://###.###.##.###/reportserver.
> >> > Additional information:
> >> > The attempt to connect to the reoprt server failed. Check your
> >> > connection information and that the report server is a compatible
> >> > version. (Microsoft.ReportingServices.Designer)
> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> > Server itself) to:
> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> > another type of error:
> >> > A connection could not be made to the report server
> >> >http://localhost/reportserver
> >> > The request failed with HTTP status 404: Bad Request
> >> > (System.Web.Service)
> >> > I've tried all the configurations I know and granted all permissions
> >> > and turned off the firewall.
> >> > Any help (especially at this point) is very appreciated.
> >> > Thanks,
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > Something is bad...I get the Reporting Services type screen, you know,
> > it's not the avereage
> > looking html page with the two lines at the top, a big red X in a red
> > circle and the message after the lines:
> > "The request failed with HTTP status 400: Bad Request."
> > and that's all there is on the page.
> > I could get that, unless i used the full ip address of the server it's
> > on, because I would just get the same
> > message on a regular http page using "localhost" or gcc, which is the
> > virtual folder.
> > Thanks for you help!
> > I sure hope I don't have to drive ALL the way over to Virginia (where
> > my server is) and reinstall SQL '05
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I have one red x. It is on "Web Service Identity".
Thanks,
Trint|||That's your problem. Nothing will work without that. Report Manager (the
portal that ships with RS) uses web services. You need to get that Green.
For ASP.Net Service account I have NT Authority\NetworkService
For the application pools I use ReportServer for both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Run the program files->Microsoft SQL 2005->Configuration Tools ->
>> reporting
>> services configuration
>> Make sure you have no red X's.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>>
>> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> First things first. You need to make sure that you can open up Report
>> >> Manager (that is the portal that ships with RS). Sure, there won't be
>> >> any
>> >> reports if none have been deployed but that is fine. It will show you
>> >> that
>> >> everything is setup and working and that you have rights.
>> >> It sounds like in your case the easiest thing to do is to first remote
>> >> desktop to the server and then do this:
>> >>http://localhost/Reports/Pages/Folder.aspx
>> >> Do not try anything else until this comes up for you. If you have been
>> >> changing permissions in the database or in IIS after installing RS
>> >> then
>> >> you
>> >> have most likely just messed things up. You should never have to be
>> >> doing
>> >> either one. Everything from a security perspective can be done using
>> >> Report
>> >> Manager.
>> >> If IIS has set the two RS websites to anonymous then this will come up
>> >> but
>> >> you will not be able to deploy because with anonymous no-one has
>> >> rights
>> >> to
>> >> deploy.
>> >> RS uses roles. Read up on how roles are used.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>> >> >I have had a great deal of success in the past on other systems with
>> >> > deploying reports...
>> >> > BUT now, to save my life, I haven't been able to get the first
>> >> > report
>> >> > to deploy. I get these
>> >> > errors:
>> >> > A connection could not be made to the report server
>> >> > http://###.###.##.###/reportserver.
>> >> > Additional information:
>> >> > The attempt to connect to the reoprt server failed. Check your
>> >> > connection information and that the report server is a compatible
>> >> > version. (Microsoft.ReportingServices.Designer)
>> >> > I change the TargetServerURL (after remote desktoping to the Report
>> >> > Server itself) to:
>> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
>> >> > another type of error:
>> >> > A connection could not be made to the report server
>> >> >http://localhost/reportserver
>> >> > The request failed with HTTP status 404: Bad Request
>> >> > (System.Web.Service)
>> >> > I've tried all the configurations I know and granted all permissions
>> >> > and turned off the firewall.
>> >> > Any help (especially at this point) is very appreciated.
>> >> > Thanks,
>> >> >Trint- Hide quoted text -
>> >> - Show quoted text -
>> > Bruce,
>> > Something is bad...I get the Reporting Services type screen, you know,
>> > it's not the avereage
>> > looking html page with the two lines at the top, a big red X in a red
>> > circle and the message after the lines:
>> > "The request failed with HTTP status 400: Bad Request."
>> > and that's all there is on the page.
>> > I could get that, unless i used the full ip address of the server it's
>> > on, because I would just get the same
>> > message on a regular http page using "localhost" or gcc, which is the
>> > virtual folder.
>> > Thanks for you help!
>> > I sure hope I don't have to drive ALL the way over to Virginia (where
>> > my server is) and reinstall SQL '05
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I have one red x. It is on "Web Service Identity".
> Thanks,
> Trint
>|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> That's your problem. Nothing will work without that. Report Manager (the
> portal that ships with RS) uses web services. You need to get that Green.
> For ASP.Net Service account I have NT Authority\NetworkService
> For the application pools I use ReportServer for both.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> reporting
> >> services configuration
> >> Make sure you have no red X's.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> First things first. You need to make sure that you can open up Report
> >> >> Manager (that is the portal that ships with RS). Sure, there won't be
> >> >> any
> >> >> reports if none have been deployed but that is fine. It will show you
> >> >> that
> >> >> everything is setup and working and that you have rights.
> >> >> It sounds like in your case the easiest thing to do is to first remote
> >> >> desktop to the server and then do this:
> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> Do not try anything else until this comes up for you. If you have been
> >> >> changing permissions in the database or in IIS after installing RS
> >> >> then
> >> >> you
> >> >> have most likely just messed things up. You should never have to be
> >> >> doing
> >> >> either one. Everything from a security perspective can be done using
> >> >> Report
> >> >> Manager.
> >> >> If IIS has set the two RS websites to anonymous then this will come up
> >> >> but
> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> rights
> >> >> to
> >> >> deploy.
> >> >> RS uses roles. Read up on how roles are used.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >I have had a great deal of success in the past on other systems with
> >> >> > deploying reports...
> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> > report
> >> >> > to deploy. I get these
> >> >> > errors:
> >> >> > A connection could not be made to the report server
> >> >> > http://###.###.##.###/reportserver.
> >> >> > Additional information:
> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> > connection information and that the report server is a compatible
> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> >> > Server itself) to:
> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> > another type of error:
> >> >> > A connection could not be made to the report server
> >> >> >http://localhost/reportserver
> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> > (System.Web.Service)
> >> >> > I've tried all the configurations I know and granted all permissions
> >> >> > and turned off the firewall.
> >> >> > Any help (especially at this point) is very appreciated.
> >> >> > Thanks,
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > Something is bad...I get the Reporting Services type screen, you know,
> >> > it's not the avereage
> >> > looking html page with the two lines at the top, a big red X in a red
> >> > circle and the message after the lines:
> >> > "The request failed with HTTP status 400: Bad Request."
> >> > and that's all there is on the page.
> >> > I could get that, unless i used the full ip address of the server it's
> >> > on, because I would just get the same
> >> > message on a regular http page using "localhost" or gcc, which is the
> >> > virtual folder.
> >> > Thanks for you help!
> >> > I sure hope I don't have to drive ALL the way over to Virginia (where
> >> > my server is) and reinstall SQL '05
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I have one red x. It is on "Web Service Identity".
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
What do I do to fix this?
I need your help and am very appreciative.
Thanks,
Trint|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> That's your problem. Nothing will work without that. Report Manager (the
> portal that ships with RS) uses web services. You need to get that Green.
> For ASP.Net Service account I have NT Authority\NetworkService
> For the application pools I use ReportServer for both.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> reporting
> >> services configuration
> >> Make sure you have no red X's.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> First things first. You need to make sure that you can open up Report
> >> >> Manager (that is the portal that ships with RS). Sure, there won't be
> >> >> any
> >> >> reports if none have been deployed but that is fine. It will show you
> >> >> that
> >> >> everything is setup and working and that you have rights.
> >> >> It sounds like in your case the easiest thing to do is to first remote
> >> >> desktop to the server and then do this:
> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> Do not try anything else until this comes up for you. If you have been
> >> >> changing permissions in the database or in IIS after installing RS
> >> >> then
> >> >> you
> >> >> have most likely just messed things up. You should never have to be
> >> >> doing
> >> >> either one. Everything from a security perspective can be done using
> >> >> Report
> >> >> Manager.
> >> >> If IIS has set the two RS websites to anonymous then this will come up
> >> >> but
> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> rights
> >> >> to
> >> >> deploy.
> >> >> RS uses roles. Read up on how roles are used.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >I have had a great deal of success in the past on other systems with
> >> >> > deploying reports...
> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> > report
> >> >> > to deploy. I get these
> >> >> > errors:
> >> >> > A connection could not be made to the report server
> >> >> > http://###.###.##.###/reportserver.
> >> >> > Additional information:
> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> > connection information and that the report server is a compatible
> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> > I change the TargetServerURL (after remote desktoping to the Report
> >> >> > Server itself) to:
> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> > another type of error:
> >> >> > A connection could not be made to the report server
> >> >> >http://localhost/reportserver
> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> > (System.Web.Service)
> >> >> > I've tried all the configurations I know and granted all permissions
> >> >> > and turned off the firewall.
> >> >> > Any help (especially at this point) is very appreciated.
> >> >> > Thanks,
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > Something is bad...I get the Reporting Services type screen, you know,
> >> > it's not the avereage
> >> > looking html page with the two lines at the top, a big red X in a red
> >> > circle and the message after the lines:
> >> > "The request failed with HTTP status 400: Bad Request."
> >> > and that's all there is on the page.
> >> > I could get that, unless i used the full ip address of the server it's
> >> > on, because I would just get the same
> >> > message on a regular http page using "localhost" or gcc, which is the
> >> > virtual folder.
> >> > Thanks for you help!
> >> > I sure hope I don't have to drive ALL the way over to Virginia (where
> >> > my server is) and reinstall SQL '05
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I have one red x. It is on "Web Service Identity".
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I did as you said and the (more information on this error) gave me
this:
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
directory must first be created before performing this operation.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
applicationPool)
Thanks,
Trint|||Open up IIS Manager and see if you have the two websites: Reports and
ReportServer. If you do not then something went wrong during your install
and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
Services). Make sure that the login you use to the server is a member of the
local administrator group when installing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
> On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> That's your problem. Nothing will work without that. Report Manager (the
>> portal that ships with RS) uses web services. You need to get that Green.
>> For ASP.Net Service account I have NT Authority\NetworkService
>> For the application pools I use ReportServer for both.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>>
>> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
>> >> reporting
>> >> services configuration
>> >> Make sure you have no red X's.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> >> > wrote:
>> >> >> First things first. You need to make sure that you can open up
>> >> >> Report
>> >> >> Manager (that is the portal that ships with RS). Sure, there won't
>> >> >> be
>> >> >> any
>> >> >> reports if none have been deployed but that is fine. It will show
>> >> >> you
>> >> >> that
>> >> >> everything is setup and working and that you have rights.
>> >> >> It sounds like in your case the easiest thing to do is to first
>> >> >> remote
>> >> >> desktop to the server and then do this:
>> >> >>http://localhost/Reports/Pages/Folder.aspx
>> >> >> Do not try anything else until this comes up for you. If you have
>> >> >> been
>> >> >> changing permissions in the database or in IIS after installing RS
>> >> >> then
>> >> >> you
>> >> >> have most likely just messed things up. You should never have to be
>> >> >> doing
>> >> >> either one. Everything from a security perspective can be done
>> >> >> using
>> >> >> Report
>> >> >> Manager.
>> >> >> If IIS has set the two RS websites to anonymous then this will come
>> >> >> up
>> >> >> but
>> >> >> you will not be able to deploy because with anonymous no-one has
>> >> >> rights
>> >> >> to
>> >> >> deploy.
>> >> >> RS uses roles. Read up on how roles are used.
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
>> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
>> >> >> >I have had a great deal of success in the past on other systems
>> >> >> >with
>> >> >> > deploying reports...
>> >> >> > BUT now, to save my life, I haven't been able to get the first
>> >> >> > report
>> >> >> > to deploy. I get these
>> >> >> > errors:
>> >> >> > A connection could not be made to the report server
>> >> >> > http://###.###.##.###/reportserver.
>> >> >> > Additional information:
>> >> >> > The attempt to connect to the reoprt server failed. Check your
>> >> >> > connection information and that the report server is a compatible
>> >> >> > version. (Microsoft.ReportingServices.Designer)
>> >> >> > I change the TargetServerURL (after remote desktoping to the
>> >> >> > Report
>> >> >> > Server itself) to:
>> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
>> >> >> > another type of error:
>> >> >> > A connection could not be made to the report server
>> >> >> >http://localhost/reportserver
>> >> >> > The request failed with HTTP status 404: Bad Request
>> >> >> > (System.Web.Service)
>> >> >> > I've tried all the configurations I know and granted all
>> >> >> > permissions
>> >> >> > and turned off the firewall.
>> >> >> > Any help (especially at this point) is very appreciated.
>> >> >> > Thanks,
>> >> >> >Trint- Hide quoted text -
>> >> >> - Show quoted text -
>> >> > Bruce,
>> >> > Something is bad...I get the Reporting Services type screen, you
>> >> > know,
>> >> > it's not the avereage
>> >> > looking html page with the two lines at the top, a big red X in a
>> >> > red
>> >> > circle and the message after the lines:
>> >> > "The request failed with HTTP status 400: Bad Request."
>> >> > and that's all there is on the page.
>> >> > I could get that, unless i used the full ip address of the server
>> >> > it's
>> >> > on, because I would just get the same
>> >> > message on a regular http page using "localhost" or gcc, which is
>> >> > the
>> >> > virtual folder.
>> >> > Thanks for you help!
>> >> > I sure hope I don't have to drive ALL the way over to Virginia
>> >> > (where
>> >> > my server is) and reinstall SQL '05
>> >> >Trint- Hide quoted text -
>> >> - Show quoted text -
>> > Bruce,
>> > I have one red x. It is on "Web Service Identity".
>> > Thanks,
>> >Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I did as you said and the (more information on this error) gave me
> this:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
> directory must first be created before performing this operation.
>
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
> applicationPool)
> Thanks,
> Trint
>|||On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Open up IIS Manager and see if you have the two websites: Reports and
> ReportServer. If you do not then something went wrong during your install
> and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> Services). Make sure that the login you use to the server is a member of =the
> local administrator group when installing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
>
> > On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> That's your problem. Nothing will work without that. Report Manager (t=he
> >> portal that ships with RS) uses web services. You need to get that Gre=en.
> >> For ASP.Net Service account I have NT Authority\NetworkService
> >> For the application pools I use ReportServer for both.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> >> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> Run the program files->Microsoft SQL 2005->Configuration Tools ->
> >> >> reporting
> >> >> services configuration
> >> >> Make sure you have no red X's.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.c=om>
> >> >> > wrote:
> >> >> >> First things first. You need to make sure that you can open up
> >> >> >> Report
> >> >> >> Manager (that is the portal that ships with RS). Sure, there won='t
> >> >> >> be
> >> >> >> any
> >> >> >> reports if none have been deployed but that is fine. It will show
> >> >> >> you
> >> >> >> that
> >> >> >> everything is setup and working and that you have rights.
> >> >> >> It sounds like in your case the easiest thing to do is to first
> >> >> >> remote
> >> >> >> desktop to the server and then do this:
> >> >> >>http://localhost/Reports/Pages/Folder.aspx
> >> >> >> Do not try anything else until this comes up for you. If you have
> >> >> >> been
> >> >> >> changing permissions in the database or in IIS after installing =RS
> >> >> >> then
> >> >> >> you
> >> >> >> have most likely just messed things up. You should never have to= be
> >> >> >> doing
> >> >> >> either one. Everything from a security perspective can be done
> >> >> >> using
> >> >> >> Report
> >> >> >> Manager.
> >> >> >> If IIS has set the two RS websites to anonymous then this will c=ome
> >> >> >> up
> >> >> >> but
> >> >> >> you will not be able to deploy because with anonymous no-one has
> >> >> >> rights
> >> >> >> to
> >> >> >> deploy.
> >> >> >> RS uses roles. Read up on how roles are used.
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >> >>news:1190668106.834755.26140@.22g2000hsm.googlegroups.com...
> >> >> >> >I have had a great deal of success in the past on other systems
> >> >> >> >with
> >> >> >> > deploying reports...
> >> >> >> > BUT now, to save my life, I haven't been able to get the first
> >> >> >> > report
> >> >> >> > to deploy. I get these
> >> >> >> > errors:
> >> >> >> > A connection could not be made to the report server
> >> >> >> > http://###.###.##.###/reportserver.
> >> >> >> > Additional information:
> >> >> >> > The attempt to connect to the reoprt server failed. Check your
> >> >> >> > connection information and that the report server is a compati=ble
> >> >> >> > version. (Microsoft.ReportingServices.Designer)
> >> >> >> > I change the TargetServerURL (after remote desktoping to the
> >> >> >> > Report
> >> >> >> > Server itself) to:
> >> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget
> >> >> >> > another type of error:
> >> >> >> > A connection could not be made to the report server
> >> >> >> >http://localhost/reportserver
> >> >> >> > The request failed with HTTP status 404: Bad Request
> >> >> >> > (System.Web.Service)
> >> >> >> > I've tried all the configurations I know and granted all
> >> >> >> > permissions
> >> >> >> > and turned off the firewall.
> >> >> >> > Any help (especially at this point) is very appreciated.
> >> >> >> > Thanks,
> >> >> >> >Trint- Hide quoted text -
> >> >> >> - Show quoted text -
> >> >> > Bruce,
> >> >> > Something is bad...I get the Reporting Services type screen, you
> >> >> > know,
> >> >> > it's not the avereage
> >> >> > looking html page with the two lines at the top, a big red X in a
> >> >> > red
> >> >> > circle and the message after the lines:
> >> >> > "The request failed with HTTP status 400: Bad Request."
> >> >> > and that's all there is on the page.
> >> >> > I could get that, unless i used the full ip address of the server
> >> >> > it's
> >> >> > on, because I would just get the same
> >> >> > message on a regular http page using "localhost" or gcc, which is
> >> >> > the
> >> >> > virtual folder.
> >> >> > Thanks for you help!
> >> >> > I sure hope I don't have to drive ALL the way over to Virginia
> >> >> > (where
> >> >> > my server is) and reinstall SQL '05
> >> >> >Trint- Hide quoted text -
> >> >> - Show quoted text -
> >> > Bruce,
> >> > I have one red x. It is on "Web Service Identity".
> >> > Thanks,
> >> >Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I did as you said and the (more information on this error) gave me
> > this:
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual
> > directory must first be created before performing this operation.
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIde=ntit=ADy(String
> > applicationPool)
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
Both of those virtual directories exist.
Reports, ReportServer and Reporting Services. They are all under
Default Website.
Thanks,
Trint|||Trint, you should only have two websites. Did you install more than once?
The only suggestion I have on cleaning this up is to Uninstall RS. Then
re-install it. Something is definitely wrong with your setup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Open up IIS Manager and see if you have the two websites: Reports and
> ReportServer. If you do not then something went wrong during your install
> and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> Services). Make sure that the login you use to the server is a member of
> the
> local administrator group when installing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
Snip
Bruce,
Both of those virtual directories exist.
Reports, ReportServer and Reporting Services. They are all under
Default Website.
Thanks,
Trint|||On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Trint, you should only have two websites. Did you install more than once?
> The only suggestion I have on cleaning this up is to Uninstall RS. Then
> re-install it. Something is definitely wrong with your setup.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:> Open up IIS Manager and see if you have the two websites: Reports and
> > ReportServer. If you do not then something went wrong during your install
> > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> > Services). Make sure that the login you use to the server is a member of
> > the
> > local administrator group when installing.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> Snip
> Bruce,
> Both of those virtual directories exist.
> Reports, ReportServer and Reporting Services. They are all under
> Default Website.
> Thanks,Trint
I think you are right...Seems like I remember having a problem on the
first install.
Do I delete one of them?
Thanks,
Trint|||On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> >Trint, you should only have two websites. Did you install more than once?
> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> > re-install it. Something is definitely wrong with your setup.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:> Open up IIS Manager and see if you have the two websites: Reports and
> > > ReportServer. If you do not then something went wrong during your install
> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting
> > > Services). Make sure that the login you use to the server is a member of
> > > the
> > > local administrator group when installing.
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > Snip
> > Bruce,
> > Both of those virtual directories exist.
> > Reports, ReportServer and Reporting Services. They are all under
> > Default Website.
> > Thanks,Trint
> I think you are right...Seems like I remember having a problem on the
> first install.
> Do I delete one of them?
> Thanks,Trint- Hide quoted text -
> - Show quoted text -
Bruce,
I see why I tried installing it twice...
When I click on the "Reporting Services" virtual directory, I see all
the
needed virtual folders except "Reports".
Could I just try to delete the Reporting Services virtual directory
and see
if that fixes it and leave the ones alone that are directly under
default websites?
Thanks,
Trint|||I don't know if the reporting services configuration tool will allow you to
pick the correct virtual directory or not. See if it allows you to pick. If
it is just showing it and not allowing you to pick then it is reading
registry values or database values from somewhere and an unistall reinstall
would be best. If you unistall then if the websites are still around you
should manually delete them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
>> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> wrote:
>>
>>
>> >Trint, you should only have two websites. Did you install more than
>> >once?
>> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
>> > re-install it. Something is definitely wrong with your setup.
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> > "trint" <trinity.sm...@.gmail.com> wrote in message
>> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
>> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:> Open up IIS Manager and see if you have the two websites:
>> > Reports and
>> > > ReportServer. If you do not then something went wrong during your
>> > > install
>> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
>> > > Reporting
>> > > Services). Make sure that the login you use to the server is a member
>> > > of
>> > > the
>> > > local administrator group when installing.
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > Snip
>> > Bruce,
>> > Both of those virtual directories exist.
>> > Reports, ReportServer and Reporting Services. They are all under
>> > Default Website.
>> > Thanks,Trint
>> I think you are right...Seems like I remember having a problem on the
>> first install.
>> Do I delete one of them?
>> Thanks,Trint- Hide quoted text -
>> - Show quoted text -
> Bruce,
> I see why I tried installing it twice...
> When I click on the "Reporting Services" virtual directory, I see all
> the
> needed virtual folders except "Reports".
> Could I just try to delete the Reporting Services virtual directory
> and see
> if that fixes it and leave the ones alone that are directly under
> default websites?
> Thanks,
> Trint
>|||On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I don't know if the reporting services configuration tool will allow you to
> pick the correct virtual directory or not. See if it allows you to pick. If
> it is just showing it and not allowing you to pick then it is reading
> registry values or database values from somewhere and an unistall reinstall
> would be best. If you unistall then if the websites are still around you
> should manually delete them.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> wrote:
> >> >Trint, you should only have two websites. Did you install more than
> >> >once?
> >> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> >> > re-install it. Something is definitely wrong with your setup.
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:> Open up IIS Manager and see if you have the two websites:
> >> > Reports and
> >> > > ReportServer. If you do not then something went wrong during your
> >> > > install
> >> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
> >> > > Reporting
> >> > > Services). Make sure that the login you use to the server is a member
> >> > > of
> >> > > the
> >> > > local administrator group when installing.
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > Snip
> >> > Bruce,
> >> > Both of those virtual directories exist.
> >> > Reports, ReportServer and Reporting Services. They are all under
> >> > Default Website.
> >> > Thanks,Trint
> >> I think you are right...Seems like I remember having a problem on the
> >> first install.
> >> Do I delete one of them?
> >> Thanks,Trint- Hide quoted text -
> >> - Show quoted text -
> > Bruce,
> > I see why I tried installing it twice...
> > When I click on the "Reporting Services" virtual directory, I see all
> > the
> > needed virtual folders except "Reports".
> > Could I just try to delete the Reporting Services virtual directory
> > and see
> > if that fixes it and leave the ones alone that are directly under
> > default websites?
> > Thanks,
> >Trint- Hide quoted text -
> - Show quoted text -
Bruce,
You have no idea how much I appreciate your assistance.
If anything else pops up, I can't think of anyone else I'd rather
answer my questions...If you can't give me a contact, I understand...
But thank you so much...I'm sure I'll get it running correctly soon.
Trinit|||On Sep 26, 5:29 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > I don't know if the reporting services configuration tool will allow you to
> > pick the correct virtual directory or not. See if it allows you to pick. If
> > it is just showing it and not allowing you to pick then it is reading
> > registry values or database values from somewhere and an unistall reinstall
> > would be best. If you unistall then if the websites are still around you
> > should manually delete them.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "trint" <trinity.sm...@.gmail.com> wrote in message
> >news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> > > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> > >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > >> wrote:
> > >> >Trint, you should only have two websites. Did you install more than
> > >> >once?
> > >> > The only suggestion I have on cleaning this up is to Uninstall RS. Then
> > >> > re-install it. Something is definitely wrong with your setup.
> > >> > --
> > >> > Bruce Loehle-Conger
> > >> > MVP SQL Server Reporting Services
> > >> > "trint" <trinity.sm...@.gmail.com> wrote in message
> > >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > >> > wrote:> Open up IIS Manager and see if you have the two websites:
> > >> > Reports and
> > >> > > ReportServer. If you do not then something went wrong during your
> > >> > > install
> > >> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just
> > >> > > Reporting
> > >> > > Services). Make sure that the login you use to the server is a member
> > >> > > of
> > >> > > the
> > >> > > local administrator group when installing.
> > >> > > --
> > >> > > Bruce Loehle-Conger
> > >> > > MVP SQL Server Reporting Services
> > >> > Snip
> > >> > Bruce,
> > >> > Both of those virtual directories exist.
> > >> > Reports, ReportServer and Reporting Services. They are all under
> > >> > Default Website.
> > >> > Thanks,Trint
> > >> I think you are right...Seems like I remember having a problem on the
> > >> first install.
> > >> Do I delete one of them?
> > >> Thanks,Trint- Hide quoted text -
> > >> - Show quoted text -
> > > Bruce,
> > > I see why I tried installing it twice...
> > > When I click on the "Reporting Services" virtual directory, I see all
> > > the
> > > needed virtual folders except "Reports".
> > > Could I just try to delete the Reporting Services virtual directory
> > > and see
> > > if that fixes it and leave the ones alone that are directly under
> > > default websites?
> > > Thanks,
> > >Trint- Hide quoted text -
> > - Show quoted text -
> Bruce,
> You have no idea how much I appreciate your assistance.
> If anything else pops up, I can't think of anyone else I'd rather
> answer my questions...If you can't give me a contact, I understand...
> But thank you so much...I'm sure I'll get it running correctly soon.
> Trinit- Hide quoted text -
> - Show quoted text -
Here is what fixed my problem:
I disabled the Execution Account with the Reporting Services
Configuration Manager.
Thanks,
Trint
Subscribe to:
Posts (Atom)