sql server clients: I am trying to create user in SQL Server 2005 Express Edition but I was
failed to do so.

here is the error.

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Login 'wt'. (Microsoft.SqlServer.Express.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The MUST_CHANGE option is not supported by this version of Microsoft
Windows. (Microsoft SQL Server, Error: 15195)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=15195&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Hi Rogers,

Were you trying to run a script to create a user or were you using the
GUI?

Is the server in Windows Authentication mode or Mixed mode?

Through UI and there is Mixed Mode ... using Express Editions

Thanks

[quoted text, click to view]

Hi Rogers,

When you are creating the user, do you have the option set to force the
user to change their password upon next login (it's called "User must
change password at next login")?

I believe that the cause of the error might be that you are forcing the
user to change their password on next login (as indicated by the
"MUST_CHANGE option is not supported...." in the error message you
posted).

Turning this option off should fix the problem.

Hope that helps

thankx a lot

its solved my problem.