SQL Server Performance

encryption require to connect to msdb packages

Discussion in 'SQL Server 2005 Integration Services' started by seanlo@jdg.co.za, Mar 15, 2006.

  1. seanlo@jdg.co.za New Member

    Hi There

    I am using SS2005 Enterprise Edition, proper release version not a ctp or anything

    When i try navigate to my packages in MSDB i get the following error.

    Encryption not supprted in Sql Server.

    I have done some checking and it is a known fact the sql server will enxrypt packages, and that the resolution is to use certificates.

    Also some indications from links i have found that this is just a ctp or beta version issue.

    Can someone please tell me if there is anyway around this besides certificates.

    One is to use file system for packages, but how can i at least delete the packages deployed to sql server so far ???

    Please help , Thanx
  2. satya Moderator

  3. seanlo@jdg.co.za New Member

    Hi Satya

    Sorry for sounding stupid but where exactly do i check this , i have tried , Sql Server COnfiguration Manager for 2005and sp_configure, and read the article but they dont say where you can change this setting ?

    I am not sure where to find the setting ?

    Thanx
  4. seanlo@jdg.co.za New Member

  5. satya Moderator

    Sean
    There are few articles floating on MSDN blogs about encryption in SQL SErver and SSIS, I will search thru and will refer here if I found any suitable ones.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page