Duplex printing in reporting services

I have been working on this problem for days. I have a report that is grouped
and will be printed duplex (front and back). There is a page break after each
group. I want to ensure that the start of a new group does not end up printed
on the back side of an old group. For example:

Page 1 (printed on front side of paper): group 1
Page 2 (printed on back side of paper): more group 1
Page 3 (printed on front side of paper): more group 1
Page 4 (printed on on back side of paper): group 2 < This is a problem

I need:

Page 1 (front side): group 1
Page 2 (back side): more group 1
Page 3 (front side): more group 1
Page 4 (back side): <This Page Intentionally Left Blank>
Page 5 (front side): group 2

Issues that I've run into include the fact that SSRS renders the entire body
first, before rendering the header/footer. This prevents the body of the
report from knowing which page it will end up on when it is rendered (and is
also why you cannot reference Globals!PageNumber from the body).

The restriction above also prevents using a variable in custom code to know
when to generate a page break. If you set this variable in the header/footer
then the body will never see it as the entire body is rendered first and will
therefore only see the initial state of the variable.

I have seen this issue posted in a number of places,
but no one ever has a solution to this (except switching back to
Crystal Reports). Have any MVPs ever addressed this issue? I am
really hoping someone can offer a good solution or work-around.

Finally - I have resolved this problem. We are writing the results to a pdf file, and was therefore able to use PDFSharp to update the output file before making it available to our users. With PDFSharp, I loop through each page of the exported report and determine whether it is the start of a new group (by checking the contents of the page). If it is a new group and the page number is EVEN, then I insert a blank page just before. So while there is no way to determine page numbers in Reporting Services, there is a way to manipulate the pdf output to be correct for duplex printing.

Duplex printing in reporting services

I have been working on this problem for days. I have a report that is grouped
and will be printed duplex (front and back). There is a page break after each
group. I want to ensure that the start of a new group does not end up printed
on the back side of an old group. For example:

Page 1 (printed on front side of paper): group 1
Page 2 (printed on back side of paper): more group 1
Page 3 (printed on front side of paper): more group 1
Page 4 (printed on on back side of paper): group 2 < This is a problem

I need:

Page 1 (front side): group 1
Page 2 (back side): more group 1
Page 3 (front side): more group 1
Page 4 (back side): <This Page Intentionally Left Blank>
Page 5 (front side): group 2

Issues that I've run into include the fact that SSRS renders the entire body
first, before rendering the header/footer. This prevents the body of the
report from knowing which page it will end up on when it is rendered (and is
also why you cannot reference Globals!PageNumber from the body).

The restriction above also prevents using a variable in custom code to know
when to generate a page break. If you set this variable in the header/footer
then the body will never see it as the entire body is rendered first and will
therefore only see the initial state of the variable.

I have seen this issue posted in a number of places,
but no one ever has a solution to this (except switching back to
Crystal Reports). Have any MVPs ever addressed this issue? I am
really hoping someone can offer a good solution or work-around.

Finally - I have resolved this problem. We are writing the results to a pdf file, and was therefore able to use PDFSharp to update the output file before making it available to our users. With PDFSharp, I loop through each page of the exported report and determine whether it is the start of a new group (by checking the contents of the page). If it is a new group and the page number is EVEN, then I insert a blank page just before. So while there is no way to determine page numbers in Reporting Services, there is a way to manipulate the pdf output to be correct for duplex printing.

Dundas CHART for Reporting Services

I'm curious to know others opinion of the Dundas Charting for Reporting
Services. I have downloaded and installed the beta and it appears to be
nice. Although I haven't had a chance to get any real reports created with
it. I like the fact that I can change the chart type while viewing the
report. Well, at least I can with VS.NET 2003.
I'm wondering if it is published to a server is the users can also change
the report type.Hi dm4714,
well, I am wanting to try it out too...I'll let you know what I
think....the beta has only been available for a week or so ... it's
pretty early...
We are looking to use RS + DotNetNuke + Dundas for RS....we felt the
charts inside 'vanilla RS' were a bit 'vanilla' and we wanted to
improve our charting with Dundas....
Best Regards
Peter Nolan
www.peternolan.com|||Hi dm4714,
well, I have my new instance of XP Pro and CTP version of SQL Server
2005 Dundas Chart Beta and I even bought a book on new 2005
features...learning as fast as I can...(LOL).
Without being an 'advertisement' I can say on first look Dundas Chart
for Report Services 2005 looks really good. I have had a small play
with it and am in the process of reading the manuals and understanding
how it actually works. In 2005 the Dundas Chart is a control that can
be placed into a form and you have complete control over the chart via
VB.net and C sharp. So, if you can code it, you can make the chart do
it...it seems.....I don't know the limitations as I have not got
there yet!!
The chart is placed onto the form and connected to dataset in similar
fashion to the MSFT chart that comes with RS2005. However, the range
of charts and the range of options is very large.....there also seems
to be some way to write pre/post rendering code in .net languages
though I am yet to figure that out....the samples allow you to control
such things as the type of chart produced based on another control so
the user can change the chart type on the fly.....
The documentation promises that the chart is drillable but I have not
yet tried (or even understood how to try) that feature...I asked
Dundas if they would publish an example of a drillable chart in dundas
in 2005 as I am keen to see how to do that.....we want the charts we
produce to be drillable...
It was not obvious at the start, but Dundas Chart for RS 2005 is a
completely separate product to Dundas Chart.
So, my feedback having read the manual for about 6 hours and gone
through all the samples is that it looks pretty good. Certainly I feel
we made a reasonable decision to wait for 2005 than try to get earlier
versions of any charts to work inside RS 2000.
I'll post again here when we have actually written some code and learn
some more......might be a few weeks...
I too would be very interested to hear anyone elses comments... :-)
Peter Nolan
www.peternolan.com|||I have spent about 2-3 weeks prototyping many different types of charts using
Dundas's SRS control and overall I am very impressed with it. I am using the
June CTP of SRS 2005. Here is my two cents worth of what I have found...
One big item that is missing is the ability to have a tooltip/hover message
on each data marker in a chart. Even though Dundas's base charts have this
functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
says that this functionality is being limited due to security reasons and
Dundas had to disable this feature.
I would be interested where you got a book on SRS 2005 as I understand that
they have been releases to the market as of yet. Andrew Bryan at Dundas,
really great guy, is writing a book on how to create a custom control that
can be consumed in SRS2005. There is not any documentation at all on this as
of yet.
The programmability of Dundas's charts is really cool. With just a little
C# code I was able to inject my own image at each data marker on a chart. I
am currently working on trying to produce my own custom legend due to our
business requirements.
I would recommend that anyone using this control investigate the Advanced
tab. All of the really powerful stuff is in there. I do have some issues
with getting every x-axis data label to display, but this may be my problem.
I can only get them to display if I use both the primary and secondary x-axis
labels.
Performance is good and the 3D effects are done very well. My biggest
complaint is the lack of documentation and examples. Being a developer, I
like to have the nitty gritty details and all of this beta software sometimes
drives me nuts trying to get it to do what I want.
=====================Thanks!
Keith
p.s. Get off the couch and exercise!
"Peter Nolan" wrote:
> Hi dm4714,
> well, I have my new instance of XP Pro and CTP version of SQL Server
> 2005 Dundas Chart Beta and I even bought a book on new 2005
> features...learning as fast as I can...(LOL).
> Without being an 'advertisement' I can say on first look Dundas Chart
> for Report Services 2005 looks really good. I have had a small play
> with it and am in the process of reading the manuals and understanding
> how it actually works. In 2005 the Dundas Chart is a control that can
> be placed into a form and you have complete control over the chart via
> VB.net and C sharp. So, if you can code it, you can make the chart do
> it...it seems.....I don't know the limitations as I have not got
> there yet!!
> The chart is placed onto the form and connected to dataset in similar
> fashion to the MSFT chart that comes with RS2005. However, the range
> of charts and the range of options is very large.....there also seems
> to be some way to write pre/post rendering code in .net languages
> though I am yet to figure that out....the samples allow you to control
> such things as the type of chart produced based on another control so
> the user can change the chart type on the fly.....
> The documentation promises that the chart is drillable but I have not
> yet tried (or even understood how to try) that feature...I asked
> Dundas if they would publish an example of a drillable chart in dundas
> in 2005 as I am keen to see how to do that.....we want the charts we
> produce to be drillable...
> It was not obvious at the start, but Dundas Chart for RS 2005 is a
> completely separate product to Dundas Chart.
> So, my feedback having read the manual for about 6 hours and gone
> through all the samples is that it looks pretty good. Certainly I feel
> we made a reasonable decision to wait for 2005 than try to get earlier
> versions of any charts to work inside RS 2000.
> I'll post again here when we have actually written some code and learn
> some more......might be a few weeks...
> I too would be very interested to hear anyone elses comments... :-)
> Peter Nolan
> www.peternolan.com
>|||IN SRS 2005 is there any option for multiple X-Axis
"Keith" wrote:
> I have spent about 2-3 weeks prototyping many different types of charts using
> Dundas's SRS control and overall I am very impressed with it. I am using the
> June CTP of SRS 2005. Here is my two cents worth of what I have found...
> One big item that is missing is the ability to have a tooltip/hover message
> on each data marker in a chart. Even though Dundas's base charts have this
> functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
> says that this functionality is being limited due to security reasons and
> Dundas had to disable this feature.
> I would be interested where you got a book on SRS 2005 as I understand that
> they have been releases to the market as of yet. Andrew Bryan at Dundas,
> really great guy, is writing a book on how to create a custom control that
> can be consumed in SRS2005. There is not any documentation at all on this as
> of yet.
> The programmability of Dundas's charts is really cool. With just a little
> C# code I was able to inject my own image at each data marker on a chart. I
> am currently working on trying to produce my own custom legend due to our
> business requirements.
> I would recommend that anyone using this control investigate the Advanced
> tab. All of the really powerful stuff is in there. I do have some issues
> with getting every x-axis data label to display, but this may be my problem.
> I can only get them to display if I use both the primary and secondary x-axis
> labels.
> Performance is good and the 3D effects are done very well. My biggest
> complaint is the lack of documentation and examples. Being a developer, I
> like to have the nitty gritty details and all of this beta software sometimes
> drives me nuts trying to get it to do what I want.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!
>
> "Peter Nolan" wrote:
> > Hi dm4714,
> > well, I have my new instance of XP Pro and CTP version of SQL Server
> > 2005 Dundas Chart Beta and I even bought a book on new 2005
> > features...learning as fast as I can...(LOL).
> >
> > Without being an 'advertisement' I can say on first look Dundas Chart
> > for Report Services 2005 looks really good. I have had a small play
> > with it and am in the process of reading the manuals and understanding
> > how it actually works. In 2005 the Dundas Chart is a control that can
> > be placed into a form and you have complete control over the chart via
> > VB.net and C sharp. So, if you can code it, you can make the chart do
> > it...it seems.....I don't know the limitations as I have not got
> > there yet!!
> >
> > The chart is placed onto the form and connected to dataset in similar
> > fashion to the MSFT chart that comes with RS2005. However, the range
> > of charts and the range of options is very large.....there also seems
> > to be some way to write pre/post rendering code in .net languages
> > though I am yet to figure that out....the samples allow you to control
> > such things as the type of chart produced based on another control so
> > the user can change the chart type on the fly.....
> >
> > The documentation promises that the chart is drillable but I have not
> > yet tried (or even understood how to try) that feature...I asked
> > Dundas if they would publish an example of a drillable chart in dundas
> > in 2005 as I am keen to see how to do that.....we want the charts we
> > produce to be drillable...
> >
> > It was not obvious at the start, but Dundas Chart for RS 2005 is a
> > completely separate product to Dundas Chart.
> >
> > So, my feedback having read the manual for about 6 hours and gone
> > through all the samples is that it looks pretty good. Certainly I feel
> > we made a reasonable decision to wait for 2005 than try to get earlier
> > versions of any charts to work inside RS 2000.
> >
> > I'll post again here when we have actually written some code and learn
> > some more......might be a few weeks...
> >
> > I too would be very interested to hear anyone elses comments... :-)
> >
> > Peter Nolan
> > www.peternolan.com
> >
> >|||Dundas is very nice.
Here is a tool (free) which make charts similar to Dundas and can be
plugged
easily to sqlserver (being .NET):
http://151.100.3.84/technicalpreview/
-Pamela
.NET Developer|||Hi Keith,
the book I bought is called 'SQL Server 2005 New Features' by Michael
Otley. Senior Technical Editor SQL Server Magazine. It only has a
small section on SRS but it does cover lots and lots of the new stuff
in 2005 and there is quite a bit...after all it has been 5 years!!!
(LOL)..It's about 250 pages...I bought it because it would save me
hours and hours of flicking through other manuals and presentations
just to get the highlights of the new features...I think it's worth
getting....(I buy a lot of books.)
It seems like partitioning has been done properly in 2005...and I am
very interested/impressed with the idea that something that looks like
a stored procedure can actually be a .net programming language....I
can think of plenty of uses of such a feature.....I am trying to
figure out if I can turn 10,000 lines of SPs that I have written into
something that cannot be read, like a program...but heck, I only got
the book on the weekend....more reading to do yet...
Best Regards
Peter Nolan.|||Peter,
Thanks for the kind words and plug for my book! ... I guess I really
have to get to work on it now eh? It is expected to be released in
March.
With respect to the docs and samples, this is an area that I will be
focusing in the next couple of weeks. The docs will be a continual
work in progress but we we be getting more technical writing done soon.
For the samples, this is where you can help. If there is a particular
sample that you would like to see, let us know. We would like to get
this product's sample set as complete as our .net offerings but it will
take some time.
There will be a new beta released in Sept for the release candidate of
SQL Server 2005 so what for it ... there will be more samples in that
build.
Thanks again,
Andrew Bryan
Keith wrote:
> I have spent about 2-3 weeks prototyping many different types of charts using
> Dundas's SRS control and overall I am very impressed with it. I am using the
> June CTP of SRS 2005. Here is my two cents worth of what I have found...
> One big item that is missing is the ability to have a tooltip/hover message
> on each data marker in a chart. Even though Dundas's base charts have this
> functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
> says that this functionality is being limited due to security reasons and
> Dundas had to disable this feature.
> I would be interested where you got a book on SRS 2005 as I understand that
> they have been releases to the market as of yet. Andrew Bryan at Dundas,
> really great guy, is writing a book on how to create a custom control that
> can be consumed in SRS2005. There is not any documentation at all on this as
> of yet.
> The programmability of Dundas's charts is really cool. With just a little
> C# code I was able to inject my own image at each data marker on a chart. I
> am currently working on trying to produce my own custom legend due to our
> business requirements.
> I would recommend that anyone using this control investigate the Advanced
> tab. All of the really powerful stuff is in there. I do have some issues
> with getting every x-axis data label to display, but this may be my problem.
> I can only get them to display if I use both the primary and secondary x-axis
> labels.
> Performance is good and the 3D effects are done very well. My biggest
> complaint is the lack of documentation and examples. Being a developer, I
> like to have the nitty gritty details and all of this beta software sometimes
> drives me nuts trying to get it to do what I want.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!
>
> "Peter Nolan" wrote:
> > Hi dm4714,
> > well, I have my new instance of XP Pro and CTP version of SQL Server
> > 2005 Dundas Chart Beta and I even bought a book on new 2005
> > features...learning as fast as I can...(LOL).
> >
> > Without being an 'advertisement' I can say on first look Dundas Chart
> > for Report Services 2005 looks really good. I have had a small play
> > with it and am in the process of reading the manuals and understanding
> > how it actually works. In 2005 the Dundas Chart is a control that can
> > be placed into a form and you have complete control over the chart via
> > VB.net and C sharp. So, if you can code it, you can make the chart do
> > it...it seems.....I don't know the limitations as I have not got
> > there yet!!
> >
> > The chart is placed onto the form and connected to dataset in similar
> > fashion to the MSFT chart that comes with RS2005. However, the range
> > of charts and the range of options is very large.....there also seems
> > to be some way to write pre/post rendering code in .net languages
> > though I am yet to figure that out....the samples allow you to control
> > such things as the type of chart produced based on another control so
> > the user can change the chart type on the fly.....
> >
> > The documentation promises that the chart is drillable but I have not
> > yet tried (or even understood how to try) that feature...I asked
> > Dundas if they would publish an example of a drillable chart in dundas
> > in 2005 as I am keen to see how to do that.....we want the charts we
> > produce to be drillable...
> >
> > It was not obvious at the start, but Dundas Chart for RS 2005 is a
> > completely separate product to Dundas Chart.
> >
> > So, my feedback having read the manual for about 6 hours and gone
> > through all the samples is that it looks pretty good. Certainly I feel
> > we made a reasonable decision to wait for 2005 than try to get earlier
> > versions of any charts to work inside RS 2000.
> >
> > I'll post again here when we have actually written some code and learn
> > some more......might be a few weeks...
> >
> > I too would be very interested to hear anyone elses comments... :-)
> >
> > Peter Nolan
> > www.peternolan.com
> >
> >|||I have not used the chart package for 2005 but the previous charts were
drillable ... I would like to think that they didnt *remove* functionality
...
Right click on your chart and choose Properties. Choose the data tab ...
select one of your values and then EDIT. You will notice a series of tabs
that display ... choose the one that says ACTION and you will see "jump to
report" which is the drill - thru. Thats where it is on the OLD way ... I
hope you can find it somewhere in the vicinity on the package you are working
with. Let me know ... ok? Thanks!
"Peter Nolan" wrote:
> Hi dm4714,
> well, I have my new instance of XP Pro and CTP version of SQL Server
> 2005 Dundas Chart Beta and I even bought a book on new 2005
> features...learning as fast as I can...(LOL).
> Without being an 'advertisement' I can say on first look Dundas Chart
> for Report Services 2005 looks really good. I have had a small play
> with it and am in the process of reading the manuals and understanding
> how it actually works. In 2005 the Dundas Chart is a control that can
> be placed into a form and you have complete control over the chart via
> VB.net and C sharp. So, if you can code it, you can make the chart do
> it...it seems.....I don't know the limitations as I have not got
> there yet!!
> The chart is placed onto the form and connected to dataset in similar
> fashion to the MSFT chart that comes with RS2005. However, the range
> of charts and the range of options is very large.....there also seems
> to be some way to write pre/post rendering code in .net languages
> though I am yet to figure that out....the samples allow you to control
> such things as the type of chart produced based on another control so
> the user can change the chart type on the fly.....
> The documentation promises that the chart is drillable but I have not
> yet tried (or even understood how to try) that feature...I asked
> Dundas if they would publish an example of a drillable chart in dundas
> in 2005 as I am keen to see how to do that.....we want the charts we
> produce to be drillable...
> It was not obvious at the start, but Dundas Chart for RS 2005 is a
> completely separate product to Dundas Chart.
> So, my feedback having read the manual for about 6 hours and gone
> through all the samples is that it looks pretty good. Certainly I feel
> we made a reasonable decision to wait for 2005 than try to get earlier
> versions of any charts to work inside RS 2000.
> I'll post again here when we have actually written some code and learn
> some more......might be a few weeks...
> I too would be very interested to hear anyone elses comments... :-)
> Peter Nolan
> www.peternolan.com
>|||Hi MJ,
it is there, the manual talks about how to do it, but it needs to be
written into the controls as .net it looks like....my problem is that
my skill level is not up to it yet!!! ;-)..I think I am just not
'there' yet.
I am not after the jump/hypelink style of drill thru, I am looking for
subsetting the data from the existing dataset.....like I said, it is
just hard for me to follow..
I have had feedback from Dundas that they will prepare an example as
part of the beta...in fact they are being great they really seem to
want to hear what people want in the product!! What a nice change for a
software vendor!!!
Peter
www.peternolan.com

Dundas 2.0 for RS and image quality...disappointing

I was pretty excited to get the image quality improvements in Dundas
Charting for Reporting Services 2.0. Chris Hays blog on the issue of
rendering charts in a Custom Report Item explains the issue well.
http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
We like the Dundas charts, but the image quality in pdf format isn't nearly
as good as the native charts, which I believe are also made by Dundas. With
the new properties of ImageResolution and Sizing I was hoping that I could
find a combination that would generate smooth images in both HTML and PDF
formats. I couldn't, I went back and read Chris' article and now understand
that there needs to be a mechanism to set these settings on a per/renderer
basis, or just wait for RS 200x or spx to implement vector graphic support.Hi Steve,
If you would like help or direction in how to best implement this,
please let us know. We have implemented such a mechanism in our online
report demo environment and have some tips on our support site:
http://demos2.dundas.com/ReportingServices/
http://support.dundas.com/
There are a couple of ways to do this but the best solution depends on
how your reports are consumed. I would be happy to discuss your
options with you.
Andrew Bryan
Dundas Software
416-467-9100 x122
Steve MunLeeuw wrote:
> I was pretty excited to get the image quality improvements in Dundas
> Charting for Reporting Services 2.0. Chris Hays blog on the issue of
> rendering charts in a Custom Report Item explains the issue well.
> http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
> We like the Dundas charts, but the image quality in pdf format isn't nearly
> as good as the native charts, which I believe are also made by Dundas. With
> the new properties of ImageResolution and Sizing I was hoping that I could
> find a combination that would generate smooth images in both HTML and PDF
> formats. I couldn't, I went back and read Chris' article and now understand
> that there needs to be a mechanism to set these settings on a per/renderer
> basis, or just wait for RS 200x or spx to implement vector graphic support.|||Ok, sorry for the poor attitude, I will try again next release.
Steve MunLeeuw
<andrewb@.dundas.com> wrote in message
news:1158696150.448185.311420@.b28g2000cwb.googlegroups.com...
> Hi Steve,
> If you would like help or direction in how to best implement this,
> please let us know. We have implemented such a mechanism in our online
> report demo environment and have some tips on our support site:
> http://demos2.dundas.com/ReportingServices/
> http://support.dundas.com/
> There are a couple of ways to do this but the best solution depends on
> how your reports are consumed. I would be happy to discuss your
> options with you.
> Andrew Bryan
> Dundas Software
> 416-467-9100 x122
>
> Steve MunLeeuw wrote:
>> I was pretty excited to get the image quality improvements in Dundas
>> Charting for Reporting Services 2.0. Chris Hays blog on the issue of
>> rendering charts in a Custom Report Item explains the issue well.
>> http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
>> We like the Dundas charts, but the image quality in pdf format isn't
>> nearly
>> as good as the native charts, which I believe are also made by Dundas.
>> With
>> the new properties of ImageResolution and Sizing I was hoping that I
>> could
>> find a combination that would generate smooth images in both HTML and PDF
>> formats. I couldn't, I went back and read Chris' article and now
>> understand
>> that there needs to be a mechanism to set these settings on a
>> per/renderer
>> basis, or just wait for RS 200x or spx to implement vector graphic
>> support.
>sql

dumping backups to share in different domain

Hi,
I have a sql server running in domain abc.com. de sqlserver and the sqlagent
services are running on their own useraccounts SqlServerServ@.abc.com and
SqlAgentServ@.abc.com. This server is in our own server room which we use to
host servers on our own domain 123.com.
the following task needs to be done:
make backups of the databases in sqlserver.abc.com to the file share on
fileserver.123.com by creating jobs in sqlagent.
What can not be done:
Make a trust between abc.com and 123.com since both companies don't trust
each other.
extra info.
sqlserver.abc.com
sql server 2000 standard SP3 running on
windows 2000 Standard edition (patches unknown)
this box happens to be the DC for abc.com as well (it's a test enviorment)
fileserver.123.com
windows 2000 standard edition (patches unknown)
this box is not the DC for 123.com
a share is create \\fileserver\DBbackups
and a user called SQLbackup@.123.com which has full rights to this share
What is the best way to go arround:
1) try and make the backups work using SQLbackup@.123.com
2) or try and give SQLAgentServ@.abc.com access to the fileshare on
fileserver.123.com
Is any of these two option possible at all?
are there better solutions with this setup?(we cannot change the domain
setup and memberships, and we cannot at extra boxes)
Kind regards
Edward Dortland
please reply to newsgroup ONLYSuggestions:
Install FTP server on fileserver.123.com, then
1. Do local backup on abc.com
2. Transfer these backups to fileserver.123.com using -s:filename option.
OR try this one (not sure if it will work).
1. Create LOCAL account SQLAgentServ on both computers with same password.
From Log shipping:
"Local Network Account
You can use SQL Server to start under a locally-created network account. In
the situation where there is network access required by a SQL Server
process, which is the case if you have configured SQL Server to use log
shipping, you can use network pass-through security. With pass-through
security, all machines that will be accessed by SQL Server must have the
same network account with the same password and appropriate permissions,
configured locally. Additionally, when the SQL Server process requests
resources from the second computer, traditional network security is bypassed
if the same account (under which the requesting SQL Server service is
started) exists with the same password. As long the account on the second
computer is configured with enough permission to carry out the task that is
requested by calling SQL Server, the task will be successful. "
2. Try to do backup.
HTH
Igor Raytsin
"Edward Dortland" <edwardNOSPAMMMM@.solsol.nl> wrote in message
news:104jovuket4qk0f@.corp.supernews.com...
> Hi,
> I have a sql server running in domain abc.com. de sqlserver and the
sqlagent
> services are running on their own useraccounts SqlServerServ@.abc.com and
> SqlAgentServ@.abc.com. This server is in our own server room which we use
to
> host servers on our own domain 123.com.
> the following task needs to be done:
> make backups of the databases in sqlserver.abc.com to the file share on
> fileserver.123.com by creating jobs in sqlagent.
> What can not be done:
> Make a trust between abc.com and 123.com since both companies don't trust
> each other.
> extra info.
> sqlserver.abc.com
> sql server 2000 standard SP3 running on
> windows 2000 Standard edition (patches unknown)
> this box happens to be the DC for abc.com as well (it's a test enviorment)
> fileserver.123.com
> windows 2000 standard edition (patches unknown)
> this box is not the DC for 123.com
> a share is create \\fileserver\DBbackups
> and a user called SQLbackup@.123.com which has full rights to this share
> What is the best way to go arround:
> 1) try and make the backups work using SQLbackup@.123.com
> 2) or try and give SQLAgentServ@.abc.com access to the fileshare on
> fileserver.123.com
> Is any of these two option possible at all?
> are there better solutions with this setup?(we cannot change the domain
> setup and memberships, and we cannot at extra boxes)
> Kind regards
>
> Edward Dortland
> please reply to newsgroup ONLY
>
>sql

dumb question...

After configuring exactly as specified in reporting services custom security, when I try to hit report manager, I keep on getting the error:

Invalid URI: The format of the URI could not be determined.

It does not redirct me to UILogin.aspx page but forwards me to Pages/Folder.aspx and gives this error.

Please if possible let me know ASAP.

I have the following in "rsreportserver.config" file

<UrlRoot>http://<computername>/reportserver</UrlRoot>

I have tried using "localhost" instead of computer name in the above line. Secondly, when I hit report manager, I thought it should redirect me to UILogin.aspx. It does not. And even if it did, I would like to know how it would do that because in report server, you specify the url in the <forms> tag. here there is no such tag that would make it redirect to UILogon.aspx.

I have the following in Web.config file of Report Manager

<authentication mode="Windows" />
<identity impersonate="false" />

I have the following in RsWebApplication.config file

<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<CustomAuthenticationUI>
<loginUrl>UILogin.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
</UI>

Thanks.

Thanks.

Solved it

There were 2 issues

the UILogon.aspx file was not under pages(wonder what that would do?)

Secondly, changed the ordering in RSWebApplication.config file to

<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<computername>/ReportServer</ReportServerUrl>
</UI>

Finally, in the url requested

http://<computername>/Reports

|||

I been trying to get my own sql reporting services going... but i have so many issues..

the dumb question: does SQL 2005 Reporting Services require IIS 6.0 ? Windows 2003?

thanks

|||

Should work on xp pro . no need for windows 2003. For production deployment however, consider deploying enterprise version on windows server 2003.

Also always use iis6.0

|||

so, iis5 does not work?

Dumb question

Simple question from a simpleton. I'm working through Microsoft Press SQL Server 2005 Reporting Services Step by Step. It references a database rs2005sbsDW, which as far as I can tell was not included with either the sample databases on the SQL Server (standard edition) install disk or the Step by Step book. Where the heck is it? What am I missing.

Trying to reinstall the sample databases from the SQL Server install disk's tells me I have everything installed already.

Thanks in advance.

Hi,

Did you follow the instructions on page XV? The files will be installed via a setup.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

I did thanks. I was using the book a bit too literally. The instructions for specifying the database in the connection manager just suggest typing the database name in or using the drop down box, neither which accepted or display the rs2005sbsDW database. I assumed it just wasn't there. Once I knew where is was, it became obvious to use the browse option in connection manager instead.

Thanks.

|||Please I need the datasource rs2005sbsDW my email is edupuebla@.yahoo.com.

Thanks

Dumb question

Simple question from a simpleton. I'm working through Microsoft Press SQL Server 2005 Reporting Services Step by Step. It references a database rs2005sbsDW, which as far as I can tell was not included with either the sample databases on the SQL Server (standard edition) install disk or the Step by Step book. Where the heck is it? What am I missing.

Trying to reinstall the sample databases from the SQL Server install disk's tells me I have everything installed already.

Thanks in advance.

Hi,

Did you follow the instructions on page XV? The files will be installed via a setup.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

I did thanks. I was using the book a bit too literally. The instructions for specifying the database in the connection manager just suggest typing the database name in or using the drop down box, neither which accepted or display the rs2005sbsDW database. I assumed it just wasn't there. Once I knew where is was, it became obvious to use the browse option in connection manager instead.

Thanks.

|||Please I need the datasource rs2005sbsDW my email is edupuebla@.yahoo.com.

Thanks

Dubious SQL Login?

I want to centralize server logs. All these server services (IIS, ISA, etc)
all know how to log to ODBC, and I want to exploit this so that I have a
central place to analyze logs instead of trapsing through the file system
looking for all these silly log files.
So I made a ServerLogs database, and I plan to have a flat table for each
log. There are of course no relationships here, just a set of flat tables.
These servers that will log through ODBC will need to be able to connect to
SQL Server so I have to make some logins. I would prefer to use Windows
Only authentication because that forces any connection to be authenticated
by Active Directory. But if I do this, then I would have to make Logins in
SQL Server for "Local System" and "Network Service".
Now these logins would only have access to the ServerLogs database, and in
there, would only have "public" permissions. No permissions other than that
which is required to log their log records.
My question is, in this scenario, does it sound like a bad idea to give
LocalSystem and NetworkService access to SQL Server? I just want a reality
check before I do something that might be dangerous or stupid.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiThe service startup account implicates sqlserver's ability to access
resources. Thus, if you do not want sqlserver to access any resources
outside of the box it's running on, you would use localsystem. If it needs
to access network resources, networkservice is obviously the choice.
Now, as far as users' permissions, you would just need to grant the domain
user (or group) to sqlserver and any desired databased.
e.g.
exec sp_grantlogin 'domain\user' --'domain\group'
go
use db
go
exec sp_grantdbaccess 'domain\user' --'domain\group'
-oj
"Mike Labosh" <mlabosh_at_hotmail_dot_com> wrote in message
news:Ox6%23epiOGHA.3896@.TK2MSFTNGP15.phx.gbl...
>I want to centralize server logs. All these server services (IIS, ISA,
>etc)
> all know how to log to ODBC, and I want to exploit this so that I have a
> central place to analyze logs instead of trapsing through the file system
> looking for all these silly log files.
> So I made a ServerLogs database, and I plan to have a flat table for each
> log. There are of course no relationships here, just a set of flat
> tables.
> These servers that will log through ODBC will need to be able to connect
> to
> SQL Server so I have to make some logins. I would prefer to use Windows
> Only authentication because that forces any connection to be authenticated
> by Active Directory. But if I do this, then I would have to make Logins
> in
> SQL Server for "Local System" and "Network Service".
> Now these logins would only have access to the ServerLogs database, and in
> there, would only have "public" permissions. No permissions other than
> that
> which is required to log their log records.
> My question is, in this scenario, does it sound like a bad idea to give
> LocalSystem and NetworkService access to SQL Server? I just want a
> reality
> check before I do something that might be dangerous or stupid.
> --
>
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||> The service startup account implicates sqlserver's ability to access
> resources. Thus, if you do not want sqlserver to access any resources
> outside of the box it's running on, you would use localsystem. If it needs
> to access network resources, networkservice is obviously the choice.
Perhaps you misunderstood, or I misstated:
I want these servers: HTTP, FTP, NNTP, SMTP, POP3, ISA
to be able to connect to SQL Server to write their logs into SQL Server
tables.
The IIS and ISA related services that want to do ODBC logging to SQL Server
all run as LocalSystem or NetworkService. Using Windows Only authentication
in SQL Server, I would have to create SQL Server logins for LocalSystem and
NetworkService so that these other services can ODBC their log entries to
SQL.
My question is whether it's a bad idea to allow LocalSystem and
NetworkService to have logins at SQL Server on behalf of these other
servers, because I know these two important accounts are used for a
MULTITUDE of other things.
In other words, I want to do this:
EXEC sp_GrantLogin 'Local System'
EXEC sp_GrantLogin 'NT AUTHORITY\NetworkService'
GO
CREATE DATABASE ServerLogs
GO
USE ServerLogs
GO
EXEC sp_GrantDBAccess 'Local System'
EXEC sp_GrantDBAccess 'NT AUTHORITY\NetworkService'
GO
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||Ah, I see.
Granting any NT acct will only give it a public role. Thus, there is really
no harm. Though, in this case, these system accts are used in many services.
So, granting them access will also allow all others from accessing.
But then again, localsystem already has *full* access to the local
machine...
-oj
"Mike Labosh" <mlabosh_at_hotmail_dot_com> wrote in message
news:Ot91RFjOGHA.2604@.TK2MSFTNGP09.phx.gbl...
> Perhaps you misunderstood, or I misstated:
> I want these servers: HTTP, FTP, NNTP, SMTP, POP3, ISA
> to be able to connect to SQL Server to write their logs into SQL Server
> tables.
> The IIS and ISA related services that want to do ODBC logging to SQL
> Server
> all run as LocalSystem or NetworkService. Using Windows Only
> authentication
> in SQL Server, I would have to create SQL Server logins for LocalSystem
> and
> NetworkService so that these other services can ODBC their log entries to
> SQL.
> My question is whether it's a bad idea to allow LocalSystem and
> NetworkService to have logins at SQL Server on behalf of these other
> servers, because I know these two important accounts are used for a
> MULTITUDE of other things.
> In other words, I want to do this:
> EXEC sp_GrantLogin 'Local System'
> EXEC sp_GrantLogin 'NT AUTHORITY\NetworkService'
> GO
> CREATE DATABASE ServerLogs
> GO
> USE ServerLogs
> GO
> EXEC sp_GrantDBAccess 'Local System'
> EXEC sp_GrantDBAccess 'NT AUTHORITY\NetworkService'
> GO
> --
>
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||> Granting any NT acct will only give it a public role. Thus, there is
really
> no harm. Though, in this case, these system accts are used in many
services.
> So, granting them access will also allow all others from accessing.
Agreed. And the only thing SQL Server will let them have permissions for is
"public" access to Just the ServerLogs database

> But then again, localsystem already has *full* access to the local
> machine...
Ha. Yes, I forgot about that. I was just trying to get a reality check
before I accidentally unzipped my fly on the public internet or something
like that.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||>
> My question is, in this scenario, does it sound like a bad idea to give
> LocalSystem and NetworkService access to SQL Server? I just want a
> reality
> check before I do something that might be dangerous or stupid.
>
There's nothing wrong with giving software access to SQL Server, just make
sure that the security is set so that it can't do anything that it
shouldn't. You'll also need to make sure that it's not possible to inject
stuff that you shouldn't be able to.
As a different idea, maybe you should take a look at the SSIS (SQL Server
Integration Services) This is the all new DTS replacement. Using SSIS, you
can pull the information direct from the file system, perform some
transformation and insert the files into SQL. It can be setup on a schedule
so the entire process can be automated, and executed by SQL Server! No need
to give IIS and all those other nasties access to SQL at all.
Regards
Colin Dawson
www.cjdawson.com|||> There's nothing wrong with giving software access to SQL Server, just make
> sure that the security is set so that it can't do anything that it
> shouldn't. You'll also need to make sure that it's not possible to inject
> stuff that you shouldn't be able to.
Thank you, that's precisely what I was looking for.

> As a different idea, maybe you should take a look at the SSIS (SQL Server
> Integration Services) This is the all new DTS replacement. Using SSIS,
you
> can pull the information direct from the file system, perform some
> transformation and insert the files into SQL. It can be setup on a
schedule
> so the entire process can be automated, and executed by SQL Server! No
need
> to give IIS and all those other nasties access to SQL at all.
If you are referring to SQL 2005, I cannot do that because I am not up to
speed on it yet, but that does sound like it is more secure.
In any case, if I am reading you correctly, it sounds like I am OK as long
as LocalSystem and NetworkService have limited permissions.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||>
> If you are referring to SQL 2005, I cannot do that because I am not up to
> speed on it yet, but that does sound like it is more secure.
> In any case, if I am reading you correctly, it sounds like I am OK as long
> as LocalSystem and NetworkService have limited permissions.
>
You could do it with permissions. I wouldn't worry about not being up to
speed on SQL 2005, if you wait for that it'll be a year or so before you can
truly say that. (maybe longer!) The Integrations services are a replacement
for DTS, hence why I'm saying not to bother with it. But surely if security
is a major consideration, it's worth spending a few hours getting up to
speed on part of the SQL Server Business intelligence studio.
Specifically, it's the Integrations service project that you need to look
at.
In a nutshell you can split the task into several stages, such as read a
file, convert the format, perform some aggregations, split the data into
distinct subsets, write the data into a table. Keeping each step distinct
and seperate will allow the SSIS to split the taks up into many threads, so
you get a performance boost using multi threading, but SQL will do all the
work for you.
Regards
Colin Dawson
www.cjdawson.com

Dual axes in RS2k5

I seem to remember reading that in Reporting Services 2005 it would be
possible to create column charts with dual axes, in particular with a dual y
axis.
I've been playing around with the charts but I can't seem to find a way to
do this. Did this functionality find its way into the product in the end? How
is it done?
Thanks,
Matt.Hi Matt,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood would like to know whether Dual axes
will be supported in SQL Server 2005 Reporting Services. If I have
misunderstood your concern, please feel free to point it out.
Unfortunately, dual axes are not supported in the built-in charting
included with SQL Server 2005 RS. However, Dundas (see
http://www.dundasreporting.com/home/index.aspx) will be providing a plug-in
that supports this functionality.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

DTS, SMO, SSIS

Database Transfer Services, replaced now by SMO now as I know..

In SQL Server 2005 is SSIS (SQL Server Integration Services).From Microsoft web page:SQL Server Integration Services, or SSIS, is an engine for building data import and export solutions and performing transformations on data as it is transferred.

pls. explain SSIS than? what is latest technology?

SSIS is the new, and very much improved, DTS.

SMO, or SQL Managment Objects, are used to automate common SQL Server functions, I believe...

DTS, overwrite excel sheet

Hi,
I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
hour. I created DTS (Data Transformation Services) packages by wizard.
It works fine first time but when DTS runs next time it ends with error:
table 'xxxx' already exist. How to manage the overwrite of this Excel
Sheet 'xxxx' every hour automatically?
Thanks,
Martin.
Add a Execute SQL task like this
drop table `xxxx`
go
CREATE TABLE `xxxx` (
`FieldName1` FieldType1,
`FieldName2` FieldType2
)
Francesco Anti
"martin" <martin@.server.sk> wrote in message
news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
> hour. I created DTS (Data Transformation Services) packages by wizard.
> It works fine first time but when DTS runs next time it ends with error:
> table 'xxxx' already exist. How to manage the overwrite of this Excel
> Sheet 'xxxx' every hour automatically?
>
> Thanks,
> Martin.
>
|||It works fine,
Thank you
Martin
"Francesco Anti" <fanti_@._sicosbt.it> napsal v sprve
news:%233EejCthFHA.2156@.TK2MSFTNGP14.phx.gbl...
> Add a Execute SQL task like this
> drop table `xxxx`
> go
> CREATE TABLE `xxxx` (
> `FieldName1` FieldType1,
> `FieldName2` FieldType2
> )
> Francesco Anti
> "martin" <martin@.server.sk> wrote in message
> news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
>

DTS, overwrite excel sheet

Hi,
I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
hour. I created DTS (Data Transformation Services) packages by wizard.
It works fine first time but when DTS runs next time it ends with error:
table 'xxxx' already exist. How to manage the overwrite of this Excel
Sheet 'xxxx' every hour automatically?
Thanks,
Martin.Add a Execute SQL task like this
drop table `xxxx`
go
CREATE TABLE `xxxx` (
`FieldName1` FieldType1,
`FieldName2` FieldType2
)
Francesco Anti
"martin" <martin@.server.sk> wrote in message
news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
> hour. I created DTS (Data Transformation Services) packages by wizard.
> It works fine first time but when DTS runs next time it ends with error:
> table 'xxxx' already exist. How to manage the overwrite of this Excel
> Sheet 'xxxx' every hour automatically?
>
> Thanks,
> Martin.
>|||It works fine,
Thank you
Martin
"Francesco Anti" <fanti_@._sicosbt.it> napsal v sprve
news:%233EejCthFHA.2156@.TK2MSFTNGP14.phx.gbl...
> Add a Execute SQL task like this
> drop table `xxxx`
> go
> CREATE TABLE `xxxx` (
> `FieldName1` FieldType1,
> `FieldName2` FieldType2
> )
> Francesco Anti
> "martin" <martin@.server.sk> wrote in message
> news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
>

DTS, overwrite excel sheet

Hi,
I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
hour. I created DTS (Data Transformation Services) packages by wizard.
It works fine first time but when DTS runs next time it ends with error:
table 'xxxx' already exist. How to manage the overwrite of this Excel
Sheet 'xxxx' every hour automatically?
Thanks,
Martin.Add a Execute SQL task like this
drop table `xxxx`
go
CREATE TABLE `xxxx` (
`FieldName1` FieldType1,
`FieldName2` FieldType2
)
Francesco Anti
"martin" <martin@.server.sk> wrote in message
news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
> hour. I created DTS (Data Transformation Services) packages by wizard.
> It works fine first time but when DTS runs next time it ends with error:
> table 'xxxx' already exist. How to manage the overwrite of this Excel
> Sheet 'xxxx' every hour automatically?
>
> Thanks,
> Martin.
>|||It works fine,
Thank you
Martin
"Francesco Anti" <fanti_@._sicosbt.it> napísal v správe
news:%233EejCthFHA.2156@.TK2MSFTNGP14.phx.gbl...
> Add a Execute SQL task like this
> drop table `xxxx`
> go
> CREATE TABLE `xxxx` (
> `FieldName1` FieldType1,
> `FieldName2` FieldType2
> )
> Francesco Anti
> "martin" <martin@.server.sk> wrote in message
> news:eS0sc1shFHA.1412@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> I have a MS SQL 2000 SP4. I need to export a table to Excel sheet every
>> hour. I created DTS (Data Transformation Services) packages by wizard.
>> It works fine first time but when DTS runs next time it ends with error:
>> table 'xxxx' already exist. How to manage the overwrite of this Excel
>> Sheet 'xxxx' every hour automatically?
>>
>> Thanks,
>> Martin.
>>
>

DTS vs Integration Service

Hello All,

I have issues regarding DTS in SQL 2000 in comparison to the Integration Services in SQL 2005.

In SQL 2000 the way I used to import data from a Microsof Excel file

was through DTS where I could mention row number from the Excel file to

start extraction into the SQL DB. (Transform Data Task Properties > Options > Data Movement: First Row)

Whereas, in SQL 2005 I cannot specify anywhere from which row number

the extraction should start. I am new to SQL server 2005, any help

regarding above issue will be much appreciated.

Thanks

Umer

see SSIS forum

In SQL Server 2005 Books Online :

Flat File Connection Manager Editor (General Page)

http://msdn2.microsoft.com/en-us/library/ms187017.aspx

Header rows to skip

Specify the number of header rows or initial data rows to skip, if any