Decrypt an Encrypted Object in SQL Server

After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL Server !! (Ref : Source ) Step 1: Make sure remote admin connections is enable on server if not enable using following EXEC sp_configure ‘remote admin connections’, 1 GO RECONFIGURE GO Step 2 : Connect to  SQL Server using DAC (Dedicated Administrator Connection) Open Sql Server Management Studio ( close the authentication screen !) Click on new query , on that authentication screen will pops up For authentication in Server use  “ADMIN:” as prefix in your server name Connect to your SQL server using...

Read More