Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1

[Auguy]

I can sign in to SSMS with windows authentication as an administrator.
I don't want to change the sa password, I just find out what it is if possible.
I've seen many ways to try and recover or change it but would rather just find out what it is.
Is there a way to do this?
I can see this might not be possible due to security reasons.

Auguy
Sylvania/Toledo Ohio

 

[gmmastros]

Your best approach would be to create another login (not sa) that has sa permissions. Of course, with a password that you know.



-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Auguy]

Thanks George, I may go that route.

Auguy
Sylvania/Toledo Ohio