Search results for 'app:weblogs' matching tags 'password' and 'Authentication'

SQL Server security: How easy it is to troubleshoot Login failed for user ‘(null)’ kind of errors?

Anonymous — Wed, 22 Sep 2010 05:00:00 GMT

Whenever we talk about login errors it is nothing but SQL Server is not allowing any authentication for that login to connect. The basic principle followed by SQL Server authentication rlies on the internal user list and based upon the authentication type you define the connectivity will be succeeded. Like my fellow MVP Pinal Dave said some errors never got old, and it is one of the frequently asked questions in SQL Server forums about the following error messages (you might have come across too):...(read more)

SQL Server logins - enforce Password Expiration and policies

Anonymous — Mon, 07 Jan 2008 06:00:00 GMT

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 Properties . In the left pane of the Login Properties window, select General . Check if he Enforce password expiration checkbox is checked. Similarly to review the password policies...(read more)