My report was beautiful until I put groups around my two tables... actually
at first it looked fine... then I started changing text box sizes etc...
suddenly every second page in my report is blank... not in the viewer... when
I export to PDF... anyone know a RS exorcist?A bit silly to reply to my own post... but maybe someone else will run into
this problem... and it can be frustrating so here's how I fixed my problem...
1st off... a "page" in html isn't exactly the same size as a page in PDF...
a page in PDF has to be the same size as your paper... or less... I don't
know if html even has an exact page size limit... NEways...
The report designer in Visual Studio will increase your page size... if you
try to move a control outside of the space you have set... a pretty annoying
feature if you ask me... given that you usually want a page size to be
exactly the same forever... and sometimes you are playing with a long text
box, and you might not see the part off to the side increasing your page
width.
Does anyone know... is there a way to lock the page size?
"MER78" wrote:
> My report was beautiful until I put groups around my two tables... actually
> at first it looked fine... then I started changing text box sizes etc...
> suddenly every second page in my report is blank... not in the viewer... when
> I export to PDF... anyone know a RS exorcist?
Showing posts with label changing. Show all posts
Showing posts with label changing. Show all posts
Monday, March 26, 2012
Wednesday, March 7, 2012
password for the domain user
My SQL Server is running as a Domain user account and it asked me to enter the password for thr Domain user account when I was changing the Startup account from Local to Domain user.
My QUESTION here is:
Is there a way or command for me to change the password automatically on the Services account, if I change the password for the Domain User account/.None that I know of. I have to track manually wherever I use a domain account, and when I change the password I have to hunt them down and change them (one by one).
-PatP|||you can go directly to the user account in active directory users an computers set the service account's "Password Never Expires" property to true and it will never ask you to change it...
[Windows Support Center (windows Help)]: User and Computer Accounts
Password never expires Prevents a user password from expiring. It is recommended that Service accounts should have this option enabled and should use strong passwords. For more information about strong passwords, see Strong passwords.|||Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way.|||Originally posted by sqlserver2k
Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way. If you find it, please let me know!
-PatP|||wmi scripting will hook you up....
Set objUser = GetObject _
("LDAP://cn=myerken,ou=management,dc=fabrikam,dc=com")
objUser.ChangePassword "i5A2sj*!", "jl3R86df"
you could set this up as an MSX Job
create it run it then delete it
THIS (http://www.microsoft.com/technet/community/scriptcenter/default.mspx) is one of the best site for WMI Admin Scripts
My QUESTION here is:
Is there a way or command for me to change the password automatically on the Services account, if I change the password for the Domain User account/.None that I know of. I have to track manually wherever I use a domain account, and when I change the password I have to hunt them down and change them (one by one).
-PatP|||you can go directly to the user account in active directory users an computers set the service account's "Password Never Expires" property to true and it will never ask you to change it...
[Windows Support Center (windows Help)]: User and Computer Accounts
Password never expires Prevents a user password from expiring. It is recommended that Service accounts should have this option enabled and should use strong passwords. For more information about strong passwords, see Strong passwords.|||Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way.|||Originally posted by sqlserver2k
Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way. If you find it, please let me know!
-PatP|||wmi scripting will hook you up....
Set objUser = GetObject _
("LDAP://cn=myerken,ou=management,dc=fabrikam,dc=com")
objUser.ChangePassword "i5A2sj*!", "jl3R86df"
you could set this up as an MSX Job
create it run it then delete it
THIS (http://www.microsoft.com/technet/community/scriptcenter/default.mspx) is one of the best site for WMI Admin Scripts
Subscribe to:
Posts (Atom)