Home Forums SQL Server 2008 SQL Server 2008 - General SQL DBA knowing user passwords RE: SQL DBA knowing user passwords

  • November 20, 2014 at 3:37 pm

    #1759981

    Jeff Moden (11/20/2014)

    ZZartin (11/20/2014)

    There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who will need to configure that login and a user login.

    The DBA doesn't need to know the password of such accounts to maintain those same accounts.

    I'll also say that such accounts should also be Windows Logins and use Windows Authentication rather than SQL SERVER Authentication, just like any other user.

    Not always possible. Some applications are (still) written so as to require a native SQL login to function.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.