How to crack SA password for SQL Server 2012
Question
Thursday, February 18, 2016 6:55 PM
Hi SQL Server Expert,
I have one sql server 2012 that being configured on one of our production Navision server. usually, we are able to login using the default SA password, so we could add in new users or perform any administrative tasks. currently, we have forgotten the password. May I know is there anyway or tools to crack the SA password?
Thanks.
All replies (4)
Thursday, February 18, 2016 7:12 PM ✅Answered
hi Henry
you don't need to crask the SA password.
you can start SQL Server service in a special mode with administrative privilege and reset that password.
see SQL Server 2012: Password emergency
or search support / kb microsoft site.
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Friday, February 19, 2016 9:06 AM ✅Answered
I have one sql server 2012 that being configured on one of our production Navision server. usually, we are able to login using the default SA password, so we could add in new users or perform any administrative tasks. currently, we have forgotten the password. May I know is there anyway or tools to crack the SA password?
As a normal SQl Server guy I am not aware about how to *crack* sql server SA password and I dont think there is ethical way to do it. But yes as already suggested you can see How to Login into SQL Server when sysadmins are locked out
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Friday, February 19, 2016 9:18 AM
There is no way to crack the password but you can just reset it if you have any other Sysadmin account
Monday, March 7, 2016 12:47 PM
I have one sql server 2012 that being configured on one of our production Navision server. usually, we are able to login using the default SA password, so we could add in new users or perform any administrative tasks. currently, we have forgotten the password. May I know is there anyway or tools to crack the SA password?
As a normal SQl Server guy I am not aware about how to *crack* sql server SA password and I dont think there is ethical way to do it. But yes as already suggested you can see How to Login into SQL Server when sysadmins are locked out
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Hi Shanky,
Thanks.
I will try the solution provided.
Regards,