DOMAIN\HOSTNAME$ Logins

• myalliku

  SSC Eights!

  Points: 869

  More actions

  June 2, 2016 at 1:54 am

  #151567

  Hello,

  I take over a new production SQL Server from different department. When I check sql server logins, I saw a username like DOMAIN\HOSTNAME$ which has right security admin.

  Is anyone know about this? Is anyone who come from DOMAIN\HOSTNAME$ can connect to SQL Server with security admin rights ?

  Thank you..

• FridayNightGiant

  SSCertifiable

  Points: 7151

  More actions

  June 2, 2016 at 7:59 am

  #1882819

  That is the AD account for the server. I believe any Services running under the Network Service account will use this account.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  June 2, 2016 at 8:41 am

  #1882843

  Services running under LocalSystem should show up like this as well.

  Joie Andrew
  "Since 1982"

• myalliku

  SSC Eights!

  Points: 869

  More actions

  June 3, 2016 at 7:18 am

  #1883079

  Thank you friends for this informations.

  I want to detail about this question.

  There is an application server which hostname is XXX, and there is an database server which hostname is YYY. When I check SQL Server logins in YYY, I see DOMAIN\XXX$.

  So is that meaning, Services running under XXX 's Local System and Network Service can access to SQL Server in YYY? So, If I dont want applications running under Local System / Network Services in XXX access to SQL Server in YYY, I must start these services using specific account. Am I right?

  Thanks in advance.