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 |
|
larhmich
Starting Member
2 Posts |
 Posted - 2014-07-08 : 10:40:58
|
Guys,I have a problem with a program that use SQL server, when Install it I forgot the admin password of my program, I try to recet it by make a new Crypted password, but he don't workCan any one of you help me on this please?Picture of the old password crypted Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-07-08 : 10:46:34
|
| What you are seeing is the encrypted password. You cannot un-encrypt it. If you have another login with admin privileges, reset the password using the normal method (In SSMS object explorer, under security -> Logins tab, right click on the login name and properties).If you don't have another admin user, use DAC connection. This page and links on it explain how to. http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspxYou need to be logged on the box on which SQL is installed as an administrator. |
 |
|
|
larhmich
Starting Member
2 Posts |
Posted - 2014-07-08 : 10:59:41
|
| Hello M James,this is not an sql user, i mean a row in the Admin tables with columns ' id,username, password 'so if you want to update password, you must execute the command " upldate table_admin set password='' where username=''but the password is crypted with base64 and when i try to set another password and try to login i cannotpleasse see the screenshot in my thread |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-08 : 12:33:50
|
quote:
Originally posted by larhmich
Hello M James,this is not an sql user, i mean a row in the Admin tables with columns ' id,username, password 'so if you want to update password, you must execute the command " upldate table_admin set password='' where username=''but the password is crypted with base64 and when i try to set another password and try to login i cannotpleasse see the screenshot in my thread
You are out of luck unless you can figure out how to decrypt it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
problem with password