Hi,
I have 4 subreports in a report and adjust thier position well on layout
tag.
Preview on the report designer everything is fine.
But deploy to report server and browse on IE the subreports all on the wrong
position!
How can I resolve this problem?
Thanks for help!
AngiI had the same problem with some of my reports I found out the only way
ot get the layout right is to enter the location for each item on the
report in the location property and " measure/space" so nothing is over
laping. One can begin where one ends but if they overlap the location
it will be moved to onther page. It still looks a little funny on the
browser but it prints perfectly.sql
Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts
Friday, March 30, 2012
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.Are you using a true page header or just a couple of test fields at the top of the page. Click the Report menu and see if you have a Page Header selected.
layout problem
hi all,
i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this:
store day transfers amount
1 1 1 2.50
1 2 5 3.50
2 1 2 1
and i want to put it in a report like this
store monday tuesday
1 1 / 2.50 5 / 3.50
2 2 / 1
i tried with a matrix but the the result wasnt satisifiying. the best one looked like this:
store monday tuesday
1 1 / 2.50
1 5 / 3.50
2 2 / 1
anyone can give a solution or atleast some hints?
drop store to the row group and day to the column group should satisfy your need.Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
Firstly, there is no way to specify that an item should appear on all pages.
However, you do have a few options:
Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.
I wrote to myself your comment about the display in the exporting! Its importent.
Thank,
Roy.|||
A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.
If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.
So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.
The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.
Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.
|||Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.
Nadeem
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
Firstly, there is no way to specify that an item should appear on all pages.
However, you do have a few options:
Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.
I wrote to myself your comment about the display in the exporting! Its importent.
Thank,
Roy.|||
A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.
If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.
So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.
The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.
Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.
|||Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.
Nadeem
sqlLayout of report parameters
Hi all
Is there any way to change the way the report parameters are displayed?
Presently they are just in a tabular format. I am after displaying them as follows:
- - -
__
- -
The horizontal line is there to group the parameters. Is that possible?
Thanks heaps
This is not natively supported. You would need to construct your own prompting area.
Layout margins in cm
Some how layout margins are appearing in cm on report design layout.
I would like them to be setup in inches.
Layout margins come up as inches on other developers machines.
How can I set it up so that I get margins as inches and not cm.
Please help.
TIA..Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||I tried typing inches. But it reverts back to inches after I save, close and
reopen the report.
"Chris Hastings" wrote:
> Hi sqlster,
> You should be able to simply type in 0.5in for a margin.
> Is your language set to "English (United States) in the report properties?
> IT may be defaulting to metric based on that, but in any case, you should be
> able to type "in" after your numbers and it should be in inches.
> I hope that helps!
> Chris
> "sqlster" <nospam@.nospam.com> wrote in message
> news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > Some how layout margins are appearing in cm on report design layout.
> >
> > I would like them to be setup in inches.
> >
> > Layout margins come up as inches on other developers machines.
> >
> > How can I set it up so that I get margins as inches and not cm.
> >
> > Please help.
> >
> > TIA..
>
>|||I meant to say that even if I type inches, it reverts back to cm after I save
and close the report.
TIA...
"sqlster" wrote:
> I tried typing inches. But it reverts back to inches after I save, close and
> reopen the report.
> "Chris Hastings" wrote:
> > Hi sqlster,
> > You should be able to simply type in 0.5in for a margin.
> > Is your language set to "English (United States) in the report properties?
> > IT may be defaulting to metric based on that, but in any case, you should be
> > able to type "in" after your numbers and it should be in inches.
> > I hope that helps!
> > Chris
> >
> > "sqlster" <nospam@.nospam.com> wrote in message
> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > > Some how layout margins are appearing in cm on report design layout.
> > >
> > > I would like them to be setup in inches.
> > >
> > > Layout margins come up as inches on other developers machines.
> > >
> > > How can I set it up so that I get margins as inches and not cm.
> > >
> > > Please help.
> > >
> > > TIA..
> >
> >
> >
> >|||Hi Tia,
I'm sorry, I haven't got a clue. The only thing I can think of is that your
regional options are set to metric on that computer. Have you checked that?
If you go into control panel, regional and Language Options, then
customize, there is a measurement system at the bottom that should be US and
not Metric.
Other than that, make sure the properties of the report have the right
language selected, and if it still happens, I'm at a loss.
I'm sorry I couldn't be of more help...
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:A7D197C8-6223-43A2-AE7D-46D9C1F9F5F4@.microsoft.com...
>I meant to say that even if I type inches, it reverts back to cm after I
>save
> and close the report.
> TIA...
> "sqlster" wrote:
>> I tried typing inches. But it reverts back to inches after I save, close
>> and
>> reopen the report.
>> "Chris Hastings" wrote:
>> > Hi sqlster,
>> > You should be able to simply type in 0.5in for a margin.
>> > Is your language set to "English (United States) in the report
>> > properties?
>> > IT may be defaulting to metric based on that, but in any case, you
>> > should be
>> > able to type "in" after your numbers and it should be in inches.
>> > I hope that helps!
>> > Chris
>> >
>> > "sqlster" <nospam@.nospam.com> wrote in message
>> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
>> > > Some how layout margins are appearing in cm on report design layout.
>> > >
>> > > I would like them to be setup in inches.
>> > >
>> > > Layout margins come up as inches on other developers machines.
>> > >
>> > > How can I set it up so that I get margins as inches and not cm.
>> > >
>> > > Please help.
>> > >
>> > > TIA..
>> >
>> >
>> >
>> >
I would like them to be setup in inches.
Layout margins come up as inches on other developers machines.
How can I set it up so that I get margins as inches and not cm.
Please help.
TIA..Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||I tried typing inches. But it reverts back to inches after I save, close and
reopen the report.
"Chris Hastings" wrote:
> Hi sqlster,
> You should be able to simply type in 0.5in for a margin.
> Is your language set to "English (United States) in the report properties?
> IT may be defaulting to metric based on that, but in any case, you should be
> able to type "in" after your numbers and it should be in inches.
> I hope that helps!
> Chris
> "sqlster" <nospam@.nospam.com> wrote in message
> news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > Some how layout margins are appearing in cm on report design layout.
> >
> > I would like them to be setup in inches.
> >
> > Layout margins come up as inches on other developers machines.
> >
> > How can I set it up so that I get margins as inches and not cm.
> >
> > Please help.
> >
> > TIA..
>
>|||I meant to say that even if I type inches, it reverts back to cm after I save
and close the report.
TIA...
"sqlster" wrote:
> I tried typing inches. But it reverts back to inches after I save, close and
> reopen the report.
> "Chris Hastings" wrote:
> > Hi sqlster,
> > You should be able to simply type in 0.5in for a margin.
> > Is your language set to "English (United States) in the report properties?
> > IT may be defaulting to metric based on that, but in any case, you should be
> > able to type "in" after your numbers and it should be in inches.
> > I hope that helps!
> > Chris
> >
> > "sqlster" <nospam@.nospam.com> wrote in message
> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > > Some how layout margins are appearing in cm on report design layout.
> > >
> > > I would like them to be setup in inches.
> > >
> > > Layout margins come up as inches on other developers machines.
> > >
> > > How can I set it up so that I get margins as inches and not cm.
> > >
> > > Please help.
> > >
> > > TIA..
> >
> >
> >
> >|||Hi Tia,
I'm sorry, I haven't got a clue. The only thing I can think of is that your
regional options are set to metric on that computer. Have you checked that?
If you go into control panel, regional and Language Options, then
customize, there is a measurement system at the bottom that should be US and
not Metric.
Other than that, make sure the properties of the report have the right
language selected, and if it still happens, I'm at a loss.
I'm sorry I couldn't be of more help...
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:A7D197C8-6223-43A2-AE7D-46D9C1F9F5F4@.microsoft.com...
>I meant to say that even if I type inches, it reverts back to cm after I
>save
> and close the report.
> TIA...
> "sqlster" wrote:
>> I tried typing inches. But it reverts back to inches after I save, close
>> and
>> reopen the report.
>> "Chris Hastings" wrote:
>> > Hi sqlster,
>> > You should be able to simply type in 0.5in for a margin.
>> > Is your language set to "English (United States) in the report
>> > properties?
>> > IT may be defaulting to metric based on that, but in any case, you
>> > should be
>> > able to type "in" after your numbers and it should be in inches.
>> > I hope that helps!
>> > Chris
>> >
>> > "sqlster" <nospam@.nospam.com> wrote in message
>> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
>> > > Some how layout margins are appearing in cm on report design layout.
>> > >
>> > > I would like them to be setup in inches.
>> > >
>> > > Layout margins come up as inches on other developers machines.
>> > >
>> > > How can I set it up so that I get margins as inches and not cm.
>> > >
>> > > Please help.
>> > >
>> > > TIA..
>> >
>> >
>> >
>> >
Layout Issue
I have a dataset that goes like this
1
2
3
4
5
6
Using a table control, report preview appears as above.
I want the report to look like
1 2 3
4 5 6
How can I generate a report like this ?
Thanks
Is there any other control I can use to get the desired output.
Thanks !!
Layout incorrect when using ReportViewer
Please can someone help me with this.
I have created a very simple SQL report which has a title, Image, 3 subtitles and some data fields.
When I view it is my VS designer and preview it looks perfect, however when I deploy and view the the report through my ReportViewer control all the labels get moved around and the entire thing is a mess.
If I then export it to PDF it looks perfect again... I am sure I am missing something obvious but I can't find it.
I have done absolutely no expression formatting or coding at all. It's a plain SQL query and plain result textboxes.
Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.
-Aayush
|||
Aayush Goyal wrote:
Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.
-Aayush
It actually turned out to be a combination of two things, I had some overlapping but it still failed after I fixed that. I then checked it in IE and it worked this time.
Now I need to find out why it is not working in Firefox?
Layout for Parameters in Menu Bar
I want to change the layout for the parameters in my menu bar.
I understand that with SP1, I can use style sheets.
1.
I want to group three on top and then but a horizontal bar <hr>
and then I want to put four in the middle - and agin a <hr>
and then three at the bottom.
2.
Also - can I convert the drop down menu to a 'scrolling text box' solme how?
I attempted to edit the MyStyle... but with limited luck.
Any suggestion is appreciated.The customizations that SP1 adds will not let you make these changes. You
can, however, implement your own parameters area and hide the default one.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407211153.48c4e7e0@.posting.google.com...
> I want to change the layout for the parameters in my menu bar.
> I understand that with SP1, I can use style sheets.
> 1.
> I want to group three on top and then but a horizontal bar <hr>
> and then I want to put four in the middle - and agin a <hr>
> and then three at the bottom.
> 2.
> Also - can I convert the drop down menu to a 'scrolling text box' solme
how?
> I attempted to edit the MyStyle... but with limited luck.
> Any suggestion is appreciated.|||Implementing my own parameter area -
- Would SOAP be the preferred way to do that? (Besides URL calls)
- Can I use "Infopath" for making such SOAP calls and redisigning the
parameter forms?
Thxsql
I understand that with SP1, I can use style sheets.
1.
I want to group three on top and then but a horizontal bar <hr>
and then I want to put four in the middle - and agin a <hr>
and then three at the bottom.
2.
Also - can I convert the drop down menu to a 'scrolling text box' solme how?
I attempted to edit the MyStyle... but with limited luck.
Any suggestion is appreciated.The customizations that SP1 adds will not let you make these changes. You
can, however, implement your own parameters area and hide the default one.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407211153.48c4e7e0@.posting.google.com...
> I want to change the layout for the parameters in my menu bar.
> I understand that with SP1, I can use style sheets.
> 1.
> I want to group three on top and then but a horizontal bar <hr>
> and then I want to put four in the middle - and agin a <hr>
> and then three at the bottom.
> 2.
> Also - can I convert the drop down menu to a 'scrolling text box' solme
how?
> I attempted to edit the MyStyle... but with limited luck.
> Any suggestion is appreciated.|||Implementing my own parameter area -
- Would SOAP be the preferred way to do that? (Besides URL calls)
- Can I use "Infopath" for making such SOAP calls and redisigning the
parameter forms?
Thxsql
Layout File for a Fixed-Length Flat File
Hi,
Does the flat file connection format (Fixed Width) have anyway to include a file layout to define the columns. We have different files which contain over a hundred columns.
Or is there any other way to do this. Script Component?
Thanks,
ShantiThe one option is to have a template package and copy the flat file connection from that package to your new package|||If I understand the question, you want to have something like a format file that the flat file connection manager UI can read to create the files.
We don't have a way to do that though we wanted to get it in. If you have hundreds of columns, I suggest writing a quick program that creates such a flat file connection manager using the runtime object model. There's a sample installed that helps you create a package, connection managers, data flow, etc. which might be a good place to start.
regards,
ash|||Yep, Ash you understood correctly. Thanks for the feedback.
Layout
Just a general note. I'm a .NET developer and enjoy the setup that visual
studio gives me when editing and working with my projects. I have a dual
screen setup and like to build my environment around it to increase my
productivity. I noticed that in the release of the new SQL 2005 Management
Studio there are a number of enhancements but one that I'd like is that when
I'm working with a specific table or view or anything, I should be able to
split up the components onto my different screens so that I can maximize my
space. So perhaps to have the query on one dockable window, the table in
another and the SQL in another. If I switch to another query or stored
procedure then all of those windows should be maintained but for the new
information.
Thanks.Send an e-mail to:
sqlwish@.microsoft.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Andrew Middleton" <Andrew Middleton@.discussions.microsoft.com> wrote in
message news:BB7ADCA7-E3CC-4CF9-A779-6ECD2E2EA741@.microsoft.com...
> Just a general note. I'm a .NET developer and enjoy the setup that visual
> studio gives me when editing and working with my projects. I have a dual
> screen setup and like to build my environment around it to increase my
> productivity. I noticed that in the release of the new SQL 2005
Management
> Studio there are a number of enhancements but one that I'd like is that
when
> I'm working with a specific table or view or anything, I should be able to
> split up the components onto my different screens so that I can maximize
my
> space. So perhaps to have the query on one dockable window, the table in
> another and the SQL in another. If I switch to another query or stored
> procedure then all of those windows should be maintained but for the new
> information.
> Thanks.|||> productivity. I noticed that in the release of the new SQL 2005
> Management
> Studio there are a number of enhancements but one that I'd like
Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
studio gives me when editing and working with my projects. I have a dual
screen setup and like to build my environment around it to increase my
productivity. I noticed that in the release of the new SQL 2005 Management
Studio there are a number of enhancements but one that I'd like is that when
I'm working with a specific table or view or anything, I should be able to
split up the components onto my different screens so that I can maximize my
space. So perhaps to have the query on one dockable window, the table in
another and the SQL in another. If I switch to another query or stored
procedure then all of those windows should be maintained but for the new
information.
Thanks.Send an e-mail to:
sqlwish@.microsoft.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Andrew Middleton" <Andrew Middleton@.discussions.microsoft.com> wrote in
message news:BB7ADCA7-E3CC-4CF9-A779-6ECD2E2EA741@.microsoft.com...
> Just a general note. I'm a .NET developer and enjoy the setup that visual
> studio gives me when editing and working with my projects. I have a dual
> screen setup and like to build my environment around it to increase my
> productivity. I noticed that in the release of the new SQL 2005
Management
> Studio there are a number of enhancements but one that I'd like is that
when
> I'm working with a specific table or view or anything, I should be able to
> split up the components onto my different screens so that I can maximize
my
> space. So perhaps to have the query on one dockable window, the table in
> another and the SQL in another. If I switch to another query or stored
> procedure then all of those windows should be maintained but for the new
> information.
> Thanks.|||> productivity. I noticed that in the release of the new SQL 2005
> Management
> Studio there are a number of enhancements but one that I'd like
Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
Laws against copying the whole database structure and scripts.
Hi,
In my experience (and I am not a lawyer so don't quote me on it. If you need that go see one) the principles of copyright law demand that you can prove 'uniqueness' of a product entity to you. To have a script that creates a table of shall we say people in which there might be firstname, surname and so on, in itself would be impossible to prove as 'your' copyright because it is so generic.
If however over a thousand scripts comprising one system if it could be shown that the total number when taken together as a 'whole' shows uniqueness of 'the system' then you may have a case.
The protection of copyright (as distinct from patent) is invoked the minute an object is created by its author it does not require any other action, no court action, patent or anything else from my understanding.
Practically speaking you would need to ensure that 'uniqueness' is in your favour as the author and that this can be 'demonstrated' to a third party/external body (ie a court). Evidentially speaking this could be something as little as posting a document or other crucial proof of its existence, at a point in time, back to yourself on the day the object was created.
The process is always going to be adversarial... the outcome of which would rely on independant adjudication to determine who is the so called 'winner' no doubt from a very costly prosecution or defence of an 'action'
Regards
Jim
I would like to know if there are laws in any state that prohibits anyone from using someone else's database structure and stored procedures. I would like to think that if someone's else got hold of my database and use it and sell a product that uses the structure, will there be a legal basis to sue that person or company?
I know that this sounds a little bit crazy but I want some light regarding this matter.
ThanksDon't let anyone into your database, use passwords to protect it.
Grant rights as appropriate. If you want people to get to a database through application but not directly to a database hash people passwords before login so they wouldnt really know their passwords. Never grant windows authentication.
I never heard of such law. If you let person into your database and let them view everything they probably can copy it.
You have to have patent for your work to protect your copy rights by law.
Good Luck.|||
Quote:
Originally Posted by lihard
Hi,
I would like to know if there are laws in any state that prohibits anyone from using someone else's database structure and stored procedures. I would like to think that if someone's else got hold of my database and use it and sell a product that uses the structure, will there be a legal basis to sue that person or company?
I know that this sounds a little bit crazy but I want some light regarding this matter.
Thanks
In my experience (and I am not a lawyer so don't quote me on it. If you need that go see one) the principles of copyright law demand that you can prove 'uniqueness' of a product entity to you. To have a script that creates a table of shall we say people in which there might be firstname, surname and so on, in itself would be impossible to prove as 'your' copyright because it is so generic.
If however over a thousand scripts comprising one system if it could be shown that the total number when taken together as a 'whole' shows uniqueness of 'the system' then you may have a case.
The protection of copyright (as distinct from patent) is invoked the minute an object is created by its author it does not require any other action, no court action, patent or anything else from my understanding.
Practically speaking you would need to ensure that 'uniqueness' is in your favour as the author and that this can be 'demonstrated' to a third party/external body (ie a court). Evidentially speaking this could be something as little as posting a document or other crucial proof of its existence, at a point in time, back to yourself on the day the object was created.
The process is always going to be adversarial... the outcome of which would rely on independant adjudication to determine who is the so called 'winner' no doubt from a very costly prosecution or defence of an 'action'
Regards
Jim
Launching Web Page From SQL
Hello All,
I'm not very knowledgable about SQL server so I'm not quite sure if this is possible. I want a scheduled task to be ran everyday. (Querying the Database and such). If a certain parameter is met I want a webpage, w/ code behind that will send an email, to be launched.
Is there any way to launch a web page from SQL??
Thanks in advance,
Kyle Landis
Do you want web page to send e-mail only? The SQL Server cansend e-mail too.Launching the Reports From Browser
Hi friends,
We have developed the Reports using SQL Server Reporting Services 2005.
In order to make our all reports dynamic we are referancing DLL in all our reports.
That DLL we have pasted in
D:\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies
So when we observer the reports from Preview tab then we can see the effect of our DLL and all reports are working fine.
Now we want to launch all reports on browser. So we are giving the URL path as
http://localhost/ReportServer
But as per the SQL Server 2005 Reporting Services by Brian Larson we have pasted the following code into rssrvpolicy.config file
<CodeGroup
class ="UnionCodeGroup"
version="1"
PermissionSetName="Execution"
Name="WeatherWebServiceCodeGroup"
Description ="Code group for the Weather Web Service">
<IMembershipCondition Class ="UrlMembershipCodndion"
version ="1"
Url="http://localhost/ReportServer"/>
</CodeGroup>
and second code is
<CodeGroup
class="UnionCodeGroup"
version ="1"
PermissionSetName="FullTrust"
Name="MSSQLRSCodeGroup"
Description="Code group for the MS SQL RS Book Custom Assemblies">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100B9F74F2D5B0AAD33AA619B00D7BB8B0F7678393A0F4CD586C9036D72455F8D1E85BF635C9FB1DA9817DD0F751DCEE77D9A47959E8728028B9B6CC7C25EB1E59CB3DE01BB516D46FC6AC6AF27AA6E71B65F6AB91B9576886F2EF39417F17B567AD200E151FC744C6DA72FF5882461E6CA786EB2997FA968302B7B2F24BDBFF7A5"/>
</CodeGroup>
so now we are checking the site
http://localhost/ReportServer
so we are getting following error
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Source Error:
Line 27: <assemblies> Line 28: <clear /> Line 29: <add assembly="ReportingServicesWebServer" /> Line 30: </assemblies> Line 31: </compilation>Source File: D:\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
so where i am going wrong ?
can anyone help me out plz ?
anyhelp will be greatly appreciated
sandy
You have some typos in the first CodeGroup element:
<IMembershipCondition class ="UrlMembershipCondition"
You don't need this element anyway unless your DLL accesses a web service. In the second CodeGroup, it looks like PublicKeyBlob is copied from the book. Make sure that it matches the public key of your own assembly.
-Albert
|||hi Albert,
thx for ur help. First that I did is I removed the following code
<CodeGroup
class ="UnionCodeGroup"
version="1"
PermissionSetName="Execution"
Name="WeatherWebServiceCodeGroup"
Description ="Code group for the Weather Web Service">
<IMembershipCondition Class ="UrlMembershipCodndion"
version ="1"
Url="http://localhost/ReportServer"/>
</CodeGroup>
so now I am not getting the configuration error.
Secondly whatever you said that I simply copied the Public Key Blob so now I have replaced it with my current DLL Public Key.
But Albert still I cant see the effect of my function on URL ie browser.
I can see the same effect on my Preview Tab but cant on Browser so where I am going wrong ?
--sandy
|||The easiest way for testing is to add the following:<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyCodeGroup2"
Description="Code group for my data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\[your assembly].dll"
/>
</CodeGroup>
just below the
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
entry.
If that works you can try to reduce the Permissions and try the Public Key-Stuff..
Have you looked at the logfiles? Sometimes you need to assert the permissions for other dlls that you have referenced..
|||
Hi binni,
The code which ur talking about , I have already incorported in my rsspolicy.config file.
Secondly I made sure that my current assembly is not using any other assembly also.
Then I checked all log file which are in
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
there also I didnt find any log file saying this problem.
Still I cant able to see the effect of my function on Browser.
-sandyee
|||When you say you don't see the effect of your function, does that mean you see an error message? How do you know it is not working?
-Albert
|||Hi Friends,
what we have done is that first of all we have stored all the values in one table like background color , forground colro , font size , font weight etc. Now in our function we are refering that table. And whatever values we have stored in the table that values function takes and set for the report. So when we are saying font size of 12 and when we apply that function to the Report Header , Report Header will be of font size 12 , and this effect we can see in Preview tab. But when see the report on browser Report Header is of font 8 only.
This I exactly mean by function not working,
Sandeep
|||If the report is running and is not producing any errors, then either your code is not being called, or it's being called and not producing the correct result. Have you checked your code to make sure there are no problems? As a last resort you could try debugging the ASP.Net process.
-Albert
|||Hi friends,
As my reports are working fine on Browser do I need to make any changes in any other configuartion file other that ReportServer config file (rssvpolicy.config)
for eg do I need to make any changes in Report Manager Config file (rsmgrpolicy.config) ?
-sandeep
|||No, you do not need to make any changes in Report Manager config.
-Albert
|||To provide a solution for other people:Maybe sandeep has forgotten the:
<Assembly: System.Security.AllowPartiallyTrustedCallers()> VB.NET
[Assembly: System.Security.AllowPartiallyTrustedCallers] C#.NET
for his assembly.
I got the same problem: my assembly just didn't work and the ReportServer-logfiles didn't contain any information of the error! Visual Studio 2005 showed the error, that my assembly doesn't allow partially trusted caller.
sql
Launching SQL Server Management Studio
Okay forgive my ignorance. I just installed the SQL Server Management Studio Express, now how the heck do I launch it? :)
hi,
if you correctly installed it, you shoud find, in the Start->Programs->Microsoft SQL Server 2005 folder the SQL Server Management Studio entry..
regards
|||Thanks. It appeared, but only after I rebooted.
Thanks again! :)
Ed
Launching Reports on Browser with Custom Assembly
Hi friends,
We have developed the Reports using SQL Server Reporting Services 2005.
In order to make our all reports dynamic we are refering DLL in all our reports.
That DLL we have pasted in
C:\Program Files \Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies
So when we observer the reports from Preview tab then we can see the effect of our DLL and all reports are working fine.
Now we want to launch all reports on browser so we have pasted the following code into rssrvpolicy.config file
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="Wizard_1"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100DD11C5519C419099881AE462DC4D257CF2A1C126A3D06FEDFA1BF89A84993ADCC495032E92A1CB28A6400FE2D5667358155D6D35637DAB62CE95995B1FC66D23E2C0664AE8E2021BE66080DA0E5972C18B58E658470B82FC14D6E575EC8903367E16C16B168A90A6D8B20A9D9F91ED7CF95A45FA52435F76058D4F32807F9CF8"
AssemblyVersion="1.0.0.0"/>
and sencond code is
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyNewCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\ReportStyle.dll"/>
</CodeGroup>
so now we are checking the site
http://localhost/ReportServer
we can't see the effect of our DLL. So where excatly I am making mistake ?
This is now becoming very critical issue for our project so any help will be grately appreciated.
-- sandeep -
Hi,
I've a similar scenario right now. The problem seems to be the signing of the assembly!!! I don't know if this is one of MS great "it's not a bug, it's a feature"-Stuff, but try:
-DO NOT sign the assembly!
-delete the code-group with strongNameMembership (the first one) and only use the UrlMembership..
-have fun
@.MS: ReportServer does not throw any error, it just displays "#Error" if you use a method of a signed assembly in a textfield. If you run the report in local debug you get:
"Warning: Der Value-Ausdruck für das Textfeld-Objekt 'textbox1' enth?lt einen Fehler: Die Assembly l?sst keine Aufrufer zu, die nicht voll vertrauenswürdig sind. (rsRuntimeErrorInExpression)".
In english something like:
"Warning: The Value-Expression for textfield 'textbox1' contains an error: the assembly doesn't accept callers without fulltrust"
Benni
Got it working?
edit:
After searching the internet I found what the error message means and that this is really rather a feature than a bug. So just add:
<Assembly: System.Security.AllowPartiallyTrustedCallers()> (VB)
[Assembly: System.Security.AllowPartiallyTrustedCallers] (C#)
to your signed Assembly..
But I think it's still a bug that the ReportServer doesn't write the cause of the error to the logfiles..
Launching Report Builder via internet
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
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
Launching and monitoring SSIS packages from a web app
Has anybody developed a ASP.Net app that interfaces to SSIS? If so, what was your experience? Any pitfalls, tips, etc? We have a requirement to launch and monitor SSIS packages via a web interface.I've got the same question...
Subscribe to:
Posts (Atom)