No announcements
Found 4090420 threads
-
0 Votes[SQLServer2005] I don't have a database master key, I still can create a symmetric key.
The SQL Server Books Online (http://msdn.microsoft.com/en-us/library/ms188357.aspx) says: "when a symmetric key is encrypted with a password instead of the public key ...Answered | 1 Replies | 6836 Views | Created by Emerald214 - Saturday, November 13, 2010 7:55 AM | Last reply by Dan Guzman - Saturday, November 13, 2010 7:25 PM
-
2 Votes
Database restore & Symmetric keys
The other instance will have a different Server Master Key (SMK), but the Database Master Key (DMK) is tied to the database you are ...Answered | 4 Replies | 13123 Views | Created by york0001 - Thursday, November 19, 2009 3:04 PM | Last reply by Raul Garcia - MS - Thursday, November 19, 2009 7:31 PM -
7 Votes
SQL Symmetric key backup
Now i have create one database in DEV environment as below CREATE DATABASE ...Answered | 6 Replies | 16246 Views | Created by Samagra - Thursday, November 8, 2012 1:04 PM | Last reply by Thiruveedhula - Friday, May 3, 2019 4:54 PM -
0 Votes
Creating a Symmetric key
You are specifying the wrong key name to the KEY_GUID function ('textsymmetrickey' instead of 'testsymmetrickey').Answered | 3 Replies | 2812 Views | Created by DavidFast - Saturday, May 5, 2012 3:56 PM | Last reply by DavidFast - Saturday, May 5, 2012 4:13 PM -
2 Votes
ENCRYPTBYKEY, CERTIFICATES, SYMMETRIC KEYS
Answered | 2 Replies | 1447 Views | Created by paoloam.roxas - Friday, April 24, 2020 10:33 AM | Last reply by Dawn Young - Monday, April 27, 2020 5:57 AM -
1 Votes
Recovering the symmetric key from the Keys table
That is what I was afraid of, but a guy can hope...Answered | 2 Replies | 1786 Views | Created by Amazing Barry - Wednesday, July 29, 2015 11:14 PM | Last reply by Amazing Barry - Thursday, July 30, 2015 1:53 PM -
0 Votes
Symmetric Key
The database owner as full permission on all objects inside the owned database, hence the documented restrictions.Answered | 4 Replies | 1107 Views | Created by sakurai_db - Monday, March 10, 2014 4:18 AM | Last reply by Dan Guzman - Monday, March 10, 2014 11:17 AM -
0 Votes
Please create a master key in the database or open the master key
I do have a DMK on these databases.Answered | 26 Replies | 24405 Views | Created by nickswoca - Wednesday, March 25, 2015 4:00 PM | Last reply by davidbaxterbrowne - Wednesday, April 8, 2015 4:03 PM -
0 Votes
moving certificate and symmetric keys between servers
Your issue is that you're creating two different symmetric keys as your don't have the full IV data needed to be identical, thus you ...Answered | 6 Replies | 4045 Views | Created by new SQLServer user - Friday, November 8, 2013 6:38 PM | Last reply by Sean Gallardy - Monday, February 17, 2020 2:32 PM -
0 Votes
Why encrypt DEK by Asymmetric Key or Certificate, instead of Database Master Key in DTE?
MS DOC DPAPI -> Service Master Key -> DMK --> Certificate (or Asymmetric Key) -> Database Encryption Key (DEK, a ...Answered | 3 Replies | 1198 Views | Created by PhotoHiker - Friday, September 14, 2018 2:01 AM | Last reply by Erland Sommarskog - Friday, September 14, 2018 3:51 PM -
0 Votes
Difference between Database Master key and Database Encryption key
The database master key (DMK) is the top for an encryption hierarchy inside a database.Answered | 2 Replies | 2131 Views | Created by RX2528 - Tuesday, February 11, 2014 10:47 PM | Last reply by - Monday, February 27, 2017 6:58 AM -
0 Votes
Certificate and Symmetric Key Not Working After DB Restore
Hi, I didn't think you could create a certificate in the database if there was no master key in the database.Answered | 5 Replies | 10231 Views | Created by KLilley - Wednesday, April 11, 2012 4:53 AM | Last reply by Mpho Majenge - Monday, June 24, 2013 5:26 AM -
0 Votes
Symmetric Key Issue
Hi ClaytonHoyt, In your scenario, as you are coping the symmetric key from another report server, and symmetric key is not the same one that ...Answered | 1 Replies | 984 Views | Created by ClaytonHoyt - Thursday, March 10, 2016 3:35 PM | Last reply by Qiuyun Yu - Friday, March 11, 2016 5:16 AM -
0 Votes
Cant open symmetric key
As per my understanding , at a time only one session can access data from an opened symmetry key .Answered | 1 Replies | 6206 Views | Created by nsp_ - Thursday, November 12, 2009 1:24 AM | Last reply by Lekss - Thursday, November 12, 2009 2:38 AM -
0 Votes
SQL SERVER SYMMETRIC KEY SECURITY ISSUE
Hi conqueredplanet, Instead of making the symmetric key be encrypted by a certificate which is in turn encrypted by the database ...Answered | 2 Replies | 1144 Views | Created by conqueredplanet - Thursday, May 28, 2015 8:38 AM | Last reply by Lydia Zhang - Monday, June 1, 2015 2:44 AM -
0 Votes
(password + symmetric key)
When using the SYMMETRIC KEY protected by a password, the password is required but not sufficient to access the data, permission on the SYMMETRIC KEY (VIEW ...Answered | 1 Replies | 6069 Views | Created by edm2 - Thursday, March 19, 2009 11:26 PM | Last reply by Raul Garcia - MS - Friday, March 20, 2009 1:53 AM -
2 Votes
Database Master Key Error
WITH ENCRYPTION = OFF; I was also getting this error and couldn't figure out why, especially when I had other apps on the same database ...Answered | 4 Replies | 20039 Views | Created by Babu P P - Saturday, April 22, 2006 4:49 PM | Last reply by David.P - Monday, December 21, 2009 7:22 PM -
0 Votes
Restoring database master key
I recall what I said "I don't think it is an issue" and I meant it a different but Im glad that the second link helped you to solve it.Answered | 4 Replies | 3196 Views | Created by SystemInsider - Friday, August 14, 2015 9:48 AM | Last reply by Jinu Varghese - Friday, September 11, 2015 12:10 PM -
0 Votes
Symmetric or Asymmetric key encryption length can be fixed ?
Since the storage space depends on the type of encryption used and the data itself, there is not much you can do except splitting the data.Answered | 2 Replies | 950 Views | Created by ATRSAMS - Tuesday, October 14, 2014 1:21 PM | Last reply by Andreas.Wolter - Tuesday, October 14, 2014 9:30 PM -
4 Votes
backing up and restoring a database that has symmetric keys
I am planning on using symmetric keys to encrypt specific columns in my database (Sql 2008 R2).Answered | 1 Replies | 4459 Views | Created by ddiamond - Friday, August 3, 2012 1:24 PM | Last reply by Basit Farooq - Friday, August 3, 2012 4:04 PM - Items 1 to 20 of 4090420 Next ›
No announcements
