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 |
|
born2acheive
Yak Posting Veteran
65 Posts |
 Posted - 2006-12-28 : 06:24:41
|
| hi,i need query to get my sqlserver username and password,please can any one give query for this |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-28 : 06:39:33
|
| [code]Select [name], [password]from master..sysxlogins[/code]But that won't be of much use since all you will get is password hash. Why you need this?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-12-28 : 10:03:07
|
| Have your DBA reset your password.If you have lost the sa password, then log into the server as an admin and you should be able to reset it.STAR SCHEMAS ARE NOT DATA WAREHOUSES! |
|
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-28 : 22:35:24
|
| hi harsh_athalye i used your query but password is encrypted.select [name], [password] from master..sysxloginsname passwordBUILTIN\Administrators NULL JET12\Administrator NULL sa 0x010022372078FC7B35E92420E9B6F03014C846DA9AE5760961584F98BCCB12D3DCE4DD96BDBB1ED0708A12B7064C NULL NULL like this comming.please tell me how to get the password becos here the password is encrypted. |
|
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-29 : 00:06:53
|
| can anyone please answer for my question |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-12-29 : 00:29:01
|
you can't recover forgotten passords. all you can do is reset them.
www.elsasoft.org |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-29 : 00:46:01
|
if u need the password at any cost then please use any 3rd party tools to recover the password.plz find the link which is one of the popular ones:http://ms-sql-password-recovery.qarchive.org/ its me monty |
|
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-29 : 03:35:45
|
| thankyou friends for cute replies |
|
|
|
|
|
|
how to get my sqlserver password