SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL toolset to find the SQL service accounts and their passwords


SQL toolset to find the SQL service accounts and their passwords

Author
Message
Shriji
Shriji
Mr or Mrs. 500
Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)

Group: General Forum Members
Points: 551 Visits: 318
Would there be a SQL toolset that would allow me to find the SQL service accounts and their passwords that are associated with a COTS product? This product uses SQL Server Express edition on the same server.

Thanks
Shriji
Shawn Melton
Shawn Melton
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9387 Visits: 3551
SQL Server Configuration Manager will show the services running on the server and their associated service account.

EDIT: If it shows Local System or NT AUTHORITY xxx, these are built-in system accounts to Window Server and you don't have to worry about the password for those. Microsoft is the only that knows it :-D

If it shows a local Windows account the passwords are * out so you cannot read them. If the SQL Express installation was built into the COTS installation you would probably need to go through the vendor to question them on changing it (so you know what it is) or being provided the information.

Shawn Melton
Twitter: @wsmelton
Blog: blog.wsmelton.info
free_mascot
free_mascot
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11009 Visits: 2250
This is with respect to security and if it's that's easy who will trust the SQL Server? It's database security after all :-)

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search