It turns out that SQL Server 2005 users have a default setting of password expiration, and if not disabled after a certain time the password expires and the clients are unable to connect to the SQL Server with the error of user permissions. Disabling password expiration for the user sorts out the problem.
Filed under: Uncategorized
