Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
voodoo9055
Starting Member
3 Posts |
 Posted - 2006-01-13 : 10:14:23
|
SQL Server 2005 Express will not allow me to change the password for my login user. I tried deleting the user and re-creating the user. Another password is being put in although the password I put in was accepted. I even test to see what would happen if I left the password blank. It got accepted. But when I look at the password for my login user again, a different and much longer password was put in. I even tried this T-SQL statement:CREATE LOGIN <loginname> WITH PASSWORD='<passwordname>', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFFI am out of ideals.  Is this a bug? |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-13 : 12:00:41
|
| Hi,What is the error you are getting when you try to change your password? How are you “looking at the password”? In Yukon the password hash columns will never be null - the passwords are not stored/displayed in plain-text but as a hashed value.Does the password you entered work?ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
voodoo9055
Starting Member
3 Posts |
Posted - 2006-01-13 : 12:51:07
|
| Hello Paul. That is part of the problem. I am not getting any errors. To get to the password, I simply right clicked on the login I want to work with and then clicked Properties. When the Login Properties window is open, I have the ability to change the password (with a confirmation). A course I can't see the password because it is masked, but I can tell it is longer than the password I put in. I left Enforce password policy unchecked. The other options are also unchecked although they are not editable. So I enter my new password for my login user and click "OK". It executes and closes out the window. When I look inside again, the orginal password is still in there. If I try to execute the T-SQL statement, I get the "Command(s) completed successfully". However, if I look at the Login Properties for that login, the password is still unchanged. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-13 : 13:58:47
|
| What do you mean by 'look inside again'?If you logout and try to login again, which password works? The old one or the new one?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
voodoo9055
Starting Member
3 Posts |
Posted - 2006-01-13 : 14:12:12
|
| When I say look inside again, I mean my look inside of the Login Properties again. That unknown password is still in there. I have no ideal what it is. SQL Server 2005 Express is not updating the password although I tried to change it. I have an ASP.Net 2.0 application that won't run because the password in the connection string is not being updated for the sql login account I have set up. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-13 : 18:51:20
|
| The different UIs may not change the number of *s used to represent a password, even though the password has changed.Are you expecting the ASP connection string to be automatically updated when you manually change the password in Express? If so, I don't believe this should happen. Does it work if you change the connection string yourself?ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
|
|
Can't change sql login user's password