Feeds:
Posts
Comments

Posts Tagged ‘Sql Authentication based logins or Windows/Domain based logins’

Quick one today:

In Sql Server, under logins, sometimes we see these funny looking logins with pound signs or hash signs (##) on both sides. See the image below:

Logins_with_pound_signs

In Sql Server, when we create logins, we could create Sql Authentication based logins or Windows/Domain based logins; along with this we could also create Certificate based logins. Such Certificate based logins that are internal to Sql Server have these pound ## signs on both sides. Ex: The installation process will create users like:

  • ##MS_PolicyEventProcessingLogin##
  • ##MS_PolicyTsqlExecutionLogin##
  • ##MS_AgentSigningCertificate##
  • etc
Hope this helps,
_Sqltimes

Read Full Post »