Showing posts with label local. Show all posts
Showing posts with label local. Show all posts

Friday, March 30, 2012

Margin rendering

When running a SSRS 2005 Report on local machines (running Windows XP) A certain Textbox Label is not wrapping and is sized with .25 inch blank spacing at the end of the text. When running thru a datadriven Subscription this label is wrapping to next line on the PDF file that is produced.

We went to the SSRS 2005 server( Windows server 2003) and opened the report and it shows this label wrapping and the text is not fitting in the label box. But on every client box that we open this report on it shows it not wrapping. Is there a setting on the Server that we need to set for this report to render correctly.

Hi Brad,

A couple questions for you:

1) Are all machines running the same version of SSRS?

2) Are you exporting to PDF in all cases?

3) Do the various servers on which the different reports run have differing DPI settings?

Many thanks,

Chris

Monday, March 19, 2012

Manually configuring SPN when SQL Service account is local non-adm

Hi,
We are running SQL Server 2005 with a local low-privileged service account.
I would like to register the SPN (manually) to enable kerberos authentication.
The domain admin gets the error message "Unable to locate account <Service
Account Name>" when running the setspn command.
I can only find examples for configuring the SPN when the SQL Service
account is a (non-admin) domain user account or a local administrator account.
Does anyone know whether it is possible or not to enable kerberos
authentication when running SQL Server 2005 with a local low-privileged
service account?
Thanks!
Kai A
No. A local account is not an Active Directory account.
-Sue
On Tue, 13 Feb 2007 06:01:02 -0800, Kai A
<KaiA@.discussions.microsoft.com> wrote:

>Hi,
>We are running SQL Server 2005 with a local low-privileged service account.
>I would like to register the SPN (manually) to enable kerberos authentication.
>The domain admin gets the error message "Unable to locate account <Service
>Account Name>" when running the setspn command.
>I can only find examples for configuring the SPN when the SQL Service
>account is a (non-admin) domain user account or a local administrator account.
>Does anyone know whether it is possible or not to enable kerberos
>authentication when running SQL Server 2005 with a local low-privileged
>service account?
>Thanks!
>Kai A
|||Thank your very much for your answer!
However, I do not understand why one can register a local admin account in
AD and not a local low-privileged one? A local admin account is not an AD
account either?
This describes how one can register a local admin sql server service account
in AD:
http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx :
"d. If your sql server is running under a local machine admin account, you
can (...)run setspn under your domain credential to add the SPN."
Thanks!
Kai A
"Sue Hoegemeier" wrote:

> No. A local account is not an Active Directory account.
> -Sue
> On Tue, 13 Feb 2007 06:01:02 -0800, Kai A
> <KaiA@.discussions.microsoft.com> wrote:
>
>

Manually configuring SPN when SQL Service account is local non-adm

Hi,
We are running SQL Server 2005 with a local low-privileged service account.
I would like to register the SPN (manually) to enable kerberos authenticatio
n.
The domain admin gets the error message "Unable to locate account <Service
Account Name>" when running the setspn command.
I can only find examples for configuring the SPN when the SQL Service
account is a (non-admin) domain user account or a local administrator accoun
t.
Does anyone know whether it is possible or not to enable kerberos
authentication when running SQL Server 2005 with a local low-privileged
service account?
Thanks!
Kai ANo. A local account is not an Active Directory account.
-Sue
On Tue, 13 Feb 2007 06:01:02 -0800, Kai A
<KaiA@.discussions.microsoft.com> wrote:

>Hi,
>We are running SQL Server 2005 with a local low-privileged service account.
>I would like to register the SPN (manually) to enable kerberos authenticati
on.
>The domain admin gets the error message "Unable to locate account <Service
>Account Name>" when running the setspn command.
>I can only find examples for configuring the SPN when the SQL Service
>account is a (non-admin) domain user account or a local administrator accou
nt.
>Does anyone know whether it is possible or not to enable kerberos
>authentication when running SQL Server 2005 with a local low-privileged
>service account?
>Thanks!
>Kai A