SQL Server 2005 Express keeps putting in a different password than the one I chose. I would check the properties on the login I want to change. Then I change the password and it gets accepted. When I try my web application, I get the dreaded "login failed for <loginname>". I look at the properties again and see my password never change. Is this a bug? I ever tried this syntax to no avail:
CREATE LOGIN <loginname> WITH PASSWORD='<mypassword>' CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
Can you provide some additional information, such as:
- what is the version of the operating system that you are working on?
- how do you check the login password - how do you know it was not set properly? what properties are you checking?
If you get a "Login failed" error, check the SQL Server errorlog as well. It should contain an error state, which can provide additional information on the cause of the error. Please post that error code so that we can determine if the failure is caused by using an incorrect password or some other reason.
Thanks
Laurentiu
In addition to that, the error codes can span a various set of numbers, depending on the error got back. Even in the SQL Server 2005, there are many codes concerning the security features:
Look in here:
http://msdn2.microsoft.com/library/ms131024.aspx
HTH, Jens Suessmeyer.
No comments:
Post a Comment