Error expanding MSDB via SSIS

• pamela.fourie

  SSC Journeyman

  Points: 80

  More actions

  August 17, 2011 at 7:19 pm

  #241789

  Hi

  I have a SQL 2005 server with SSIS. One instance only - default instance.

  Error is on a production server, staging works fine. I am a sysadmin on both

  When trying to expand Stored Packages\MSDB I get the following error:

  Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

  Additional information:

  Could not load type 'CollectionEntry' from assembly 'System.Data, Version 2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' due to value type mismatch. (MsDtsSrvr)

  Named pipes is disabled but disabled on staging too.

  Compared MsDtsSrvr.ini file on production and staging and they are the same.

  Anyone have any ideas please?

• pamela.fourie

  SSC Journeyman

  Points: 80

  More actions

  August 17, 2011 at 9:46 pm

  #1369930

  FOUND THE PROBLEM and thought I would share..

  SSIS (and SQL engine) are running under a service account (domain) however the user rights have been curtailed. The problem appears to be the User Rights - adding as a local admin resolved the problem - so now it is just to find the minimum rights required.