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:
Awesome. That worked. Thank you for your post!
THANKS..
i dont works....it gives message you dont have permissions and error:15247....please help...
Hi Vicky, most probably you are not using the system administrator login. Please get system administrator to do that.
it works for me , thanks :D
it works for me, THANKS (with caps lock) :D
Post a Comment