Something that I have identified recently at several sites is clients being prompted for password confirmation after changing a standard SQL Server login. This has been identified as a bug and can be corrected with the fix in the following KB article http://support.microsoft.com/?kbid=826161
