ssis package error.......critical

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » ssis package error.......critical

ssis package error.......critical

Rate Topic

Display Mode

Topic Options

Author

Message

deep_kkumar

Posted Monday, December 03, 2012 5:06 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 23, 2013 6:43 AM
Points: 94, Visits: 565

Hi guys,

On our prod server cluster we are continuously getting the error, failed to acquire connection, connection may not be configured correctly or you may not have the required permission on the system I am not sure why we are getting this error suddenly. I need to fix this issue. Please help.

Post #1392191

e4d4

Posted Tuesday, December 04, 2012 1:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:19 PM
Points: 160, Visits: 1,146

And what is not clear in this error message? You must check link and account that is used by this ssis package, maybe someone changed configuration of network, account...

Post #1392282

Ed B

Posted Wednesday, December 05, 2012 2:16 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 509, Visits: 1,544

This is a shot in the dark, buy is the package stored in msdb on one of the cluster nodes, but not another? so that when the cluster rolls over it can no longer find the package?

Post #1393211

pchirags

Posted Wednesday, December 05, 2012 2:25 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:56 PM
Points: 1,243, Visits: 336

Do you use package configuration, Logging when you deploy your package.
or you manually change connections of server databases.

Post #1393218

« Prev Topic | Next Topic »

Permissions