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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2014-08-11 : 20:51:30
|
| Can anyone tell using SQL Querying to find the SA Password. Thanks All. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-08-12 : 01:59:04
|
It's not possible directly and it also violates the license.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-08-12 : 05:07:59
|
| Believe it or not some servers are setup where the password is blank, you might want to check no password, other than that talk to your server guys.We are the creators of our own reality! |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-08-12 : 09:00:09
|
| Check the original install scripts.Worst case, if possible , change the sa password , using another account with sysadmin priveleges. There are some risks associated with this taskJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-08-12 : 09:18:43
|
| Only change the password if you are certain no apps are using it and is out of normal hours.We are the creators of our own reality! |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2014-08-12 : 18:20:27
|
Thanks Peers with your answers as I still ordered to Document these passwords to be treasured, for that sake I need to QUERY and get them which have been installed on these servers.Any help please  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-12 : 19:02:53
|
quote:
Originally posted by pdset
Thanks Peers with your answers as I still ordered to Document these passwords to be treasured, for that sake I need to QUERY and get them which have been installed on these servers.Any help please
NO. This is not something we can help you with, especially the Microsoft MVPs here who are required to follow certain professional behaviors with our online presence. Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2014-08-12 : 20:07:12
|
| Thank MYouVP |
|
|
|
|
|
|
|
|
SA Password