SQL toolset to find the SQL service accounts and their passwords

  • 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

  • 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
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • 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."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply