15581

Product Name

Event ID

15581

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SEC_NODBMASTERKEYERR

Message Text

Please create a master key in the database or open the master key in the session before

performing this operation.

Error 15581 is raised when SQL Server is not able to recover a database that is enabled for

transparent data encryption (TDE). An error message like the following is logged in the SQL

Server error log

2020-01-14 22:16:26.47 spid20s Error: 15581, Severity: 16, State: 3.

2020-01-14 22:16:26.47 spid20s Please create a master key in the database or open the

master key in the session before performing this operation.

This issue occurs when service master key encryption for the database master key in the master

database is removed when the following command is run:

ﾉ

Expand table

Use master go