Tag: SQL Server Service Account

• How to Create a Service Master Key in SQL Server

  

  2014-04-25 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how the service master key is created, what it protects and how it is protected itself, and learn about the two important security implications that arise from the protection mechanism used.

  [more…]

• How to identify the SQL Server Service Account in T-SQL

  

  2014-01-23 - General, Security

  In SP1 for SQL 2008R2 a new DMV was introduced: sys.dm_server_service. It provides information about SQL related services including the service account name. Read on to get all the details.

  [more…]