Thursday, March 22, 2012
Encryption
(data sent to server and SQL encrypts data before saving) or client side
(data encrypted before sent to server? We are looking at encryption to
protect sensitive data such as SSN's and still don't know what is the right
way to start and what is the pros and cons for each approach? What tools do
you guys use for this purpose? Thanks for your input.Check the encryption section in this FAQ:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
Some of the third party product sites have white papers as
well.
-Sue
On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
wrote:
>Do you guys encrypt data on SQL 2K? If you do, you prefer server side
>(data sent to server and SQL encrypts data before saving) or client side
>(data encrypted before sent to server? We are looking at encryption to
>protect sensitive data such as SSN's and still don't know what is the right
>way to start and what is the pros and cons for each approach? What tools do
>you guys use for this purpose? Thanks for your input.
>|||You might investigate the Microsoft Crypto API. The Interop.Capicom dll is
included in the Platform SDK
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3mls21drp8ss6noflbg3ujao1dt2l9gle0@.4ax.com...
> Check the encryption section in this FAQ:
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
> Some of the third party product sites have white papers as
> well.
> -Sue
> On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
> wrote:
> >Do you guys encrypt data on SQL 2K? If you do, you prefer server side
> >(data sent to server and SQL encrypts data before saving) or client side
> >(data encrypted before sent to server? We are looking at encryption to
> >protect sensitive data such as SSN's and still don't know what is the
right
> >way to start and what is the pros and cons for each approach? What tools
do
> >you guys use for this purpose? Thanks for your input.
> >
>
Encryption
(data sent to server and SQL encrypts data before saving) or client side
(data encrypted before sent to server? We are looking at encryption to
protect sensitive data such as SSN's and still don't know what is the right
way to start and what is the pros and cons for each approach? What tools do
you guys use for this purpose? Thanks for your input.Check the encryption section in this FAQ:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
Some of the third party product sites have white papers as
well.
-Sue
On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
wrote:
>Do you guys encrypt data on SQL 2K? If you do, you prefer server side
>(data sent to server and SQL encrypts data before saving) or client side
>(data encrypted before sent to server? We are looking at encryption to
>protect sensitive data such as SSN's and still don't know what is the right
>way to start and what is the pros and cons for each approach? What tools d
o
>you guys use for this purpose? Thanks for your input.
>|||You might investigate the Microsoft Crypto API. The Interop.Capicom dll is
included in the Platform SDK
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3mls21drp8ss6noflbg3ujao1dt2l9gle0@.
4ax.com...
> Check the encryption section in this FAQ:
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
> Some of the third party product sites have white papers as
> well.
> -Sue
> On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
> wrote:
>
right[vbcol=seagreen]
do[vbcol=seagreen]
>
Encryption
(data sent to server and SQL encrypts data before saving) or client side
(data encrypted before sent to server? We are looking at encryption to
protect sensitive data such as SSN's and still don't know what is the right
way to start and what is the pros and cons for each approach? What tools do
you guys use for this purpose? Thanks for your input.
Check the encryption section in this FAQ:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
Some of the third party product sites have white papers as
well.
-Sue
On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
wrote:
>Do you guys encrypt data on SQL 2K? If you do, you prefer server side
>(data sent to server and SQL encrypts data before saving) or client side
>(data encrypted before sent to server? We are looking at encryption to
>protect sensitive data such as SSN's and still don't know what is the right
>way to start and what is the pros and cons for each approach? What tools do
>you guys use for this purpose? Thanks for your input.
>
|||You might investigate the Microsoft Crypto API. The Interop.Capicom dll is
included in the Platform SDK
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3mls21drp8ss6noflbg3ujao1dt2l9gle0@.4ax.com... [vbcol=seagreen]
> Check the encryption section in this FAQ:
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
> Some of the third party product sites have white papers as
> well.
> -Sue
> On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
> wrote:
right[vbcol=seagreen]
do
>
sql
Encryption
We're currently running SQL Server 2000. We have just been instructed to
ensure that our data is encrypted whenever possible and I was wondering if
any of you could give me some advice about my various options.
I know SQL Server 2005 supports encryption, however, we have a huge amount
of legacy (hard coded classic ASP sql statements) that as far as I can see,
would all need to be updated in order to utilize the native encryption. Is
this the case? Is there a way to encrypt/decrypt a table when it is stored
on the file system as opposed to particular values within it?
We have also looked at the possibility of using EFS for the data storage
folders - has anyone used this before? Is it possible? Any advice on the
implications of this?
The best case scinario would obviously be to have a solution that does not
require us to make any changes to our existing code, but to ensure that the
data is held securely in the event of theft etc.
Any ideas would be really appreciated.
Kind Regards,
ChrisFor column-level encryption, there are lots of 3rd party options available.
Here's one with the perfect price:
http://www.sqlservercentral.com/col...oolkitpart1.asp
I understand others here have used EFS and other tools for file-level
encryption (haven't done so myself), but this might be a good starting
point: http://msdn2.microsoft.com/en-us/library/aa302434.aspx
"Chris Evans" <ChrisEvans@.discussions.microsoft.com> wrote in message
news:F1C1958E-7086-49E1-BCD0-952743FA0F0C@.microsoft.com...
> Hi Guys,
> We're currently running SQL Server 2000. We have just been instructed to
> ensure that our data is encrypted whenever possible and I was wondering if
> any of you could give me some advice about my various options.
> I know SQL Server 2005 supports encryption, however, we have a huge amount
> of legacy (hard coded classic ASP sql statements) that as far as I can
> see,
> would all need to be updated in order to utilize the native encryption.
> Is
> this the case? Is there a way to encrypt/decrypt a table when it is
> stored
> on the file system as opposed to particular values within it?
> We have also looked at the possibility of using EFS for the data storage
> folders - has anyone used this before? Is it possible? Any advice on the
> implications of this?
> The best case scinario would obviously be to have a solution that does not
> require us to make any changes to our existing code, but to ensure that
> the
> data is held securely in the event of theft etc.
> Any ideas would be really appreciated.
> Kind Regards,
>
> Chris
Wednesday, March 21, 2012
encrypting tables
is there any option to encrypt table structure in sql 2000.
procedures and triggers i can encrypt.
for eg: i have one user who is having only select
permission on one table but he can see all the tables
structure and procedure even though he can not edit.
any workaround to achieve this?
Pls advice me.
Thanks
BijuNo. There is no built in functionality to encrypt the table structure.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Be careful. The built-in encryption mechanisms of MS are completely
vulnerable. Decryption programs are freely available. The closest you will
ever get to securing an MSSQL database is with the NelLib offerings. We
have investigated this for six months now and have been deeply disappointed
with the weakness of the security in MSSQL. If you are writing mission
critical applications using MSSQL as your backend our advice is that you
make absolutely certain that you are satisfied with living with the security
holes. A good place to start is www.sqlsecurity.com and all the links and
literature advertised there. Hopefully MS will address these issues with
the next version of MSSQL.
"biju george" <anonymous@.discussions.microsoft.com> wrote in message
news:17e5201c42228$4dcaf780$a001280a@.phx
.gbl...
> Hi Guys,
> is there any option to encrypt table structure in sql 2000.
> procedures and triggers i can encrypt.
> for eg: i have one user who is having only select
> permission on one table but he can see all the tables
> structure and procedure even though he can not edit.
> any workaround to achieve this?
> Pls advice me.
> Thanks
> Biju
Friday, March 9, 2012
Encrypt password field
if you do use oracle 10g, here is a good link for that:
Mysql has a far simpler and equally powerful Encrypt function. just check out the manual if you do use Mysql.
or here is the link:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
good luck|||Im sorry, somehow the link didnt show up. Here it is if you use 10g:
http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/ullman_encrypt.html|||daimous, looking at all your other posts, i'm going to guess that you are using microsoft sql server, and therefore move this thread to that forum|||... in which case this will probably interest you :D
http://www.dbforums.com/showthread.php?t=1217730|||hello guys! i have a question hope you'll help me..how can i encrypt the data that is stored in my password field everytime i insert value to it and decrypt it if i want to retrieve it? thanks in advance!!
If you are decrypting passwords, you don't understand how they are supposed to be used. Passwords should not need to be decrypted.|||i need to decrypt my password from my database since i encrypted it before storing it to my database, in the first place. So before i can get the "REAL" password i need to decrypt it..right? well anyway, can i get some more inputs..|||i need to decrypt my password from my database since i encrypted it before storing it to my database, in the first place. So before i can get the "REAL" password i need to decrypt it..right?
Wrong.
You encrypt your password using some algorithm and store the results in the database.
When your user logs in with a password, thier password is encrypted using the same algorithm. If the results match what is stored in the database, the user's login is verified.
You can write a sproc to encrypt the submitted password and return success or failure after comparing to the stored encryption string.
Thus there is no need to decrypt passwords.
Sunday, February 26, 2012
Enabling Fulltext Service on database
one of my customers moved a SQL Database from one server
to another. The database had 2 fulltext catalogs associated.
On the new DB Server the fulltext service doesn't start using
sp_fulltext_database 'enable'.
QA shows "Executing Query Batch..." but never returns.
I googled on the newsgroups and found the solution to update the
path in the sysfulltextcatalogs to a physical existent folder on the
new server. I tried again with sp_fulltext_database but again it
doesn't work.
The only thing I need is to clean/remove the two catalogs, rebuild
them and enabling the fulltext. What can I do ?
I read also the support ms doc #240867.
So, what am I missing ? Thank you all.
David De Giacomi
Microsoft MVP
Blog @. http://blogs.dotnethell.it/david/
http://www.dotnethell.it
sp_fulltext_database 'disable' in your problem database and run profiler to
see where it is getting stuck (if it does at all). Then I would try to
reenable it (sp_fulltext_database 'enable') and again run profiler to see
where it is getting stuck.
Make sure you kick all users out of this database when you run this command.
I would also bounce the box if you have this luxury before running this
command.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David De Giacomi [dotNetHell.it]" <david_NOSPAM@.dotnethell.it> wrote in
message news:uv%23YZTGOGHA.812@.TK2MSFTNGP10.phx.gbl...
> Hi guys,
> one of my customers moved a SQL Database from one server
> to another. The database had 2 fulltext catalogs associated.
> On the new DB Server the fulltext service doesn't start using
> sp_fulltext_database 'enable'.
> QA shows "Executing Query Batch..." but never returns.
> I googled on the newsgroups and found the solution to update the
> path in the sysfulltextcatalogs to a physical existent folder on the
> new server. I tried again with sp_fulltext_database but again it
> doesn't work.
> The only thing I need is to clean/remove the two catalogs, rebuild
> them and enabling the fulltext. What can I do ?
> I read also the support ms doc #240867.
> So, what am I missing ? Thank you all.
> --
> David De Giacomi
> Microsoft MVP
> Blog @. http://blogs.dotnethell.it/david/
> http://www.dotnethell.it
>
Sunday, February 19, 2012
Emulator Error to replicate data on SQL server
I've tried to make Microsoft lab to create a DB(SQL sever CE) on emulator by existing one on SQL Server,but i've a problem :
when i use moethod(of object SqlCeReplication) to make replicate data, emulator send error -2147012867(A connection with the IIS server could not be established)
may you help me,please ?
thx,bye.
Can you connect to IIS virtual directory from emulator? ( http://Computer_name/virtualdirectory/sqlce30.dll ) . You should see a message SQL Server .. Server Agent.
? If you can’t access this, it meant that connection from device/emulator to IIS is broken.
? If you can access this, it meant that there is issue in getting connected /access permission etc from IIS to SQL Server/Publication.
The account you are using for IIS needs to have access on snapshot. If you are using anonymous use IUSR_Computername
Please ensure to give access rights to \\COMPUTER\repldata
check status of snapshot
Select Replicationà Local publicationàpublication you created.
Right click and check the status of snap shot. (Click start if its status was failure)
but,now i've another problem :
i see server agent message,but i use another way ( http://Computer_name/virtualdirectory/sscesa20.dll ).
When i start appl the same method give me another exception :
"Header information is either corrupted or missing)"
remember,i'm using pocket pc emulator 2003 under VS 2005 beta.
thx for all.
|||
Please excuse us for the late reply.
Here is what my understanding:
1) You are having SQL CE 2.0 Server components on IIS
2) Did you choose Dev App v 1.0 on VS 2005 for the project? I guess you have chosen Dev App (which is SQL CE 3.0 Client). And that is why this error!!
Ok here are the things we want to know to make this proceed further:
1) What is SQL Server version. SQL Server 2000/8.0 or SQL Server 2005/9.0?
2) Where is IIS machine. Same as SQL Server machine or different
3) What is installed on IIS Machine for Replication to work and what versions
The error message generally comes when you have different versions of components in different places.
Also, do you really want to work SQL Server CE 2.0 Client & Server. It is an old version. And, the current version of SQL CE is 3.0. Please consider the option of switching to SQL CE/Mobile 3.0. SQL Mobile 3.0 works very well on Pocket PC 2003. For this you need to choose Dev App.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
HI,
I am trying to use RDA replication to synchoronize the sql ce 2.0 to SQL 2000 in the desktop in Real PDA..i am getting an error that Header information is missing or corrupted .i am putting my source code below..plzz help me ..its very urgent.
Dim strDBFile As String = "\temp\login.sdf"
_repl.InternetUrl = "http://ihsan/SqlCE/sscesa20.dll"
_repl.Publisher = "IHSAN"
_repl.PublisherLogin = "sa"
_repl.PublisherPassword = "sa"
_repl.PublisherSecurityMode = SecurityType.DBAuthentication
_repl.Publication = "SYNCPDA"
_repl.PublisherDatabase = "SYNCPDA"
_repl.SubscriberConnectionString = "data source=\Temp\login.sdf"
_repl.Subscriber = "SYNCPDA"
If Not System.IO.File.Exists(strDBFile) Then
MessageBox.Show("La aplicacion requiere sincronización" & Microsoft.VisualBasic.Chr(13) & "" & Microsoft.VisualBasic.Chr(10) & "Por favor aguarde", "Replicator", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)
_repl.AddSubscription(AddOption.CreateDatabase)
' sync()
Else
Try
_repl.Synchronize()
Catch ex As Exception
MsgBox(ex.Message)
MsgBox(ex.GetHashCode())
End Try
|||Are you using a firewall on your desktop, ie Norton. Then see this blog for info: http://dotnetjunkies.com/WebLog/darrenshaffer/archive/2005/12/07/134186.aspx
|||
HI ,
Thanks a lot for your reply,i disabled everyting stiil giving the same error..wat should i do .
Thanks in advance
Regards
Ihsan
Emulator Error to replicate data on SQL server
I've tried to make Microsoft lab to create a DB(SQL sever CE) on emulator by existing one on SQL Server,but i've a problem :
when i use moethod(of object SqlCeReplication) to make replicate data, emulator send error -2147012867(A connection with the IIS server could not be established)
may you help me,please ?
thx,bye.
Can you connect to IIS virtual directory from emulator? ( http://Computer_name/virtualdirectory/sqlce30.dll ) . You should see a message SQL Server .. Server Agent.
? If you can’t access this, it meant that connection from device/emulator to IIS is broken.
? If you can access this, it meant that there is issue in getting connected /access permission etc from IIS to SQL Server/Publication.
The account you are using for IIS needs to have access on snapshot. If you are using anonymous use IUSR_Computername
Please ensure to give access rights to \\COMPUTER\repldata
check status of snapshot
Select Replicationà Local publicationàpublication you created.
Right click and check the status of snap shot. (Click start if its status was failure)
but,now i've another problem :
i see server agent message,but i use another way ( http://Computer_name/virtualdirectory/sscesa20.dll ).
When i start appl the same method give me another exception :
"Header information is either corrupted or missing)"
remember,i'm using pocket pc emulator 2003 under VS 2005 beta.
thx for all.
|||
Please excuse us for the late reply.
Here is what my understanding:
1) You are having SQL CE 2.0 Server components on IIS
2) Did you choose Dev App v 1.0 on VS 2005 for the project? I guess you have chosen Dev App (which is SQL CE 3.0 Client). And that is why this error!!
Ok here are the things we want to know to make this proceed further:
1) What is SQL Server version. SQL Server 2000/8.0 or SQL Server 2005/9.0?
2) Where is IIS machine. Same as SQL Server machine or different
3) What is installed on IIS Machine for Replication to work and what versions
The error message generally comes when you have different versions of components in different places.
Also, do you really want to work SQL Server CE 2.0 Client & Server. It is an old version. And, the current version of SQL CE is 3.0. Please consider the option of switching to SQL CE/Mobile 3.0. SQL Mobile 3.0 works very well on Pocket PC 2003. For this you need to choose Dev App.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
HI,
I am trying to use RDA replication to synchoronize the sql ce 2.0 to SQL 2000 in the desktop in Real PDA..i am getting an error that Header information is missing or corrupted .i am putting my source code below..plzz help me ..its very urgent.
Dim strDBFile As String = "\temp\login.sdf"
_repl.InternetUrl = "http://ihsan/SqlCE/sscesa20.dll"
_repl.Publisher = "IHSAN"
_repl.PublisherLogin = "sa"
_repl.PublisherPassword = "sa"
_repl.PublisherSecurityMode = SecurityType.DBAuthentication
_repl.Publication = "SYNCPDA"
_repl.PublisherDatabase = "SYNCPDA"
_repl.SubscriberConnectionString = "data source=\Temp\login.sdf"
_repl.Subscriber = "SYNCPDA"
If Not System.IO.File.Exists(strDBFile) Then
MessageBox.Show("La aplicacion requiere sincronización" & Microsoft.VisualBasic.Chr(13) & "" & Microsoft.VisualBasic.Chr(10) & "Por favor aguarde", "Replicator", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)
_repl.AddSubscription(AddOption.CreateDatabase)
' sync()
Else
Try
_repl.Synchronize()
Catch ex As Exception
MsgBox(ex.Message)
MsgBox(ex.GetHashCode())
End Try
|||Are you using a firewall on your desktop, ie Norton. Then see this blog for info: http://dotnetjunkies.com/WebLog/darrenshaffer/archive/2005/12/07/134186.aspx
|||HI ,
Thanks a lot for your reply,i disabled everyting stiil giving the same error..wat should i do .
Thanks in advance
Regards
Ihsan
Emulating SQL Server
I am new here. This is my question.
I have to substitute a SQL Server with Oracle without touching the application. Is there some sort of emulator on the market that could mask Oracle as a SQL Server?
thank you all, gianlucaI would say that would be a bad thing...
How does the application currently get to the data?
All through stored procedures?