Change password when password has expired.

anordlun · Post by **anordlun** » Thu 01 Nov 2007 12:59

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

Antaeus · Post by **Antaeus** » Thu 01 Nov 2007 15:56

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.

anordlun · Post by **anordlun** » Mon 21 Jan 2008 10:01

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.

Antaeus · Post by **Antaeus** » Tue 22 Jan 2008 12:52

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.