Error:Create failed for Login 'username' in sql server

Posted By  dotnetfish On 16 Oct 2010 10:10:34
emailbookmarkadd commentsprint
No of Views:1297
Bookmarked:0 times
Votes:0 times

Introduction

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) 

Image Loading

How to solve?

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. 

Image Loading

Problem solved.Hopes help.

Sign Up to vote for this article
Other popular Tips/Tricks
    Comments
    There is no comments for this articles.
    Leave a Reply
    Title:
    Display Name:
    Email:
    (not display in page for the security purphase)
    Website:
    Message:
    Please refresh your screen using Ctrl+F5
    If you can't read this number refresh your screen
    Please input the anti-spam code that you can read in the image.
    ^ Scroll to Top