Re: Password expired
- From: "Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 08:11:50 -0700
So passwords never really expire? Cool!
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns99339BA797939Yazorman@xxxxxxxxxxxx
[posted and mailed]
Magnus (magnus.blomberg@xxxxxxxxxx) writes:My users SQL passwords expires after 90 days and that's what I want. The
problem is that I want the user to be able to change their password when
this happends.
I developed a small application for this purpose, but I can't get it to
work.
There are an asp.net page with five textboxes: server, loginname,
oldpassword, newpassword, and confirmnewpassword.
Despite what Roger and vt says, this is indeed possible. You simply connect
to SQL Server and in the connect string you pass the new password in the
Password property. The old password you pass in the Old Password property.
For instance:
PROVIDER=SQLNCLI;Server=ThatServer;Database=ThatDatabase;UID=ThisUser;
Password=SprillansNytt;Old Password=FörraÅrets
Note that you must use the SQLNCLI provider, as SQLOLEDB does not support
the Old Password property.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Password expired
- From: Magnus
- Re: Password expired
- From: Erland Sommarskog
- Password expired
- Prev by Date: Re: Roles in 2005
- Next by Date: Re: Decryption within an application
- Previous by thread: Re: Password expired
- Next by thread: Re: Password expired
- Index(es):
Relevant Pages
|
|
