sql large inserts: via

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

Friday, March 30, 2012

Launching Report Builder via internet

Launch Subscription via VB Code

Friday, March 23, 2012

last time someone connected to a database

sql large inserts

Blog Archive

About Me