Re: Password expired
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 13:17:32 +0000 (UTC)
[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
.
- Follow-Ups:
- Re: Password expired
- From: Magnus
- Re: Password expired
- From: Roger Wolter[MSFT]
- Re: Password expired
- References:
- Password expired
- From: Magnus
- Password expired
- Prev by Date: Re: Problem with SQL Server 2005 Express Edition
- Next by Date: Re: Roles in 2005
- Previous by thread: Re: Password expired
- Next by thread: Re: Password expired
- Index(es):
Relevant Pages
|
