Page 1 of 1

Change password when password has expired.

Posted: Thu 01 Nov 2007 12:59
by anordlun
Hi.
Version : 3.20.10

If I have password policy added on the SQL2005 server and my password has expired, How do I change the password?

The SQLServer stops me from logging in and therefore I'm unable to change the password


Edit: I'm using the TCRSQLConnection class

//Andreas

Posted: Thu 01 Nov 2007 15:56
by Antaeus
There is no such functionality in SDAC 3. It was added in SDAC 4 (TMSConnection.ChangePassword).
You can either upgrade to SDAC 4, or find another way to do this. For example see this topic in MSDN.

Posted: Mon 21 Jan 2008 10:01
by anordlun
Hi again.
I've upgraded to dbExpress (dbexpsda.dll) 4.20.0.6 and have the same problem now. I'm not able to change expired passwords.

Posted: Tue 22 Jan 2008 12:52
by Antaeus
Because of dbExpress specific, this functionality is not supported in DbxSda. This functionality is supported in another our product - SDAC. SDAC supports changing passwords since fourth version.