TSQL

Question

i want to ask a question that was asked to me,i tried several links but not satisfied,so please help me with the answer:

if i m working on sql server 2005 and in case i forgot my password and cant login.

i am having only my username but not password can the DBA provide me with the same password that i was having before

or is there any option to recover the same password

Answer 1

No, I think same password cant be retrieve.

 

---

--------------------------------- Devender Bijania

Answer 2

If DBA was storing the pass somewhere then YES, otherwise NO

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

thanx sir but i want to ask u one more thing that does encryption or  decryption security has any link to recover the password.

Answer 4

No, but search on internet for some third party tools to provide such possibilities

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 5

thanx sir but i want to ask u one more thing that does encryption or  decryption security has any link to recover the password.

When you create a login, SQL Server hash the password using SHA-1 cryptographic hash function and store the hash result in the master database(you can access the hash result via sys.syslogins system view). And, when you log on to SQL Server next time, SQL Server also hash the password you input and compare it to the one on the master database.

So, the question you have asked seems like to be that how to get the password if we know its hash value(hashed by SHA-1 cryptographic hash function). From my point of view, this is not easy.

Hope this helps.

---

Best Regards,
Chunsong Feng

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.