Showing posts with label machines. Show all posts
Showing posts with label machines. Show all posts

Friday, March 30, 2012

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.sql

Saturday, February 25, 2012

Report Server and Report Manager on different machines

It is possible to configure a system of servers such that
the Report Manager can be running on a separate machine
than the Report Server?
We are concerned about the security issues of exposing a
server with the Front Page Server Extensions installed on
it, because it will reside outside of our corporate
firewall. As an alternative, we are hoping we can host
the Web Server/IIS box outside the firewall, and have
this machine run the Report Manager, while another box
inside the firewall runs the Report Server (which,
incidentally, will also be a separate box than the data
server).
Whether the security concerns of FPSE are real or
perceived, our clients might not like them. So, is the
type of configuration described above at all possible?
If not, please explain why. If it is possible, please
explain how.
Thanks in advance!Front Page Server extensions are not necessary for Report Manager. Just to
make sure I checked one of my servers (Windows 2003) and the default website
which has Report Manager does not have FP server extension.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Justin" <anonymous@.discussions.microsoft.com> wrote in message
news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> It is possible to configure a system of servers such that
> the Report Manager can be running on a separate machine
> than the Report Server?
> We are concerned about the security issues of exposing a
> server with the Front Page Server Extensions installed on
> it, because it will reside outside of our corporate
> firewall. As an alternative, we are hoping we can host
> the Web Server/IIS box outside the firewall, and have
> this machine run the Report Manager, while another box
> inside the firewall runs the Report Server (which,
> incidentally, will also be a separate box than the data
> server).
> Whether the security concerns of FPSE are real or
> perceived, our clients might not like them. So, is the
> type of configuration described above at all possible?
> If not, please explain why. If it is possible, please
> explain how.
> Thanks in advance!
>|||So, FPSE are only required on a Report Designer
installtion -- is that correct?
FPSE are a requirement for VisualStudio.NET installation,
which are required for Report Designer, right?
>--Original Message--
>Front Page Server extensions are not necessary for
Report Manager. Just to
>make sure I checked one of my servers (Windows 2003) and
the default website
>which has Report Manager does not have FP server
extension.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
>"Justin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> It is possible to configure a system of servers such
that
>> the Report Manager can be running on a separate machine
>> than the Report Server?
>> We are concerned about the security issues of exposing
a
>> server with the Front Page Server Extensions installed
on
>> it, because it will reside outside of our corporate
>> firewall. As an alternative, we are hoping we can host
>> the Web Server/IIS box outside the firewall, and have
>> this machine run the Report Manager, while another box
>> inside the firewall runs the Report Server (which,
>> incidentally, will also be a separate box than the data
>> server).
>> Whether the security concerns of FPSE are real or
>> perceived, our clients might not like them. So, is the
>> type of configuration described above at all possible?
>> If not, please explain why. If it is possible, please
>> explain how.
>> Thanks in advance!
>
>.
>|||No. FPSE are not required for anything. The report designer does not even
have to have IIS.
You've gotten a misconception from somewhere that this is required.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<anonymous@.discussions.microsoft.com> wrote in message
news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
> So, FPSE are only required on a Report Designer
> installtion -- is that correct?
> FPSE are a requirement for VisualStudio.NET installation,
> which are required for Report Designer, right?
>
> >--Original Message--
> >Front Page Server extensions are not necessary for
> Report Manager. Just to
> >make sure I checked one of my servers (Windows 2003) and
> the default website
> >which has Report Manager does not have FP server
> extension.
> >
> >--
> >Bruce Loehle-Conger
> >MVP SQL Server Reporting Services
> >
> >"Justin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> >> It is possible to configure a system of servers such
> that
> >> the Report Manager can be running on a separate machine
> >> than the Report Server?
> >>
> >> We are concerned about the security issues of exposing
> a
> >> server with the Front Page Server Extensions installed
> on
> >> it, because it will reside outside of our corporate
> >> firewall. As an alternative, we are hoping we can host
> >> the Web Server/IIS box outside the firewall, and have
> >> this machine run the Report Manager, while another box
> >> inside the firewall runs the Report Server (which,
> >> incidentally, will also be a separate box than the data
> >> server).
> >>
> >> Whether the security concerns of FPSE are real or
> >> perceived, our clients might not like them. So, is the
> >> type of configuration described above at all possible?
> >> If not, please explain why. If it is possible, please
> >> explain how.
> >>
> >> Thanks in advance!
> >>
> >
> >
> >.
> >|||Yes, I guess I do have that misconception. I thought
that in order to deploy a report from the report designer
to the report server, FPSE were required.
I'm glad to hear that this is not the case. I'll check
out our servers again and try to verify this.
Thanks.
>--Original Message--
>No. FPSE are not required for anything. The report
designer does not even
>have to have IIS.
>You've gotten a misconception from somewhere that this
is required.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
><anonymous@.discussions.microsoft.com> wrote in message
>news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
>> So, FPSE are only required on a Report Designer
>> installtion -- is that correct?
>> FPSE are a requirement for VisualStudio.NET
installation,
>> which are required for Report Designer, right?
>>
>> >--Original Message--
>> >Front Page Server extensions are not necessary for
>> Report Manager. Just to
>> >make sure I checked one of my servers (Windows 2003)
and
>> the default website
>> >which has Report Manager does not have FP server
>> extension.
>> >
>> >--
>> >Bruce Loehle-Conger
>> >MVP SQL Server Reporting Services
>> >
>> >"Justin" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> >> It is possible to configure a system of servers such
>> that
>> >> the Report Manager can be running on a separate
machine
>> >> than the Report Server?
>> >>
>> >> We are concerned about the security issues of
exposing
>> a
>> >> server with the Front Page Server Extensions
installed
>> on
>> >> it, because it will reside outside of our corporate
>> >> firewall. As an alternative, we are hoping we can
host
>> >> the Web Server/IIS box outside the firewall, and
have
>> >> this machine run the Report Manager, while another
box
>> >> inside the firewall runs the Report Server (which,
>> >> incidentally, will also be a separate box than the
data
>> >> server).
>> >>
>> >> Whether the security concerns of FPSE are real or
>> >> perceived, our clients might not like them. So, is
the
>> >> type of configuration described above at all
possible?
>> >> If not, please explain why. If it is possible,
please
>> >> explain how.
>> >>
>> >> Thanks in advance!
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||What you might be confused about is thinking about using Visual Studio for
regular ASP.Net development. It is common to have FPSE for that. However,
with RS you are not deploying webpages. What you are doing is using
webservices to deploy the RDL. If you look on the server you will see that
no files are even showing up there when you deploy. That is because the RDL
is being stored in the database, not in the file system.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Justin" <anonymous@.discussions.microsoft.com> wrote in message
news:176001c4ccc2$b3afef70$a501280a@.phx.gbl...
> Yes, I guess I do have that misconception. I thought
> that in order to deploy a report from the report designer
> to the report server, FPSE were required.
> I'm glad to hear that this is not the case. I'll check
> out our servers again and try to verify this.
> Thanks.
> >--Original Message--
> >No. FPSE are not required for anything. The report
> designer does not even
> >have to have IIS.
> >
> >You've gotten a misconception from somewhere that this
> is required.
> >
> >--
> >Bruce Loehle-Conger
> >MVP SQL Server Reporting Services
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
> >> So, FPSE are only required on a Report Designer
> >> installtion -- is that correct?
> >>
> >> FPSE are a requirement for VisualStudio.NET
> installation,
> >> which are required for Report Designer, right?
> >>
> >>
> >> >--Original Message--
> >> >Front Page Server extensions are not necessary for
> >> Report Manager. Just to
> >> >make sure I checked one of my servers (Windows 2003)
> and
> >> the default website
> >> >which has Report Manager does not have FP server
> >> extension.
> >> >
> >> >--
> >> >Bruce Loehle-Conger
> >> >MVP SQL Server Reporting Services
> >> >
> >> >"Justin" <anonymous@.discussions.microsoft.com> wrote
> in
> >> message
> >> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> >> >> It is possible to configure a system of servers such
> >> that
> >> >> the Report Manager can be running on a separate
> machine
> >> >> than the Report Server?
> >> >>
> >> >> We are concerned about the security issues of
> exposing
> >> a
> >> >> server with the Front Page Server Extensions
> installed
> >> on
> >> >> it, because it will reside outside of our corporate
> >> >> firewall. As an alternative, we are hoping we can
> host
> >> >> the Web Server/IIS box outside the firewall, and
> have
> >> >> this machine run the Report Manager, while another
> box
> >> >> inside the firewall runs the Report Server (which,
> >> >> incidentally, will also be a separate box than the
> data
> >> >> server).
> >> >>
> >> >> Whether the security concerns of FPSE are real or
> >> >> perceived, our clients might not like them. So, is
> the
> >> >> type of configuration described above at all
> possible?
> >> >> If not, please explain why. If it is possible,
> please
> >> >> explain how.
> >> >>
> >> >> Thanks in advance!
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Yes, that makes sense. I think that is exactly where I
was going wrong.
Thanks again!
>--Original Message--
>What you might be confused about is thinking about using
Visual Studio for
>regular ASP.Net development. It is common to have FPSE
for that. However,
>with RS you are not deploying webpages. What you are
doing is using
>webservices to deploy the RDL. If you look on the server
you will see that
>no files are even showing up there when you deploy. That
is because the RDL
>is being stored in the database, not in the file system.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
>"Justin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:176001c4ccc2$b3afef70$a501280a@.phx.gbl...
>> Yes, I guess I do have that misconception. I thought
>> that in order to deploy a report from the report
designer
>> to the report server, FPSE were required.
>> I'm glad to hear that this is not the case. I'll check
>> out our servers again and try to verify this.
>> Thanks.
>> >--Original Message--
>> >No. FPSE are not required for anything. The report
>> designer does not even
>> >have to have IIS.
>> >
>> >You've gotten a misconception from somewhere that this
>> is required.
>> >
>> >--
>> >Bruce Loehle-Conger
>> >MVP SQL Server Reporting Services
>> >
>> ><anonymous@.discussions.microsoft.com> wrote in message
>> >news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
>> >> So, FPSE are only required on a Report Designer
>> >> installtion -- is that correct?
>> >>
>> >> FPSE are a requirement for VisualStudio.NET
>> installation,
>> >> which are required for Report Designer, right?
>> >>
>> >>
>> >> >--Original Message--
>> >> >Front Page Server extensions are not necessary for
>> >> Report Manager. Just to
>> >> >make sure I checked one of my servers (Windows
2003)
>> and
>> >> the default website
>> >> >which has Report Manager does not have FP server
>> >> extension.
>> >> >
>> >> >--
>> >> >Bruce Loehle-Conger
>> >> >MVP SQL Server Reporting Services
>> >> >
>> >> >"Justin" <anonymous@.discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> >> >> It is possible to configure a system of servers
such
>> >> that
>> >> >> the Report Manager can be running on a separate
>> machine
>> >> >> than the Report Server?
>> >> >>
>> >> >> We are concerned about the security issues of
>> exposing
>> >> a
>> >> >> server with the Front Page Server Extensions
>> installed
>> >> on
>> >> >> it, because it will reside outside of our
corporate
>> >> >> firewall. As an alternative, we are hoping we
can
>> host
>> >> >> the Web Server/IIS box outside the firewall, and
>> have
>> >> >> this machine run the Report Manager, while
another
>> box
>> >> >> inside the firewall runs the Report Server
(which,
>> >> >> incidentally, will also be a separate box than
the
>> data
>> >> >> server).
>> >> >>
>> >> >> Whether the security concerns of FPSE are real or
>> >> >> perceived, our clients might not like them. So,
is
>> the
>> >> >> type of configuration described above at all
>> possible?
>> >> >> If not, please explain why. If it is possible,
>> please
>> >> >> explain how.
>> >> >>
>> >> >> Thanks in advance!
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>