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
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...
Launching a Report From an Application
We are trying to launch a report from an application. All that happens is
that the applciation gives the user a link that it dynamically builds,
populating all of the parameters for the user.
Currently the link launches the report, but we wanted two things to happen.
We did not want to show the parameters to the user from within the report and
we also wanted to kkep the tool bar, the green spirally thing when loadign
and the drop downs for exporting.
But it seems like you can either have all that studd on the toolbar and be
able to see the parameters or don't see the parameters and don't see the
toolb bar of green spirally thing.
Any suggestions here? I want to see the toolbar, but I do not want to see
the parameters.Have you tried using
&rc:Toolbar=true&rc:Parameters=false
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:393DA10F-2182-4CA0-B5FD-C617C870384E@.microsoft.com...
> We are trying to launch a report from an application. All that happens is
> that the applciation gives the user a link that it dynamically builds,
> populating all of the parameters for the user.
> Currently the link launches the report, but we wanted two things to
> happen.
> We did not want to show the parameters to the user from within the report
> and
> we also wanted to kkep the tool bar, the green spirally thing when loadign
> and the drop downs for exporting.
> But it seems like you can either have all that studd on the toolbar and be
> able to see the parameters or don't see the parameters and don't see the
> toolb bar of green spirally thing.
> Any suggestions here? I want to see the toolbar, but I do not want to see
> the parameters.
that the applciation gives the user a link that it dynamically builds,
populating all of the parameters for the user.
Currently the link launches the report, but we wanted two things to happen.
We did not want to show the parameters to the user from within the report and
we also wanted to kkep the tool bar, the green spirally thing when loadign
and the drop downs for exporting.
But it seems like you can either have all that studd on the toolbar and be
able to see the parameters or don't see the parameters and don't see the
toolb bar of green spirally thing.
Any suggestions here? I want to see the toolbar, but I do not want to see
the parameters.Have you tried using
&rc:Toolbar=true&rc:Parameters=false
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:393DA10F-2182-4CA0-B5FD-C617C870384E@.microsoft.com...
> We are trying to launch a report from an application. All that happens is
> that the applciation gives the user a link that it dynamically builds,
> populating all of the parameters for the user.
> Currently the link launches the report, but we wanted two things to
> happen.
> We did not want to show the parameters to the user from within the report
> and
> we also wanted to kkep the tool bar, the green spirally thing when loadign
> and the drop downs for exporting.
> But it seems like you can either have all that studd on the toolbar and be
> able to see the parameters or don't see the parameters and don't see the
> toolb bar of green spirally thing.
> Any suggestions here? I want to see the toolbar, but I do not want to see
> the parameters.
Launch Subscription via VB Code
I have created a subscription via Report Manager & would like to launch it
via vb code or rs script on any given date or time. That is, even though the
subcription may have a set date/time, via CODe I would launch it & modified
its date & time as necessary.
--
EdgarNot particularly elegant, but you can do this in the following way:
1) create a shared schedule that fires once, in the past. Save the Schedule
ID you get back
2) create a subscription that is triggered by this shared schedule.
3) use some code to call the FireEvent method and submit the
TimedSubscription event as the EventType and the schedule ID from (1) as the
MatchData.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:045CCA4A-B712-489D-8609-068642154128@.microsoft.com...
>I have created a subscription via Report Manager & would like to launch it
> via vb code or rs script on any given date or time. That is, even though
> the
> subcription may have a set date/time, via CODe I would launch it &
> modified
> its date & time as necessary.
> --
> Edgar|||Lukasz,
I tried your solution & everything works fine except that I get an error
saying that the subscription cannot be found. Even though the subscription
ID is listed within SQL Server. Below is the output I get with the error. I
also Echo the subscription ID & the line so I can see the ID which later I
find in the subscriptions table in SQL Svr. Is there a particular way to
format the subscriptionID in order for RS to see it?
The Current Subscription is: 0d49d301-ecd8-43fc-8319-21ec19e82f77
==========================================System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The subsc
ription cannot be found. The subscription identifier that is provided to an
operation cannot be located in the report server database. -->
Microsoft.ReportingServices.Diagnostics.Utilities.Subscrip
tionNotFoundException: The subscription cannot be found. The subscription
identifier that is provid
ed to an operation cannot be located in the report server database.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, String& Owner, ExtensionSettings& ExtensionSettings, String&
Description, ActiveState& A
ctive, String& Status, String& EventType, String& MatchData,
ParameterValue[]& Parameters)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message,
WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] param
eters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, ExtensionSettings& ExtensionSettings, String& Description,
ActiveState& Active, String&
Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ____ScriptClass.Main()
The command completed successfullysql
via vb code or rs script on any given date or time. That is, even though the
subcription may have a set date/time, via CODe I would launch it & modified
its date & time as necessary.
--
EdgarNot particularly elegant, but you can do this in the following way:
1) create a shared schedule that fires once, in the past. Save the Schedule
ID you get back
2) create a subscription that is triggered by this shared schedule.
3) use some code to call the FireEvent method and submit the
TimedSubscription event as the EventType and the schedule ID from (1) as the
MatchData.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:045CCA4A-B712-489D-8609-068642154128@.microsoft.com...
>I have created a subscription via Report Manager & would like to launch it
> via vb code or rs script on any given date or time. That is, even though
> the
> subcription may have a set date/time, via CODe I would launch it &
> modified
> its date & time as necessary.
> --
> Edgar|||Lukasz,
I tried your solution & everything works fine except that I get an error
saying that the subscription cannot be found. Even though the subscription
ID is listed within SQL Server. Below is the output I get with the error. I
also Echo the subscription ID & the line so I can see the ID which later I
find in the subscriptions table in SQL Svr. Is there a particular way to
format the subscriptionID in order for RS to see it?
The Current Subscription is: 0d49d301-ecd8-43fc-8319-21ec19e82f77
==========================================System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The subsc
ription cannot be found. The subscription identifier that is provided to an
operation cannot be located in the report server database. -->
Microsoft.ReportingServices.Diagnostics.Utilities.Subscrip
tionNotFoundException: The subscription cannot be found. The subscription
identifier that is provid
ed to an operation cannot be located in the report server database.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, String& Owner, ExtensionSettings& ExtensionSettings, String&
Description, ActiveState& A
ctive, String& Status, String& EventType, String& MatchData,
ParameterValue[]& Parameters)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message,
WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] param
eters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, ExtensionSettings& ExtensionSettings, String& Description,
ActiveState& Active, String&
Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ____ScriptClass.Main()
The command completed successfullysql
Launch SSIS package with SQL Event
Is it possible to launch an SSIS package after a SQL event takes place? I need to run a package after a customer order is placed. Can a trigger in SQL launch the package?
You can use xp_cmdshell to call DTEXEC. You could also set up a job for the package and call sp_start_job.
See this link for some more detail and some other options: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
Launch SQL 2005 Database Tuning Advisor
we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/b6160e7593b8dda0/052524332db36557?lnk=st&q=%22database+engine+tuning+advisor%22&rnum=2&hl=en#052524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
> Please advise.
> Thanks
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/b6160e7593b8dda0/052524332db36557?lnk=st&q=%22database+engine+tuning+advisor%22&rnum=2&hl=en#052524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
> Please advise.
> Thanks
Launch SQL 2005 Database Tuning Advisor
we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFlags
\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/micr...52524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFla
gs\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
> Please advise.
> Thanks
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFlags
\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/micr...52524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFla
gs\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
> Please advise.
> Thanks
launch report manager
How do I launch report manager in SQL 2005? Thanks.
Use a web browser. The URL to use in the browser is configured in the "Reporting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>
sql
Use a web browser. The URL to use in the browser is configured in the "Reporting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>
sql
launch report manager
How do I launch report manager in SQL 2005? Thanks.Use a web browser. The URL to use in the browser is configured in the "Repor
ting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program g
roup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...[vbcol
=seagreen]
> How do I launch report manager in SQL 2005? Thanks.
>[/vbcol]
ting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program g
roup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...[vbcol
=seagreen]
> How do I launch report manager in SQL 2005? Thanks.
>[/vbcol]
launch report manager
How do I launch report manager in SQL 2005? Thanks.Use a web browser. The URL to use in the browser is configured in the "Reporting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>
Launch Report Builder from Sharepoint
How do you launch report builder from sharepoint site? Does sharepoint site supports report builder?
The launch point for Report Builder is just a URL, which you can place on any web page. The URL has the form:
http://<servername>/reportserver/reportbuilder/reportbuilder.application
Hope that helps...
|||Yes!! This is exactly what I want. Thanks much!!launch report builder from C# app
Hi friends
how can i launcg report builder from a C# app ?
i know i can use following url but need to know how to execute that url to bring up the report builder
http://<localhost>/reportserver/reportbuilder/reportbuilder.application
how can i launcg report builder from a C# app ?
i know i can use following url but need to know how to execute that url to bring up the report builder
http://<localhost>/reportserver/reportbuilder/reportbuilder.application
Thanks for your help
finally i found how to do that
WebBrowser wb = new WebBrowser();
wb.Navigate("http://<localhost>/reportserver/reportbuilder/reportbuilder.application");
that works nicely.
one more question on this one ,does anybody know how to select report model also by default instead of user choosing after launching report builder ?|||
Please see this blog post:
http://blogs.msdn.com/bobmeyers/archive/2006/01/24/517083.aspx
Note the issue mentioned in the comments.
|||Thank you very much Bob.
I've been searching for a solution for this one. Thanks again.
Launch of SQL 2005.. any live conference broadcast ?
With the launch tomorrow or today in some countries, is there any live event
that may be broadcasted to people that cannot attend ?http://www.microsoft.com/emea/steveballmerlive/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>sql
that may be broadcasted to people that cannot attend ?http://www.microsoft.com/emea/steveballmerlive/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>sql
Launch of SQL 2005.. any live conference broadcast ?
With the launch tomorrow or today in some countries, is there any live event
that may be broadcasted to people that cannot attend ?http://www.microsoft.com/emea/steveballmerlive/
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>
that may be broadcasted to people that cannot attend ?http://www.microsoft.com/emea/steveballmerlive/
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>
Launch of SQL 2005.. any live conference broadcast ?
With the launch tomorrow or today in some countries, is there any live event
that may be broadcasted to people that cannot attend ?
http://www.microsoft.com/emea/steveballmerlive/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>
that may be broadcasted to people that cannot attend ?
http://www.microsoft.com/emea/steveballmerlive/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>
Launch exe using trigger within DTS
The following has been posted on another thread and I would like to know if anyone can tell me if and how this could be done. I'm a complete novice when it come to DTS.
TIA.
"I would investigate having the .exe be part of a "job"
under DTS Local Packages and having the trigger start
that job - not really sure if this is possible."You can start an exe via
exec master..xp_cmdshell 'xxxx.exe'
You can start a dts package in the same way by using dtsrun.exe if you really want to use dts - but that would be starting an app to run an app.
I would not advise doing this from a trigger though. Better to put the request into a table and have a scheduled task run the exe.
Note that the exe must not have any user interaction as there is no display or input stream attached|||Originally posted by nigelrivett
You can start an exe via
exec master..xp_cmdshell 'xxxx.exe'
Thanks Nigel
Do I just add this at the end of the trigger as per below ? Pretty new to this stuff !
CREATE TRIGGER tr_owner_coord_email ON dbo.ownership
after insert as
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
update ownership
SET coordemail = (select con.emailaddress
from contact as con with (nolock)
where coordinator = (con.forename + ' ' + con.surname))
exec master..xp_cmdshell 'xxxx.exe'|||Originally posted by nigelrivett
I would not advise doing this from a trigger though. Better to put the request into a table and have a scheduled task run the exe.
Take Nigels advice...
Do you know what a trigger does?
If you insert 1000 rows, it will kick off 1000 times...
Is that what you want?
Also you're not referencing the virtual inserted table...
You could probably make your update a default contraint...|||Originally posted by Brett Kaiser
Take Nigels advice...
Do you know what a trigger does?
If you insert 1000 rows, it will kick off 1000 times...
Is that what you want?
Also you're not referencing the virtual inserted table...
You could probably make your update a default contraint...
If you insert 1000 rows at once - trigger will fire once, if row by row - trigger will fire for every insert.|||There is not going to be heavy demand with the trigger. It will probably only be average of 60-80 rows inserted per day.
The other way I was handling this was with a timer in Vb but max interval on that is 60 seconds so even more overhead.
I would prefer to do it as Nigel suggested but need more detailed info being a newbie. I just wanted to know if there is a way the exe can be launched after the trigger had been executed. I am open to all suggestions and as was put in the original post someone thought a DTS package could launch the exe after the trigger. That way it would only be run 60-80 times per day rather than over 500 times pd using vb timer.|||Originally posted by snail
If you insert 1000 rows at once - trigger will fire once, if row by row - trigger will fire for every insert.
So True....my bad...|||PMJI, be careful withn the trigger.
While the trigger runs, the transaction is not yet commited. The database keeps exclusive locks on the row or page you are about to insert into. If you have a multi-statement transaction, then there are even more locks, preventing everyone else to access your records.
Now imagine you put some long-running command in the trigger. AFAIK, xp_cmdshell runs synchronously, i.e. it waits untill your EXE completes. All the while your records are locked. You may not worry about concurrency, if this is a single-user application or some background drip-feed.
But if you intend to connect from the EXE back into Sql Server, then that is a separate connection. The EXE won't see the record just being inserted by the trigger. If the EXE attempts to Select one of the locked records, you may end up waiting forever ( Exe waits for Trigger to release the locks, while Trigger waits for Exe to complete ). Sounds like fun.
As about integrity: it is nice to know you can roll back a multi-statement transaction, including the efefcts of triggers. But xp_cmdshell is outside the Rbdms, so it won't roll back at all.
I realise triggers are an attractive thought, to streamline the chain of command, and to reduce the number of moving parts. In practice, they don't perform this role too well.
Andrew Schonberger
TIA.
"I would investigate having the .exe be part of a "job"
under DTS Local Packages and having the trigger start
that job - not really sure if this is possible."You can start an exe via
exec master..xp_cmdshell 'xxxx.exe'
You can start a dts package in the same way by using dtsrun.exe if you really want to use dts - but that would be starting an app to run an app.
I would not advise doing this from a trigger though. Better to put the request into a table and have a scheduled task run the exe.
Note that the exe must not have any user interaction as there is no display or input stream attached|||Originally posted by nigelrivett
You can start an exe via
exec master..xp_cmdshell 'xxxx.exe'
Thanks Nigel
Do I just add this at the end of the trigger as per below ? Pretty new to this stuff !
CREATE TRIGGER tr_owner_coord_email ON dbo.ownership
after insert as
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
update ownership
SET coordemail = (select con.emailaddress
from contact as con with (nolock)
where coordinator = (con.forename + ' ' + con.surname))
exec master..xp_cmdshell 'xxxx.exe'|||Originally posted by nigelrivett
I would not advise doing this from a trigger though. Better to put the request into a table and have a scheduled task run the exe.
Take Nigels advice...
Do you know what a trigger does?
If you insert 1000 rows, it will kick off 1000 times...
Is that what you want?
Also you're not referencing the virtual inserted table...
You could probably make your update a default contraint...|||Originally posted by Brett Kaiser
Take Nigels advice...
Do you know what a trigger does?
If you insert 1000 rows, it will kick off 1000 times...
Is that what you want?
Also you're not referencing the virtual inserted table...
You could probably make your update a default contraint...
If you insert 1000 rows at once - trigger will fire once, if row by row - trigger will fire for every insert.|||There is not going to be heavy demand with the trigger. It will probably only be average of 60-80 rows inserted per day.
The other way I was handling this was with a timer in Vb but max interval on that is 60 seconds so even more overhead.
I would prefer to do it as Nigel suggested but need more detailed info being a newbie. I just wanted to know if there is a way the exe can be launched after the trigger had been executed. I am open to all suggestions and as was put in the original post someone thought a DTS package could launch the exe after the trigger. That way it would only be run 60-80 times per day rather than over 500 times pd using vb timer.|||Originally posted by snail
If you insert 1000 rows at once - trigger will fire once, if row by row - trigger will fire for every insert.
So True....my bad...|||PMJI, be careful withn the trigger.
While the trigger runs, the transaction is not yet commited. The database keeps exclusive locks on the row or page you are about to insert into. If you have a multi-statement transaction, then there are even more locks, preventing everyone else to access your records.
Now imagine you put some long-running command in the trigger. AFAIK, xp_cmdshell runs synchronously, i.e. it waits untill your EXE completes. All the while your records are locked. You may not worry about concurrency, if this is a single-user application or some background drip-feed.
But if you intend to connect from the EXE back into Sql Server, then that is a separate connection. The EXE won't see the record just being inserted by the trigger. If the EXE attempts to Select one of the locked records, you may end up waiting forever ( Exe waits for Trigger to release the locks, while Trigger waits for Exe to complete ). Sounds like fun.
As about integrity: it is nice to know you can roll back a multi-statement transaction, including the efefcts of triggers. But xp_cmdshell is outside the Rbdms, so it won't roll back at all.
I realise triggers are an attractive thought, to streamline the chain of command, and to reduce the number of moving parts. In practice, they don't perform this role too well.
Andrew Schonberger
Launch DTS with OLAP from .net application
Hi,
with reference to the following thread:
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=740855&isthread=false&siteid=1&authhash=775a583435c503730bf96695fe78ffc77f04a290&ticks=632942355374528292
Which in summary is that I am trying to execute DTS packages containing OLAP tasks to process cubes from an application. It hangs and fails after an hour and some minutes.
the code :
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref VarPersistStgOfHost);
package.Execute();
I have launched the DTS on command prompt using DTSRUN on the computer I am trying to execute my code, and it executes marvellously.
DTSRUN can also execute a DTS on another physical server Alpha for instance which process a cube of AS2000 found on another physical server Beta for instance.
Since I need to check that each steps have been executed properly and that running DTSRUN from the application is not a possibility to do so, I need a way to be able to launch the DTS and get to know which steps is failing. the above code is supposingly a way but its failing on LoadFromSQLServer() method.
I am using SQL Server 2000 and AS2000 and .net 1.1 (modifying a legacy system to enable the above facility).
Any views please?
Thanks
Is there any error message?
If so, can you paste here its full text (replacing any confidential information like server names, IP addresses, user names, passwords etc.)?
|||There is no error page. The steps in the package are with status "failed". Thats it.|||
I am moving this to the "SQL Server Integration Services" forum (successor to DTS), which may be able to help troubleshooting.
|||
Failing on the LoadFromSQLServer method should be quick, and I would expect an exception.
The Execute on the other hand will not raise an exception. Use package logging and/or implement the events interface to get more detail of tasks that fail in the package.
If the LoadFromSqlServer fails, perhaps try another storage location just to see if you can isolate the problem for now.
|||HTH.
Dim EventsSSIS As Eventos
EventsSSIS = New Eventos()
sResultDts = pkg.Execute(Nothing, Nothing, EventsSSIS, Nothing, Nothing)
..
..
..
Public Class Eventos
Implements IDTSEvents
Sub OnExecutionStatusChanged(ByVal exec As Executable, ByVal newStatus As DTSExecStatus, ByRef fireAgain As Boolean) Implements IDTSEvents.OnExecutionStatusChanged
End Sub
Sub OnBreakpointHit(ByVal breakpointSite As IDTSBreakpointSite, ByVal breakpointTarget As BreakpointTarget) Implements IDTSEvents.OnBreakpointHit
End Sub
|||
I am using .net 1.1 and SQL server 2000. I do not have SSIS.
The solution is to use Stored procedure to launch it, this relieving this responsibility from the .net application.
there is a call from the stored proc called the LoadFromSQLServer that can be used for this purpose.
Thanks
Subscribe to:
Posts (Atom)