Password change

Hi,
How do I set up sercurity enforcement to have users change their sql
passwords every 30 days?
Thanksmecn,
SQL Server adopts its policies from the Windows local policies. So, I
believe that you would have to change those.
(But, if your servers are having their policies synchronized with the domain
policies, I don't know if your changes will stick locally.)
RLF
"mecn" <mecn2002@.yahoo.com> wrote in message
news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I set up sercurity enforcement to have users change their sql
> passwords every 30 days?
> Thanks
>|||In 2005 you do it in the CREATE LOGIN 8or change with ALTER LOGIN) command. In 2000, you can't do
that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I set up sercurity enforcement to have users change their sql
> passwords every 30 days?
> Thanks
>|||My sql2005 is sql authentication. so the users are not windows based users
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%234wTN0IyHHA.4392@.TK2MSFTNGP04.phx.gbl...
> mecn,
> SQL Server adopts its policies from the Windows local policies. So, I
> believe that you would have to change those.
> (But, if your servers are having their policies synchronized with the
> domain policies, I don't know if your changes will stick locally.)
> RLF
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I set up sercurity enforcement to have users change their sql
>> passwords every 30 days?
>> Thanks
>>
>|||Thanks all
let me say it clearly, I need to enforce sql 2005 sql (authentication) users
to change their passwords every 30 days.
Is there a setting or check box that i could fill?
I don't know how.
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:F6BD45B2-27C2-4E6A-924E-FF9DDA37B970@.microsoft.com...
> In 2005 you do it in the CREATE LOGIN 8or change with ALTER LOGIN)
> command. In 2000, you can't do that.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I set up sercurity enforcement to have users change their sql
>> passwords every 30 days?
>> Thanks
>>
>|||Yes, I know. For SQL Server logins, SQL Server adopts the policies from the
Windows local server that is running the SQL Server. (Windows does its own
managing of Windows login policies.)
RLF
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uvKX38IyHHA.1208@.TK2MSFTNGP03.phx.gbl...
> My sql2005 is sql authentication. so the users are not windows based users
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%234wTN0IyHHA.4392@.TK2MSFTNGP04.phx.gbl...
>> mecn,
>> SQL Server adopts its policies from the Windows local policies. So, I
>> believe that you would have to change those.
>> (But, if your servers are having their policies synchronized with the
>> domain policies, I don't know if your changes will stick locally.)
>> RLF
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I set up sercurity enforcement to have users change their sql
>> passwords every 30 days?
>> Thanks
>>
>>
>|||Did you read about the CREATE LOGIN command in Books Online? If you do, you will find a parameter
which specifies that the Windows policy password expiration policy should apply to this SQL Server
login.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:u978YDJyHHA.4928@.TK2MSFTNGP03.phx.gbl...
> Thanks all
> let me say it clearly, I need to enforce sql 2005 sql (authentication) users to change their
> passwords every 30 days.
> Is there a setting or check box that i could fill?
> I don't know how.
> Thanks
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:F6BD45B2-27C2-4E6A-924E-FF9DDA37B970@.microsoft.com...
>> In 2005 you do it in the CREATE LOGIN 8or change with ALTER LOGIN) command. In 2000, you can't do
>> that.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message news:OdDICuIyHHA.5888@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I set up sercurity enforcement to have users change their sql
>> passwords every 30 days?
>> Thanks
>>
>