Re: how to change security settings

Thank you.

"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:%230a92rwgJHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
Keith,

Correct. The documentation on CREATE LOGIN says that CHECK_POLICY = ON:
"Specifies that the Windows password policies of the computer on which SQL
Server is running should be enforced on this login."

If you are running in a domain, it may be that your servers are, in turn,
set to adopt the domain policies.

RLF

"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:ulDir7vgJHA.5244@xxxxxxxxxxxxxxxxxxxxxxx
I cannot find the settings in SQL 2005 that allow me to change password
security policies (such as how many days before a user has to chagne
his/her
pwd). But I did find this:
http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102101,00.html
which indicates to me that those settings are not controlled by SQL but
by
the OS. Is that true?

To be clear, I'm talking about the SQL passwords, not the Windows
passwords.

Thanks,

Keith






.

Relevant Pages

  • Re: Same encryption codes cannot decrypt password from .NET 1.0 to 2.0
    ... And those passwords are stored in my SQL ... > server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Two questions about passwords.
    ... properties where you have it registered using a SQL login. ... Yes, assuming there is no SSL encryption involved, SQL logins and passwords ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • sql6.5 login/pswd transfer to 2k
    ... to migrate all SQL Server 6.5 Logins and their Passwords ... Server 2000 server. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 7.0 to SQL 2000
    ... Transfer Logins and Passwords Between Instances of SQL Server ... > We currently have a production box running Windows NT server with SQL 7.0. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Access security from Window Application
    ... you could have your app handle authentication by emulating the ... Currently my application access the SQL using ... >System.Data.SqlClient and all forms use stored procedures. ... >passwords in a protected file but this creates a problem on remote systems ...
    (microsoft.public.dotnet.general)