deployment - the acquire connection method call to connection manager failed

• ezhil-526458

  Grasshopper

  Points: 16

  More actions

  November 22, 2007 at 12:33 am

  #122456

  Hi

  i can install and run my package in my development system work fine.

  The same package when i was installing in the production system error

  error: the acquire connection method call to the connection manager "con name" failed with error code 0xc0202009

  errror component "OLE DB source" failed validation and return error code

  0xc020801c

  I used sql server authentication for connection source and

  tried the protection level

  both encrypted password protected and sensitive with user key

  Ezhil

• Powichrowski Marek

  Hall of Fame

  Points: 3483

  More actions

  November 22, 2007 at 2:06 am

  #753326

  Please read this thread:

  http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx