SQL Server 2008 :: TDE Enabled DB Stuck In Limbo During Decryption?

Mar 30, 2015

Sql server 2008R2 (SP2) Ent, PROD DB myDB was encrypted. During Release mistakenly (Vendor created script blames some settings in ...- actually does not matter) Decryption started (ALTER .. SET ENCRYPTION OFF) as we got from ErrorLog.

For some reason initial encryption scan was aborted and then mentioned command: ALTER ... OFF was issued again. What we have now (after 60 h of decryption- encryption took only 2.5 h)- is_encrypted = 0 in sys.databases, encryption_state = 5 (decryption in progress) in sys.dm_database_encryption_keys (percent_complete= 0). But it seems myDB is still encrypted- I made a backup of myDB and tried to read it (restore filelistonly) from other server (with no encryption)- failed- asked for key. Seems metadata was changed when initial scan during decryption started but then stuck and (if I am correct) decryption was never completed. Question- any similar experience? How we can fix meta- data, i.e. assuming that myDB is still encrypted we should have is_encrypted = 1 and encryption_state = 3 (encrypted).

View 2 Replies


ADVERTISEMENT

SQL Server 2008 :: Encryption / Decryption On Mirroring Database

May 4, 2015

I have created mirroring... one of the column is encrypted on mirror database and I can see the decrypted result when I do query when I actually logged into server (through remote connection) but when I use the same query through using SSMS from my laptop the query result come as the column is not decrypted,

View 0 Replies View Related

SQL Server 2008 :: Error Occurred During Service Master Key Decryption

Mar 13, 2015

I have a SP SQL server that uses Handshake for the web parts. I am getting an error on SharePoint about 'An error occurred during Service Master Key Decryption' inside the web parts of the page, everything else comes up, from what I have researched MS says go under SQL Configuration Manager and change the service account. Is this the correct course of action for this type of error? I am just having a hard time believing that changing the engines service account will stop this issue, this account is used on several SQL server with no issues.

MCSA SQL Server 2012

View 1 Replies View Related

SQL Server 2008 :: Moving TDE Enabled DB To Standard Edition?

Jan 28, 2015

I have a DB with TDE enabled on Enterprise edition sql server 2008r2. I am actually planning on moving the DB to sql server 2008r2 standard edition. How to accomplish it properly. I don't think SQL Server 2008r2 standard edition support TDE. I can only think of turning off the encryption, but is there anything else I should know?

View 3 Replies View Related

SQL Server 2008 :: Audit Trace Enabled And Server Not Starting

Aug 12, 2014

I restarted the sql server after c2 audit was enabled and now i can not start the instance getting this error below. how do i bring the sql server up?

Cannot start C2 audit trace. SQL Server is shutting down. Error = 0x80070003(The system cannot find the path specified.)

View 2 Replies View Related

SQL Server 2008 :: Restore Database That Has CDC Enabled To Another Server That Does Not Support CDC?

Sep 15, 2015

UAT environment : SQL Server 2008 R2 SP3 Enterprise Edition

SANDBOX environment : SQL Server 2008 R2 SP3 Standard Edition

I have a database backup (.bak) that was taken from UAT environment that has CDC enabled on some tables. I want to restore that database into my SANDBOX environment which does not support CDC (because of standard edition). The restore process fails due to this incompatibility. Is there any way to restore without CDC (I dont CDC enabled on my SANDBOX; just my data from the backup) ?

View 0 Replies View Related

SQL Server 2008 :: Update Null Enabled Field Without Interfering With Rest Of INSERT / UPDATE

Apr 16, 2015

If I have a table with 1 or more Nullable fields and I want to make sure that when an INSERT or UPDATE occurs and one or more of these fields are left to NULL either explicitly or implicitly is there I can set these to non-null values without interfering with the INSERT or UPDATE in as far as the other fields in the table?

EXAMPLE:

CREATE TABLE dbo.MYTABLE(
ID NUMERIC(18,0) IDENTITY(1,1) NOT NULL,
FirstName VARCHAR(50) NULL,
LastName VARCHAR(50) NULL,

[Code] ....

If an INSERT looks like any of the following what can I do to change the NULL being assigned to DateAdded to a real date, preferable the value of GetDate() at the time of the insert? I've heard of INSTEAD of Triggers but I'm not trying tto over rise the entire INSERT or update just the on (maybe 2) fields that are being left as null or explicitly set to null. The same would apply for any UPDATE where DateModified is not specified or explicitly set to NULL. I would want to change it so that DateModified is not null on any UPDATE.

INSERT INTO dbo.MYTABLE( FirstName, LastName, DateAdded)
VALUES('John','Smith',NULL)

INSERT INTO dbo.MYTABLE( FirstName, LastName)
VALUES('John','Smith')

INSERT INTO dbo.MYTABLE( FirstName, LastName, DateAdded)
SELECT FirstName, LastName, NULL
FROM MYOTHERTABLE

View 9 Replies View Related

Transact SQL :: Index Maintenance / Defrag Fails On CDC Enabled Database - 2008 R2

Oct 18, 2012

We have a new database with cdc enabled on all of its tables.  This causes the index maintenance task to fail with following message:

"Executing the query "EXEC DBName.dbo.IndexDefrag_sp" failed with the following error:  "The unique index 'PK_TableName' on source table '[dbo].[TableName]' is used by Change Data Capture.  To alter or drop the index, you must first disable Change Data Capture on the table.  The transaction ended in the trigger. The batch has been aborted.".  Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly" We would like to run the index maintenance without losing the cdc data.  We plan on installing SP2 on SQL Server 2008 R2 soon, would that solve the issue?  Disabling the cdc prior to index maintenance and then re-enabling back upon completion; would delete the data as I found in most discussions, but we would like to retain it. 

View 4 Replies View Related

RijndaelManaged Decryption From SQL Server

Jan 17, 2008

Subject:RijndaelManaged decryption from SQL Server

Issue: I am trying to move the decryption code from C# to SQL Server 2005.


Web.config
...

<symmetricCryptoProviders>


<add algorithmType="System.Security.Cryptography.RijndaelManaged, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=xxxxxx" protectedKeyFilename="C:Keysfffff.key" protectedKeyProtectionScope="LocalMachine" type="Microsoft.Practices.EnterpriseLibrary.Security.Cryptography.SymmetricAlgorithmProvider, Microsoft.Practices.EnterpriseLibrary.Security.Cryptography, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="RijndaelManaged"/>

</symmetricCryptoProviders>
...

.cs file
....

decString = Cryptographer.DecryptSymmetric("RijndaelManaged", encString);
....

View 6 Replies View Related

SQL Server Data Encryption And Decryption

Feb 19, 2008

Hi.
I have a SQL Server 2000 database that contains information I would like to encrypt. The information is a field inside a table, and I would like to encrypt this information using a key, and decrypt it in my asp.net application using that key and use the decrypted data.
Please tell me how this can be done, or direct me to an article or a link on the subject.
Thanks in advance.

View 2 Replies View Related

Sql Server Default Port Not Enabled

Mar 17, 2004

I am unable to access the default port 1433 on my SQL 2003 server. There is no firewall. I run telnet <ip> <port> and get "Connection failed" which explains my inability to connect to the server for weeks. I have being unable to connect to the server after I uninstalled sql 2000 and reinstalled it on my 2003 server. Some of the things I have checked is Network Configuration in EM. Named Pipes and TCP/IP is installed with port set to 1433. HKLMSoftwareMicrosoftMSSQLServerClientSuperSocketNetLibTcpDefaultPort port is set to 1433. Is there anything I need to configure on the server side to have the default sql server port enabled.

Thanks

View 2 Replies View Related

Hyperthreading Enabled Or Not In SQL Server Machines.

Jan 9, 2008

Hello,
I have to find out whether my servers have hyperthreading enabled or not???? I am running Windows server 2003 Standard edition on many of my machines. I have to configure the SQL Server, server configuration values according to the Hyperthreading. I know about the CPUcount.exe utility but is there anything else apart from it??????

View 5 Replies View Related

Moving DB One Server To Another With Broker Enabled

Jun 22, 2006

I have a database with Broker_Enabled set via the following command:

ALTER DATABASE 'xxxx' SET ENABLE_BROKER

All works well, I made a backup and want to move to my development machine. When I run I still get an error saying I need to enable broker service again.

"The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications."

How can I move the database and get this setup? Where are the BrokerID's Stored?

Thanks,

~ Steve

View 5 Replies View Related

SQL Server Express Stuck Restoring...

Jan 25, 2007

I seem to have a problem with one of my SQL Server Express databases. I started a restore task from a SQL Server 2005 BAK file (that included full-text data), which couldn't continue so I cancelled. Now, the database I attempted to restore to has the status "(Restoring...)".

This is a tiny database and a restore should (if it could) take only a few seconds.

I'm using SQL Server 2005 Management Studio (v9...).

Anyone know how to either cancel the restore or get the database into a good state again? I've tried stopping and starting (and restarting) the express instance, with no joy.

View 1 Replies View Related

Moving Databases From One Server To Another With Replication Enabled.

Apr 21, 2004

Hello -

I have 2 databases on a remote server on which Replication and Replication Monitor is enabled. Now I want to move this databases from different remove location.

How do I transfer bboth databases with replication and replication monitor enabled on it with all the user logins.

Please help me out.

Thanks.

View 2 Replies View Related

CLR Integration In SQL Server (Problem In Sp_configure 'clr Enabled', 1)

Aug 21, 2007



HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

View 7 Replies View Related

SQL Server 2012 :: Script To Reorganize All Enabled Indexes

Jul 30, 2015

My index reorganise maintenance plan fails partly due to the disabled indexes

Executing the query "ALTER INDEX [I_ModelSecurityCommon_RECID] ON [dbo]...

" failed with the following error: "Cannot perform the specified operation on disabled index 'I_ModelSecurityCommon_RECID' on table 'dbo. Model SecurityCommon'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I don't want to delete the indexes as they are standard indexes that where on the DB from install.. any script that will reorganise all enabled indexes? and also to rebuild?

View 5 Replies View Related

SQL Server 2005 - Changing Passwords With POLICY Enabled

Jun 22, 2007

Using SQL Server 2005 SP2 std edition on Windows 2003 R2 SP2 x64 std edition I'm allowed to break the password policy.



To reproduce this behaviour as a system administrator run...

create login testuser with password='p'



This creates a login with the default of POLICY enabled ('Enforce Password Policy' check box is checked). OK, so may be system administrator is allowed to break the policy but now login as testuser and run



alter login testuser with password='t' old_password='p'



This succeeds despite obviously breaking the policy.



Surely this can't be right, I must be doing something wrong.



Any help will be greatly appreciated.



Tim Gordon-Jones

View 4 Replies View Related

Backup And Restore Of Filestream Enabled Filegroup In Server

Oct 16, 2015

I am new to DBA activities. I have a database name Sample_DB in SQL Server 2014.  

This database has below files

LogicalName FileType
FileGroup
Sample_DB_Rows   ROWS Data
PRIMARY
Sample_DB_C1 ROWS Data
Country1
Sample_DB_C2 ROWS Data
Country2
Sample_DB_Docs FILESTREAM Data
FileGroupForDoc

My database has 3 tables namely Tbl1, Tbl2 and Tbl3.

Tbl1 data stored in primary file group
Tbl2 is partitioned based on a key column CountryId and stored in respective filegroup
Tbl3 is enabled to store documents, files etc., and its data will be stored in filestream enabled filegroup.

Problem:
I need to take backup of each file group separately.
I need to restore the backed up file group separately. Is this possible, how to do it.

View 3 Replies View Related

Compact Server Database-file Not Enabled For Replication

Apr 23, 2008

When I try to create a subscription to my SQL Server Compact 3.5-database file, it gives an SqlCeException-message that says that the file is not enabled for replication. How do enable it?

My SQL Server Management Studio won´t connect to my compact server file right now, so that method is not an option for me right now.

View 1 Replies View Related

Can't Set @replicate_ddl Parameter To 1 For Publications Enabled For Non-SQL Server Subscribers

Oct 17, 2007

Hi,
I am trying to replicate some tables from an Sql Server database to an Oracle database. So the publisher is SQL Server and the Subscriber is Oracle.

Unfortunately I realised that I can't set the replicate_ddl parameter to 1 for an Oracle Subscriber. This is the error I got:
"The property "replicate_ddl" cannot be modified for publications that are enabled for non-SQL Server subscriptions."

I looked on the Internet and I found that this parameter "@replicate_ddl" (used in the add_publication stored procedure) can't be set to 1 if the @enabled_for_het_sub parameter is set to 'true'.

So I thought if I just set the replicate_ddl parameter to 1 and leave the other parameter to false and then use the sp_changepublisher stored procedure to set the enabled_for_het_sub parameter to true that will work. But it didn't. I tried this in Enterprise Manager and although I had no error I realised that the replicate_ddl parameter was reset to false.


Is there any way I can replicate the ddl statements in Oracle automatically or I should to them manually?

View 4 Replies View Related

SQL Server 2k Agent Service Stuck In Starting State

Mar 10, 2004

I have a Win 2003 server running 3 instances of SQL 2000 Enterprise.
The problem is I can only start 2 of the 3 Job Agents at a time, as the 3rd gets stuck in a starting state.
Has anyone struck this problem before?

Thanks.

View 8 Replies View Related

Cannot Connect To A Default Instance Of SQL Server With Onecare Firewall Enabled -HELP!

Jun 8, 2007

Dim strCON As String = _

"workstation id=DJI-MAIN;packet size=4096;user id=sa;integrated security=SSPI;data source=DJI-MAIN;persist security info=False;initial catalog=RacingSystem"

Dim cnn1 As New SqlConnection(strCON)

cnn1.Open()



This is the code I have been using to connect to my default instance for 18 months. A recent upgrade to Windows Live onecare now prevents me connecting to the server from the same machine. The following error message is generated:-





Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnection.Open()

at TrainerReport001.Form1.Form1_Load(Object sender, EventArgs e) in F:#ProjectsStatsOwnerReport001Form1.vb:line 84

at System.Windows.Forms.Form.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)The program '[3336] TrainerReport001.exe' has exited with code 0 (0x0).

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)

at System.Windows.Forms.Control.SetVisibleCore(Boolean value)

at System.Windows.Forms.Form.SetVisibleCore(Boolean value)

at System.Windows.Forms.Control.set_Visible(Boolean value)

at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Application.Run(Form mainForm)

at TrainerReport001.Form1.Main() in F:#ProjectsStatsOwnerReport001Form1.vb:line 2







If I turn off the onecare firewall I can connect as normal, but this is not a desired option. I have tried enabling port 1433 on the firewall, this does not work either. Any help greatly appreciated, onecare support seems reluctant to help.



TIA

View 4 Replies View Related

DB Engine :: Trace Flags 1117 And 1118 No More Enabled After Server Got Rebooted

Dec 1, 2015

During a newly set up on one of our SQL server 2012:

We had enable the trace flags 1117 and 1118 as a good practice using DBCC TRACEON(1117,-1) and similar for 1118.

We have been base lining the server and it came to notice that trace flags are no more enabled.

Property                            Value                                                           CaptureDate
DBCC_TRACESTATUS  TF 1117: Status = 1, Global = 1, Session = 0     2015-10-20 00:00:00
DBCC_TRACESTATUS        TF 1118: Status = 1, Global = 1, Session = 0         2015-10-20 00:00:00

After reboot:
Property                               Value                                                                  CaptureDate
DBCC_TRACESTATUS          No trace flags enabled                         2015-10-21 00:00:02.340

What can be the reason? What can be done to turn them on permanently, if its actually a good bet in enabling so.

View 5 Replies View Related

Decryption

Aug 11, 2001

How to decrypt a Stored Procedure which has been encrypted in SQL Server 7.0

Thanks in Advance

Regards,

Karthik

View 1 Replies View Related

Decryption

Oct 11, 2007

I am using the below function written by PESO to encrypt/Decrypt the data for my SSN Numbers stored as a Clear Text

First I am Encrypting all my SSN's using this function and storing it in the database in a seperate Column,

Some thing like this..

SELECT DBACentral.dbo.fnEncDecRc4( '145678908' , 'ty6578dmp1203' )
OUPPUT
--------
âUÙN_{��

How to Decrypt ( âUÙN_{�� ) using the below function.

CREATE FUNCTION dbo.fnEncDecRc4
(
@Pwd VARCHAR(256),
@Text VARCHAR(8000)
)
RETURNSVARCHAR(8000)
AS

BEGIN
DECLARE@Box TABLE (i TINYINT, v TINYINT)

INSERT@Box
(
i,
v
)
SELECTi,
v
FROMdbo.fnInitRc4(@Pwd)

DECLARE@Index SMALLINT,
@i SMALLINT,
@j SMALLINT,
@t TINYINT,
@k SMALLINT,
@CipherBy TINYINT,
@Cipher VARCHAR(8000)

SELECT@Index = 1,
@i = 0,
@j = 0,
@Cipher = ''

WHILE @Index <= DATALENGTH(@Text)
BEGIN
SELECT@i = (@i + 1) % 256

SELECT@j = (@j + b.v) % 256
FROM@Box b
WHEREb.i = @i

SELECT@t = v
FROM@Box
WHEREi = @i

UPDATEb
SETb.v = (SELECT w.v FROM @Box w WHERE w.i = @j)
FROM@Box b
WHEREb.i = @i

UPDATE@Box
SETv = @t
WHEREi = @j

SELECT@k = v
FROM@Box
WHEREi = @i

SELECT@k = (@k + v) % 256
FROM@Box
WHEREi = @j

SELECT@k = v
FROM@Box
WHEREi = @k

SELECT@CipherBy = ASCII(SUBSTRING(@Text, @Index, 1)) ^ @k,
@Cipher = @Cipher + CHAR(@CipherBy)

SELECT@Index = @Index +1
END

RETURN@Cipher
END

GO

Thanks for any help

View 3 Replies View Related

SQL Server Admin 2014 :: AlwaysOn HA - Database Stuck In Initializing After Failover

Oct 23, 2015

We had to failover our primary db server for maintenance to our secondary replica. The primary was rebooted during maintenance. We failed back after the maintenance and one of the databases is not synchronizing.

I checked sys.dm_hadr_database_replica_states, and it is showing that it is INITIALIZING.

It has been in this state for more than 45 mins now. The last_sent_time, last_received_time, last_hardened_time and last-redone_time are all stuck with a time stamp 45 mins ago.

They haven't changed. How do i resume this database and bring it back in sync?

I tried suspending and resuming the data movement, but hasn't worked.

View 6 Replies View Related

Decryption Not Working

Feb 5, 2008

I have been testing two way symmetrical encryption. I have been able to encrypt rows of a spacific column using the following UPDATE statement, however, when I try and decrypt them, the query returns Null for the effected rows.
Can anyone see where I may have gone wrong in the decryption statement?UPDATE tblReceipts SET tblReceipts.CCNumber = EncryptByPassPhrase('Abracadabra!1234$',tblReceipts.CCNumber)
FROM tblReceipts
WHERE tblReceipts.CreditCardType > 0

Decrypt Does Not Work?????

SELECT CONVERT(varchar, DecryptByPassPhrase('Abracadabra!1234$',tblReceipts.CCNumber)) AS CCNumber
FROM tblReceipts
WHERE tblReceipts.CLIENTID = 15000My CCNumber field is nvarchar(20)My PassPhrase is just a test phraseThe data after it is encrypted in just a bunch of binary looking boxes  

View 6 Replies View Related

Password-Decryption

Aug 11, 2000

Hi,
Every one
Can i Encrypt & Decrypt Data store in SQL SERVER table. If field is alredy Encripted, then how I can decrypt in SQL SERVER.

Thanks
Nirmal

View 3 Replies View Related

What Key To Use For DES3 Decryption

Apr 3, 2015

How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after ETL to SQL Server, be able to decrypt but keep a column's value encrypted in Oracle, SSIS and SQL side - only decrypting on the SQL Server side when needing to use the value.

View 1 Replies View Related

Decryption On Sql2005

Oct 16, 2006

What solutions are available?
Is there a way to read about from server's metadata?

Gus

View 1 Replies View Related

RC4 Encryption - Decryption

Dec 12, 2006

This function is used to initialize the seed for the RC4 algorithmCREATE FUNCTION dbo.fnInitRc4
(
@Pwd VARCHAR(256)
)
RETURNS @Box TABLE (i TINYINT, v TINYINT)
AS

BEGIN
DECLARE@Key TABLE (i TINYINT, v TINYINT)

DECLARE@Index SMALLINT,
@PwdLen TINYINT

SELECT@Index = 0,
@PwdLen = LEN(@Pwd)

WHILE @Index <= 255
BEGIN
INSERT@Key
(
i,
v
)
VALUES(
@Index,
ASCII(SUBSTRING(@Pwd, @Index % @PwdLen + 1, 1))
)

INSERT@Box
(
i,
v
)
VALUES(
@Index,
@Index
)

SELECT@Index = @Index + 1
END


DECLARE@t TINYINT,
@b SMALLINT

SELECT@Index = 0,
@b = 0

WHILE @Index <= 255
BEGIN
SELECT@b = (@b + b.v + k.v) % 256
FROM@Box AS b
INNER JOIN@Key AS k ON k.i = b.i
WHEREb.i = @Index

SELECT@t = v
FROM@Box
WHEREi = @Index

UPDATEb1
SETb1.v = (SELECT b2.v FROM @Box b2 WHERE b2.i = @b)
FROM@Box b1
WHEREb1.i = @Index

UPDATE@Box
SETv = @t
WHEREi = @b

SELECT@Index = @Index + 1
END

RETURN
ENDANd this function does the encrypt/decrypt partCREATE FUNCTION dbo.fnEncDecRc4
(
@Pwd VARCHAR(256),
@Text VARCHAR(8000)
)
RETURNSVARCHAR(8000)
AS

BEGIN
DECLARE@Box TABLE (i TINYINT, v TINYINT)

INSERT@Box
(
i,
v
)
SELECTi,
v
FROMdbo.fnInitRc4(@Pwd)

DECLARE@Index SMALLINT,
@i SMALLINT,
@j SMALLINT,
@t TINYINT,
@k SMALLINT,
@CipherBy TINYINT,
@Cipher VARCHAR(8000)

SELECT@Index = 1,
@i = 0,
@j = 0,
@Cipher = ''

WHILE @Index <= DATALENGTH(@Text)
BEGIN
SELECT@i = (@i + 1) % 256

SELECT@j = (@j + b.v) % 256
FROM@Box b
WHEREb.i = @i

SELECT@t = v
FROM@Box
WHEREi = @i

UPDATEb
SETb.v = (SELECT w.v FROM @Box w WHERE w.i = @j)
FROM@Box b
WHEREb.i = @i

UPDATE@Box
SETv = @t
WHEREi = @j

SELECT@k = v
FROM@Box
WHEREi = @i

SELECT@k = (@k + v) % 256
FROM@Box
WHEREi = @j

SELECT@k = v
FROM@Box
WHEREi = @k

SELECT@CipherBy = ASCII(SUBSTRING(@Text, @Index, 1)) ^ @k,
@Cipher = @Cipher + CHAR(@CipherBy)

SELECT@Index = @Index +1
END

RETURN@Cipher
END

Peter Larsson
Helsingborg, Sweden

View 20 Replies View Related

RC4 Encryption/Decryption

Jan 3, 2008

This is related to post :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78552

got a issue with this one..im not sure why..

My results are as follows:

Select dbo.fnEncDecRc4('Orange12345', 'Hello123')
Output : ,Mgl
Select dbo.fnEncDecRc4('Orange12345', ',Mgl')
Output : M

i am not able to decrypt it. Any idea why this is hapenning? Does it has to do something with regional settings?

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved