Powershell-Modules icon indicating copy to clipboard operation
Powershell-Modules copied to clipboard

Published 20 hours ago • verified publisher icon NetSPI

Default database for DAC

Open martkopecky opened this issue 6 years ago • 0 comments

If the user you are using for the DAC does not have the default database set to master, the SQL query "SELECT substring(crypt_property,9,len(crypt_property)-8) FROM sys.key_encryptions WHERE key_id=102 and (thumbprint=0x03 or thumbprint=0x0300000001)" returns empty resultset.

Please add catalog name to the from clause: ...FROM master.sys.key_encryptions ...

martkopecky avatar Jun 20 '18 17:06 martkopecky