SqlServer-QA.net

Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords. When password complexity policy is enforced and password expiration ...

Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server:  Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand it. Expand the Logins folder. Right-click on the desired login and click ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows ...

As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in safe. The easiest way around this is to logon to the actual SQL Server NT machine itself as ...

I haven't seen any probability of revealing password by using any method in SQL server, if you have SYSADMIN privilege login then you could try resetting password for that troubled login.  If not you can try running SP_HELP_REVLOGIN sp that will string out the password in HASH format.

As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the NetValidatePasswordPolicy API, which is only available in Windows Server 2003 and later ...