Udostępnij za pośrednictwem

Encryption not supported on SQL Server - SSIS

  • Artykuł

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 https://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="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance">
  <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
  <TopLevelFolders>
    <Folder xsi:type="SqlServerFolder">
      <Name>MSDB</Name>
      <ServerName>.</ServerName>
    </Folder>
    <Folder xsi:type="FileSystemFolder">
      <Name>File System</Name>
      <StorePath>..\Packages</StorePath>
    </Folder>
  </TopLevelFolders> 
</DtsServiceConfiguration>

Hey, ServerName it is not pointing to the named Instance!!

So after changing it to a ServerName\InstanceName everything worked as expected.

SSIS