Search This Blog

Thursday, January 24, 2008

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

I was trying to create a user with weak Login Name and password. Error message below shown.

Create failed for Login 'xxx'. (Microsoft.SqlServer.Express.Smo)
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)





What i do is uncheck the "Enforce password policy" when create the new user. This way you will not get the error message, but this is not the recommended way for the production Login Name and Password.





Problem solved.

6 comments:

MBiker80 said...

Awesome. That worked. Thank you for your post!

Anonymous said...

THANKS..

vicky said...

i dont works....it gives message you dont have permissions and error:15247....please help...

In blues said...

Hi Vicky, most probably you are not using the system administrator login. Please get system administrator to do that.

BiMTse said...

it works for me , thanks :D

BiMTse said...

it works for me, THANKS (with caps lock) :D