Archives for October, 2011

Force local SQL Server processes to use Shared Memory


Current setup: we have 2 instances (one default on 1433 and one named on 1500) and a number of local processes (CDC & SSIS packages). The local processes linked to the default instance use Shared Memory as connection mechanism. The local processes linked to the UA instance use TCP. Problem: we recently got errors like […]