Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Testing Center » SQL Server Security Skills » How can I unencrypted a stored procedure
Add to briefcase
21 posts, Page 1 of 3
123»»»

How can I unencrypted a stored procedure Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Mai Nguyen-460836
Posted Wednesday, September 05, 2007 10:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 07, 2007 9:52 AM
Points: 11, Visits: 1
I got few stored procedures With Encryption for the database that I converted to SQL Server 2000.   I need to access those stored procedures.   How can I un-encrypted them?
Post #396563
mdaniel
Posted Thursday, September 06, 2007 10:44 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 7:49 AM
Points: 1,487, Visits: 509
Try this:
http://www.mssqltips.com/tip.asp?tip=1046


Post #397003
SQL_ABD
Posted Saturday, November 17, 2007 9:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 6:29 PM
Points: 1,326, Visits: 1,265
Hi,
You can also check theses links
http://www.sqlmag.com/Article/ArticleID/95728/sql_server_95728.html
http://khsw.blogspot.com/2004/08/decrypt-stored-procedures-on-sql.html
http://www.sql-shield.com/decrypt-stored-procedure.html
http://www.sqlmag.com/Article/ArticleID/14369/How_can_I_decrypt_a_SQL_Server_storedprocedure.html
Regards,
Ahmed
Post #423367
K. Brian Kelley
Posted Sunday, November 18, 2007 5:58 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 1:55 PM
Points: 6,584, Visits: 1,789
If it's SQL Server 2000, there's no better tool than:

dSQLSRVD - dOMNAR's SQL Server SysComments Decryptor

It doesn't work on SQL Server 2005, which requires an admin connection, etc., but it's great for SQL Server 2000.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #423373
Ron Aughenbaugh
Posted Monday, November 26, 2007 6:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 4:39 AM
Points: 49, Visits: 70
IF I am not mistaken I thought the unencrypted version is stored in one of the sys tables. Unfortunately I can't remeber which one.
Post #425709
K. Brian Kelley
Posted Monday, November 26, 2007 11:31 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 1:55 PM
Points: 6,584, Visits: 1,789
Ron Aughenbaugh (11/26/2007)
IF I am not mistaken I thought the unencrypted version is stored in one of the sys tables. Unfortunately I can't remeber which one.


Unfortunately, no. In syscomments it is encrypted. I believe in SQL Server 2005 it's encrypted as well. SQL Server 2005 makes it more difficult because you've got to come in via DAC to be able to decrypt.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #425925
JMSM
Posted Wednesday, April 16, 2008 4:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:03 AM
Points: 185, Visits: 751
Hello,

Thanks a lot Brian, the tool that you told me (dOMNAR's SQL Server SysComments Decryptor) was very usefull.

Thanks and regards,
JMSM ;)
Post #485547
Jacob Luebbers
Posted Monday, April 21, 2008 1:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 4:24 AM
Points: 318, Visits: 1,172
You can get "SQL Server 2005 Code Recovery" from here that does the 2005 DAC decrypt for you in a no-brain manner if you don't mind paying a little.

Regards,

Jacob
Post #487748
Zahran
Posted Friday, May 09, 2008 3:59 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 19, 2012 9:22 AM
Points: 52, Visits: 381
Try this,

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

- Zahran -
Post #498257
Matt Miller (#4)
Posted Friday, May 09, 2008 6:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:57 PM
Points: 6,998, Visits: 13,949
Have you tried turning on profiler and running the procedure?

Often enough - Profiler will capture the unencrypted version of the procedure. No fuss, no muss.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #498298
« Prev Topic | Next Topic »

Add to briefcase
21 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.