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.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|||John, did you ever resolve your problem? I'm getting ready to install RS2005
and I want to do the same thing.
--
Dan D.
"John J. Hughes II" wrote:
> 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.
>
>|||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
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> John, did you ever resolve your problem? I'm getting ready to install
> RS2005
> and I want to do the same thing.
> --
> Dan D.
>
> "John J. Hughes II" wrote:
>> 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.
>>
>>|||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.
"John J. Hughes II" wrote:
> 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
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > John, did you ever resolve your problem? I'm getting ready to install
> > RS2005
> > and I want to do the same thing.
> > --
> > Dan D.
> >
> >
> > "John J. Hughes II" wrote:
> >
> >> 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.
> >>
> >>
> >>
> >>
>
>|||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
"Dan D." wrote:
> 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.
>
> "John J. Hughes II" wrote:
> > 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
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > > John, did you ever resolve your problem? I'm getting ready to install
> > > RS2005
> > > and I want to do the same thing.
> > > --
> > > Dan D.
> > >
> > >
> > > "John J. Hughes II" wrote:
> > >
> > >> 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.
> > >>
> > >>
> > >>
> > >>
> >
> >
> >|||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.
"Karl 140.6" wrote:
> 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
> "Dan D." wrote:
> > 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.
> >
> >
> > "John J. Hughes II" wrote:
> >
> > > 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
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > > > John, did you ever resolve your problem? I'm getting ready to install
> > > > RS2005
> > > > and I want to do the same thing.
> > > > --
> > > > Dan D.
> > > >
> > > >
> > > > "John J. Hughes II" wrote:
> > > >
> > > >> 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.
> > > >>
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >sql
Showing posts with label copy. Show all posts
Showing posts with label copy. Show all posts
Friday, March 30, 2012
Wednesday, March 7, 2012
Large Text FIeld: Easy Way to Copy and Paste Into?
I have a column that I want to store the entire contents of an XML
file. For testing purposes before our .Net program is written, I would
like to populate that column in a few rows with some actual
text-representation of XML files. I thought I would just open the XML
file in a text editor (ultraedit) and then paste it in somehow.
Normaly I can go into Enterprise Manager and paste information into
columns from other apps - as long as the column can accept the data, no
problem.
However, there seems to be a limit on how much text I can paste into a
column via Enterprise Manager. It's not based on linefeeds
necessarily, because it handles multiple lines OK, just as long as you
don't try to paste too much.
Is there any other tool that I could use to slam some data quickly into
some columns. Insert statements using Query Analyzer are a pain (not
to mention needing to worry about apostrophes, etc.) - I was looking
for something rather visual and quick.
I tried this QA Lite tool which showed some promise
(http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
be similar there as well...
Any hints?
Thanks,
spedlists@.erstads.com
Try bulk insert.
It's just a matter of setting the end tags for the entries.
There are a few bugs associated with bulk inserting into text column though
so post again if you have problems - it might not be your code.
"Sped" wrote:
> I have a column that I want to store the entire contents of an XML
> file. For testing purposes before our .Net program is written, I would
> like to populate that column in a few rows with some actual
> text-representation of XML files. I thought I would just open the XML
> file in a text editor (ultraedit) and then paste it in somehow.
> Normaly I can go into Enterprise Manager and paste information into
> columns from other apps - as long as the column can accept the data, no
> problem.
> However, there seems to be a limit on how much text I can paste into a
> column via Enterprise Manager. It's not based on linefeeds
> necessarily, because it handles multiple lines OK, just as long as you
> don't try to paste too much.
> Is there any other tool that I could use to slam some data quickly into
> some columns. Insert statements using Query Analyzer are a pain (not
> to mention needing to worry about apostrophes, etc.) - I was looking
> for something rather visual and quick.
> I tried this QA Lite tool which showed some promise
> (http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
> be similar there as well...
> Any hints?
> Thanks,
> spedlists@.erstads.com
>
file. For testing purposes before our .Net program is written, I would
like to populate that column in a few rows with some actual
text-representation of XML files. I thought I would just open the XML
file in a text editor (ultraedit) and then paste it in somehow.
Normaly I can go into Enterprise Manager and paste information into
columns from other apps - as long as the column can accept the data, no
problem.
However, there seems to be a limit on how much text I can paste into a
column via Enterprise Manager. It's not based on linefeeds
necessarily, because it handles multiple lines OK, just as long as you
don't try to paste too much.
Is there any other tool that I could use to slam some data quickly into
some columns. Insert statements using Query Analyzer are a pain (not
to mention needing to worry about apostrophes, etc.) - I was looking
for something rather visual and quick.
I tried this QA Lite tool which showed some promise
(http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
be similar there as well...
Any hints?
Thanks,
spedlists@.erstads.com
Try bulk insert.
It's just a matter of setting the end tags for the entries.
There are a few bugs associated with bulk inserting into text column though
so post again if you have problems - it might not be your code.
"Sped" wrote:
> I have a column that I want to store the entire contents of an XML
> file. For testing purposes before our .Net program is written, I would
> like to populate that column in a few rows with some actual
> text-representation of XML files. I thought I would just open the XML
> file in a text editor (ultraedit) and then paste it in somehow.
> Normaly I can go into Enterprise Manager and paste information into
> columns from other apps - as long as the column can accept the data, no
> problem.
> However, there seems to be a limit on how much text I can paste into a
> column via Enterprise Manager. It's not based on linefeeds
> necessarily, because it handles multiple lines OK, just as long as you
> don't try to paste too much.
> Is there any other tool that I could use to slam some data quickly into
> some columns. Insert statements using Query Analyzer are a pain (not
> to mention needing to worry about apostrophes, etc.) - I was looking
> for something rather visual and quick.
> I tried this QA Lite tool which showed some promise
> (http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
> be similar there as well...
> Any hints?
> Thanks,
> spedlists@.erstads.com
>
Large text block into ntext
How can I get a block of text into an ntext field. Have tried copy and paste
out of Notepad into field in Enterprise Manager? But it truncates.
Is there a command line that will put text into specific field in specific
table?
Use the ado stream object or textcopy
have a look at this link for more info on how to do this.
http://www.indexserverfaq.com/SQLLoadADO.htm
http://www.indexserverfaq.com/TextCopy.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
news:C3C68066-04B7-4C81-A7C1-E95EF0FC4E8A@.microsoft.com...
> How can I get a block of text into an ntext field. Have tried copy and
paste
> out of Notepad into field in Enterprise Manager? But it truncates.
> Is there a command line that will put text into specific field in specific
> table?
>
out of Notepad into field in Enterprise Manager? But it truncates.
Is there a command line that will put text into specific field in specific
table?
Use the ado stream object or textcopy
have a look at this link for more info on how to do this.
http://www.indexserverfaq.com/SQLLoadADO.htm
http://www.indexserverfaq.com/TextCopy.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
news:C3C68066-04B7-4C81-A7C1-E95EF0FC4E8A@.microsoft.com...
> How can I get a block of text into an ntext field. Have tried copy and
paste
> out of Notepad into field in Enterprise Manager? But it truncates.
> Is there a command line that will put text into specific field in specific
> table?
>
Subscribe to:
Posts (Atom)