I'm newbies in microsoft SQL
I did try to create a new login using "SQL server authentication" option and it failed
According to the error message the "SQL server authentication" is not supported by Microsoft SQL Server Management Studio Express. Is it true
Also When I did install SQL 2005 express I did check The "SQL server uthentication" and supply user and password but it does not appear in Microsoft SQL Server Management Studio Express under security/logins.
Here the error message. Can someone help me
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Login 'lebeluet'. (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)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15195&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
SQL server authentication / app microsoft SQL management studio express
NeoRJ
Hi,
The Message:
"The MUST_CHANGE option is not supported by this version of Microsoft Windows. (Microsoft SQL Server, Error: 15195)"
means that you are not working on a WINDOWS 2003 Server. THe implementation of SQL Server 2005, brought us a much wider sort of security mechanism, like exiring passwords, complexity rules etc. but they can be only used on a WIndows 2003 Server. Unless you don’t have one, I would uncheck the checkbox (User must change the password") as thisid throwing the error message.
HTH, jens Suessmeyer.
Monsterplow
It work's now when I did uncheck the checkbox (User must change the password")
Thanks