Encryption not supported on SQL Server - SSIS
Have you find this error while trying to navigate your packages? Today, testing for the first time a SQL Server installation with some SSIS packages, the system gave me this message.
You may find some answers related to this message as http://sqljunkies.com/WebLog/ashvinis/archive/2005/03/29/9831.aspx
But after checking that I realized it was not the real problem, so I started to think in my scenario:
- Named Instance SQL Server 2005 installation Side by Side with a SQL Server 2000 installation
So we should take a closer look at the SSIS configuration...Configuring the Integration Services Service
"By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml"
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
Hey, ServerName it is not pointing to the named Instance!!
So after changing it to a ServerName\InstanceName everything worked as expected.