Change password on next login error

napoleon

Hi All

I have alittle problem with my logins ,if anyone can assist please.
I'm currently using SQL 2005 and when i create a new user i put a tick on the checkbox for { User must change password at first login} . The error is :- [
=========================================
The following SQL Server error(s) occured:

18488,"42000", [ Microsoft ][ODBC SQL Server Driver][SQL Server]Login failed for user 'testuser'. Reason : the password of the account must be changed.
=========================================

If anyone can assist , greatly appreciated.

Regards
Bongani ](*,)

DenSter

I'd say don't check that box when you create a new user.