all groups > sql server reporting services > july 2006 >
You're in the

sql server reporting services

group:

Launching Report Builder via internet


Launching Report Builder via internet John J. Hughes II
7/28/2006 9:10:06 AM
sql server reporting services:
I have a copy of report builder exposed to the local LAN and also the
internet, currently I am using a dynamic IP for testing in a development
environment. I am using windows logon to for security.

If I log onto the server from the local lan using the username/pw the report
display and I am able to launch the report builder. If I logon via the
internet I am able to view the report but when I launch the report builder I
get a secuirty error as far as I can tel.

Do the reports consider an internet connection different to a LAN
connection?
Is there a way around this problem?
Suggestions?

Using SQL 2005 running on Windows 2003 SP1

Regards,
John

Error message <ip was changed>
**************************
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 :
http://0.0.0.0/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
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application resulted
in exception. Following failure messages were detected:
+ Downloading
http://0.0.0.0/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
* [7/25/2006 4:23:21 PM] : Activation of
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
started.

ERROR DETAILS
Following errors were detected during this operation.
* [7/25/2006 4:23:24 PM]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://0.0.0.0/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 information is available.


Re: Launching Report Builder via internet John J. Hughes II
7/28/2006 5:36:39 PM
Well it does not seem to be an Internet problem. After checking several
computers on the LAN I have found one XP Pro system that shows the download
box but then nothing, very useful (NOT) and one Win2KPro system that give me
the same network security setting error.

I found a newsgroup message that said turn off the anonymous setting and
another that said turn it on. Neither worked but it was off.

Also found one that said to change to partial trust in the config file, did
not help either.

I am starting to deeply regreat my choice in trying to use this mess.

Regards,
John

RE: Launching Report Builder via internet Dan D.
9/7/2006 6:59:02 AM
John, did you ever resolve your problem? I'm getting ready to install RS2005
and I want to do the same thing.
--
Dan D.


[quoted text, click to view]
Re: Launching Report Builder via internet Dan D.
9/8/2006 7:56:01 AM
I agree. That is the issue we're having. We have a client that wants to have
a few people use ReportBuilder from a site that we host in-house. We're
trying to figure out the security, too. Good luck.

Thanks,
--
Dan D.


[quoted text, click to view]
Re: Launching Report Builder via internet John J. Hughes II
9/8/2006 10:23:44 AM
Basically I was forced to set the report builder directory to anonymous
access. Considering I am running on a test system this was not a major
problem but I would not suggest it for a production system.

Regards,
John

[quoted text, click to view]

Re: Launching Report Builder via internet Karl 140.6
10/1/2006 7:46:01 AM
I figured out how to get this to work. I was having the exact same problems.

1. Connected to the report report server at work over the VPN. My machine
at home is not part of the work domain and I'm not using a RADIUS server.

2. After viewing the http://servername/reports page, I set the server up in
IE zone security to a TRUSTED SITE.

3. Click on the Report Builder icon and presto, work perfect, using the
credentials I entered in the IE login dialog box.

Before I made this report server a trusted site, I was getting those 401
errors.

Hope this helps you too,

Karl

[quoted text, click to view]
Re: Launching Report Builder via internet Dan D.
10/2/2006 7:36:01 AM
Thanks Karl. The particular problem I'm working on doesn't use VPN. I'll keep
this in mind
for the future if we decide to use VPN at another time.
--
Dan D.


[quoted text, click to view]
AddThis Social Bookmark Button