December 3, 2012 at 5:06 pm
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.
December 4, 2012 at 1:32 am
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...
December 5, 2012 at 2:16 pm
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?
December 5, 2012 at 2:25 pm
Do you use package configuration, Logging when you deploy your package.
or you manually change connections of server databases.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply