SQL Server Performance Forum – Threads Archive

Locking/Unlocking, expiring userids in SQLServer

Hi there, Just wondering if there is any concept of locking/unlocking user accounts and expiring passwords for user accounts in the SQLServer database? It should be independent of OS locking and expiration. Thanks & regards,
Kanthi

If you use Mixed authentication and password expiration will be dependant on the Windows policy and if you change on windows side, it must be affected for SQL login also. http://www.databasejournal.com/features/mssql/article.php/1582981 for information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya, All my servers are in mixed mode. Does it mean that locking/unlocking password expirations only affect the OS ids that have access to SQLServer and not the database specific ids ? That is, there is no mechanism from the database side to exclusively lock/unlock, expire passwords of the database ids which are OS independent like the other RDBMS oracle, sybase ?? Thanks & regards,
Kanthi

You would have to write it in the current version of SQL Server. SQL Server 2005 has support builtin for it. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

If the security policy from the Windows compels to change the user password then the same should be affectd on SQL side also, as specified. Otherwise the users will get login failures and as referred there is no internal mechanism upto SQL 2K SP3a to control the password expirations via SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>