Viewing 15 posts - 61 through 75 (of 127 total)
Performance:
Hi Steve,
I got your point in regards to this.
But is there any chance that I can still do it on my student database, which has only one address table with...
June 18, 2013 at 7:34 am
Thanks Steve,
I successfully implemented encryption on database 'X'.
now apart from the "EXECUTE AS" and apply different user to see the record to verify transperant data encryption., IS THERE ANY OTHER...
June 17, 2013 at 3:26 pm
Thanks steve,
I am following that article now which you linked earlier.
June 17, 2013 at 10:18 am
I guess to call Microsoft Support , I might have to check with my boss, for my rights to do that.
But Steve,
I have another option..I don't know whether it...
June 17, 2013 at 8:52 am
Hi friends.
Thanks SSC-Dedicated and all others for all your help .
I have still issue..after 4 days..even the encryption_State didn't change..it is still at 2, I want it to be...
June 17, 2013 at 7:57 am
how to disable database 'x' encryption while an encryption while its encryption is in progress?
it shows that database 'x' encryption is having value 2 from last one day..
Is there any...
June 14, 2013 at 2:35 pm
Try the following one..
http://www.sqlservercentral.com/articles/EDW/77100/
You will get your solution i guess...
June 14, 2013 at 12:24 pm
My requirment is to encrypt the one of my own database with AES_128..algorighm
that's all.
and then further to depth level.
like table, field, cell level..if possible.
thanks.
June 13, 2013 at 3:21 pm
Honestly I was just going through that article.
when I tried following query
USE master
GO
SELECT * FROM sys.symmetric_keys WHERE name LIKE '%'
GO
i found following two results
##MS_DatabaseMasterKey##--keylength-128--algorithm is --D3
##MS_ServiceMasterKey##--keylength-128--algorithm is...
June 13, 2013 at 3:20 pm
Hi,
After encypting the database, my "is_encrypted" value is 1 and "encryption_state" value is 2..
what does it mean?
I know the fact that when "encryption_state" value will be 3 the encryption process...
June 13, 2013 at 2:53 pm
Actully some other user has already created master key..
I don;t have any idea who was he/she.
Now the issue is i don't have password for it too. and that key is...
June 13, 2013 at 11:47 am
Hi I can open the master key...
USE tempdb
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'
but when i tried following qquery it give me an error,
use tempdb
go
BACKUP CERTIFICATE SQLServerTDECertificate
TO FILE...
June 13, 2013 at 11:15 am
when I tried to backup the master key and certificate it gives me following error.
USE master
GO
BACKUP CERTIFICATE SQLServerTDECertificate
TO FILE = 'C:\CERT\MySQLCert'
WITH PRIVATE KEY (file='C:\CERT\MySQLCertKey',
ENCRYPTION BY PASSWORD='!@chennuio89*()as@!')
Msg 15581, Level 16, State...
June 13, 2013 at 8:23 am
I found that I can not write that .cert and .key file to specific location.
It says that either I don't have permission or files are already exists.
I checked files are...
June 12, 2013 at 1:07 pm
Viewing 15 posts - 61 through 75 (of 127 total)