sql serverwindows-server-2008
I have to set Account Lockout Threshold to some specific value In MSSQL Server 2008. How can i do this? I have googled and not able to find the exact solution how to do it.
Whether SQL server account uses default Windows threshold to lock the sql account?
Thanks in advance…
Santhosha
Like @SpaceManSpiff said, don't forget to check if Mixed mode is enabled. Someone changed that setting for me and I had the same problem. Here is how to solve it:
Source: http://forums.eukhost.com/f15/login-failed-user-sa-microsoft-sql-server-error-18456-a-12544/
The more secure method uses Windows authentication. This will allow you to write your application without a password included in any of the connection strings or config file.
One each system you will create a user account. This should not be an administrator account, just a regular user account. One both systems create the user with the same name and password.
Now on your IIS system edit the application pool settings. Change the identity to run as the user account that you just created. At this point you will need to type in the password for the user.
On the SQL server create a login account that is associated with the Windows use account that you have created. You can use the normal SQL Server permissions to grant/deny the actions that your application requires.
Now in your application connect to the SQL server using integrated security. The app pool user will be used when making the SQL connection.
No password in your config or app and a secure database connection!
Best Answer
SQL Server 2008 uses the password policy enforcement settings from the domain or local machine. To set it you need to edit the domain policy that applies to the SQL server if the SQL server is joined to a domain, or edit the local machine policy if the SQL server is not joined to a domain.