Failed to create user login

This is the error message i keep getting when following the SQL Server tutorial on how to make a new user;

TITLE: Microsoft SQL Server Management Studio Express

Create failed for Login 'employee'. (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

Why is that? Im running XP, do i need to be on 2000 Server or something?

This enhanced option is only available when SQL Server is installed on a Windows 2003 Server system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||i dont understand|||

OK, let me explain it to you. Prior SQL Server 2005, there have been no ways to control the password complexity or behaviour in SQL Server, which means that you could use a password like "aaa" or 123" or just a blank one. The options that are known from the Windows Domain like "Enforce password complexity" which only lets you create a password which is complex enough (containing enough characters / numbers / special characters) didn′t exists. Also the option "User must change password upon first connection" didn′t exists. With SQL Server 2005 these options have become available also for SQL Server passwords / users, but... you need to have Windows 2003 to enforce those rules as they are controlled by a group policy of Windows 2003. Any machine prior to WIndows 2003 won′t know the rules, therefore SQL Server thros an error, stating that these options are not available on the current platform SQL Server is installed on.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

If you really need to create this user of just a matter of study, what you could do is to select the SQL Server authentication and uncheck the "Enforce password policy". This way you will not get the error message, but remember that this is not a correct way to go.

Igor Pacheco