Announcement

Collapse
No announcement yet.

How to audit SQL Server DB for DOMAIN\Administrator usage ?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to audit SQL Server DB for DOMAIN\Administrator usage ?

    Hi All,

    I'd like to know what should I pay attention in the database when I rename the DOMAIN\Administrator into other name and change its password ?

    let me know where to look for so that I know where to anticipate it first.

    Thanks.

  • #2
    Re: How to audit SQL Server DB for DOMAIN\Administrator usage ?

    it's based on SIDs mate
    Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

    Comment


    • #3
      Re: How to audit SQL Server DB for DOMAIN\Administrator usage ?

      If you see SID, tell him

      To elaborate, assuming you have Windows authentication (or mixed mode using a windows account), you can rename the account and change the password and SQL server will pick up the correct information from AD
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd
      Scotland

      ** Remember to give credit where credit is due and leave reputation points where appropriate **

      Comment

      Working...
      X