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: |
- Launch the SQL Server Surface Area
Configuration.tool which can be found under SQL Server
2005 Configuration Tools in the SQL Server 2005 menus.
- Select "Surface Configuration Area for Features".
- Check the box for "Enable remote DAC".
- 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: |
- Go to "Services" management view and open SQL Server
service properties.
- Stop the service, set option -T 7806 as shown on the
picture below.
- Start service from this dialog. It is important now
to press Start right from here and now.
- 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. |