Wednesday, March 28, 2012
PDF Rendering
all my page sizes, margins etc. Ensured that my page size is minus my
margins etc. And still this is happening. Any insight would be lovely
thanks. Cannot deploy reports to customers application until this is sorted.Do you have a page break after any groups?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> OK still having the problem of a blank page after every report. I have
> reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is
> sorted.|||No page break Brain. Managed to get it sorted yesterday afternoon with much
playing around with margins etc. Even are setting the page size to the
normal width less the margins didn't seem to help. I had to bring it in a
lot further.
"Brian Welcker [MSFT]" wrote:
> Do you have a page break after any groups?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
> news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> > OK still having the problem of a blank page after every report. I have
> > reset
> > all my page sizes, margins etc. Ensured that my page size is minus my
> > margins etc. And still this is happening. Any insight would be lovely
> > thanks. Cannot deploy reports to customers application until this is
> > sorted.
>
>|||What about the <Body> properties width and height. Do they conform to your
paper dimensions. And even if they do, is the 'can grow' option on in your
fields? Sometimes this can push your report past your defined margins and
create an extra page.
--
Message posted via http://www.sqlmonster.com|||I've had this problem a few times...make sure that your report width is small
enough to fit on one page. Try to keep it under 22.75cm wide. The extra page
is just the edges wrapping around to the next page.
"Nat Johnson" wrote:
> OK still having the problem of a blank page after every report. I have reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is sorted.
Friday, March 9, 2012
Password not remembered SQL Server 2005
12 months since last use!
Is there any way to open server without re-installing to reset password.
Try logging on to the server as the local OS system administrator; that should get you the privileges to change the password without re-installing. Make sure for that session that you connect with Windows authenticaion instead of SQL authentication.Wednesday, March 7, 2012
password expiry with HTTPS merge replication
Hi
We are using anonymous HTTPS merge replication.
The windows password used for the client subscriber expired on the publisher.
I reset it on the publisher - but SQL still seems to think that it is not expired - I get the following message in the event log of the publisher running SQL Server 2005
Login failed for user 'XYZ'. Reason: The password of the account has expired. [CLIENT: <local machine>]
Any ideas ?
thanks
Bruce
Two things to try:
1. Reset IIS and attempt to sync again
2. Since you are saying you use anon auth, I believe merge agent is not passing any credentials, just ensure that there is no other auth enabled on IIS.
Also I would suggest against anon authentication and instead use Basic authentication. And maybe you are using your domain\account in the anon auth instead of machine account? That would be more insecure. Strongly suggest you use basic authentication.