IntroductionI 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) 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. Problem solved.Hopes help. |