Questions tagged [service-master-key]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
0 answers
29 views

What is the meaning of principal that has access to the machine's credentials?

The service master key can only be decrypted by the service account under which it was created or by a principal that has access to the machine's credentials. What is the meaning of ...principal that ...
variable's user avatar
  • 3,360
0 votes
1 answer
36 views

How to validate whether the correct SMK has been restored?

Link: https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-service-master-key-transact-sql?view=sql-server-ver16 Assuming during a DR event I am provided with the SMK file, system db files ...
variable's user avatar
  • 3,360
3 votes
1 answer
143 views

Why isn't database decryption working after failing over to the standby?

We added a new node (N2) to our SQL Server 2019 cluster. On existing N1, decryption queries works fine but when we failover to N2, decryption is failing. The database master key on N1 is encrypted by ...
Sam's user avatar
  • 31
0 votes
0 answers
92 views

When rebuilding sql server on a new machine, should SMK be restored prior to or after restoring system dbs?

Service Master key is at top of sql server encryption hierarchy. Linked server, credentials, database master key (if any) are encrypted using the service master key. When rebuilding a sql server using ...
variable's user avatar
  • 3,360
-1 votes
1 answer
106 views

What is the concept of service master key in FCI?

In a single sql server instances, sensitive data like passwords in linked server and credentials are encrypted using the server master key. The key or objects can be decrypted only by the sql service ...
variable's user avatar
  • 3,360