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 |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2006-06-19 : 15:14:38
|
| Hi,I am new to this job and tool used for reseting user password is broken and there is no clear doc for the table relationship.But I need to immediately reset the password for one user. I Updated the user table with my password. This not working. I am not able to login with new user name with new password. The password is encrypted.hereis codeupdate Table1set pwd = (select ltrim(rtrim(pwd) from table1 where loginId = 'myname')where loginId = 'newuser'Pls help asap.thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-19 : 15:17:17
|
| If the password is encrypted, then you'll need to figure out the encryption. There is no way for us to help you with this as we don't know how it was encrypted. Even if we knew what encryption algorithm they used, we'd still need to know the key to unlock it. You need both in order to figure this out. I'd suggest talking with the person who wrote the application.Tara Kizeraka tduggan |
 |
|
|
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2006-06-19 : 15:28:27
|
| Is there a way to find from Sql server side because the person already left the job and now I am with this. Just coying will not do the magic |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-19 : 15:35:23
|
| If you just want to copy the password from your userid to another person's userid, then don't ltrim, rtrim it. update Table1set pwd = (select pwd from table1 where loginId = 'myname')where loginId = 'newuser'If that doesn't work, then you are out of luck unless you crack open the code.Tara Kizeraka tduggan |
|
|
|
|
|
|
change encrypted password