I have a couple different SSIS packages that are running on server A and connecting to server B that are receiving the following error messages: "Failed to acquire connection "ServerB". Connection may not be configured correctly or you may not have
the right permissions on this connection." I am getting this with on OLEDB and ADO.Net connections. The interesting things is, I get these errors only part of the time. I am running these packages several hundred times a day. I am only
getting this error 5-10 times a day, around < 5% of the time. I am running SQL Server 2008 SP1 Enterprise Edition x64. I have reduced the max server memory a couple times to ensure SSIS has enough memory to operate, but I still seem to get the
same error. There doesn't seem to be a consistent time of day this happens either. I'm having trouble trying to resolve this, any help is appreciated.
View Complete Post