Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Default database for DAC #7

Open
martkopecky opened this issue Jun 20, 2018 · 0 comments
Open

Default database for DAC #7

martkopecky opened this issue Jun 20, 2018 · 0 comments

Comments

@martkopecky
Copy link

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 ...
bugal added a commit to bugal/Powershell-Modules that referenced this issue Apr 11, 2019
@bugal
Included reference to master database on sys.key_encryptions. Fixes N…
0dc0ba6 
…etSPI#7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@martkopecky