SQL-TOOLS.NET™
DMT© Database Management Tools
SQL Decryptor FAQ
Q: What type of database objects can be decrypted using SQL Decryptor?
A: Stored procedures, triggers, views, user defined functions, database triggers and server triggers can be decrypted.
Q: What SQL Server security permissions are necessary to decrypt with SQL Decryptor?
A:The user specified in the SQL Server's registration properties must belong to the sysadmin database roles.
Q: What is Microsoft SQL Server Native Client?
A: Microsoft SQL Server Native Client (SQL Native Client) contains the SQL OLE DB provider and SQL ODBC driver in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server.
Q: What is Dedicated Administrator Connection (DAC)?
A: With SQL Server 2005, Microsoft offers a new feature, the dedicated administrator connection. This configuration is intended to serve as a last means of defense to troubleshoot and kill the offending SQL Server processes as opposed to rebooting the server possibly causing database corruption and/or access violations. The DAC allows you to connect to the server and issue T-SQL commands to troubleshoot and correct the problem.
Q: Why "DAC login fail" appear when connecting to SQL SERVER2005?
A: If SQL Decryptor can't login to your server and gives an error about DAC error than probably to your server is too restricted. You can read MS articles about how to enable DAC permanently or use our solution which enables this mode temporarily.
By default the DAC is only available from a client on the server. To enable remote clients to utilize the DAC an option needs to be set which can be done using sp_configure

sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO

or by using the SQL Server Surface Area Configuration. To do this:
  1. Launch the SQL Server Surface Area Configuration.tool which can be found under SQL Server 2005 Configuration Tools in the SQL Server 2005 menus.
  2. Select "Surface Configuration Area for Features".
  3. Check the box for "Enable remote DAC".
  4. Select "Apply"
Q: Does SQL Decryptor support all versions of Microsoft SQL Server?
A: SQL Decryptor works with SQL Server 2000, MSDE, SQL Server 2005 and SQL Server 2005 Express databases.
To SQL Server 2005 Express users:
  1. Go to "Services" management view and open SQL Server service properties.
  2. Stop the service, set option -T 7806 as shown on the picture below.
  3. Start service from this dialog. It is important now to press Start right from here and now.
  4. Close dialog.

As a result SQL Server will start with this option which enables DAC login mode. After the server restarted, option disabled.

If you cannot find solution there, please, submit request to our support pages.
Products
SQL Block Monitor
SQL Backup Manager
SQL Decryptor
Overview
Screenshots
FAQ
Licensing
Feature comparison
Download
Purchase
SQL Editor
Product News
September 6, 2016. SQL Block Monitor 2.15 released. This is a maintenance release with some minor bug fixes.
September 6, 2016. SQL Decryptor 3.22 released. This is a maintenance release with some minor bug fixes.
September 6, 2016. SQL Backup Manager 2.7 released. This is a maintenance release with some minor bug fixes.
September 6, 2016. SQL Editor 1.5 released. This is a maintenance release with some minor bug fixes.
Customers
Testimonials
"Managing backups, restores and backup files are important aspects of a DBA's job, you can use SQL Backup Manager to decrease the backup file sizes and the amount of time it takes to back up your databases." - John Daniels
"We had a lot of sessions that were dropped as deadlock victims. After detecting blocks we were able to trace their origin and solve most of the deadlocks before they even happen" - Peter Daniels
"I really love SQL Decryptor. Help me to recover lost encrypted source codes." - Calvin Fabre
"SQL Backup Manager compression ratio is extremely useful, as is the speed at which the backups can be created using the GUI. I now use this as
my preferred SQL Server backup tool." - Peter Blythe
 
More