Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL toolset to find the SQL service accounts and their passwords Expand / Collapse
Author
Message
Posted Friday, January 28, 2011 1:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 6:35 AM
Points: 65, Visits: 312
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
Post #1055587
Posted Friday, January 28, 2011 1:26 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:48 PM
Points: 934, Visits: 2,672
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

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
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1055593
Posted Tuesday, February 8, 2011 10:30 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1060829
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse