I'm on same server as the SQL Server instance. I have no issues connecting using SSMS but using the Connection Manager in SSnIS using Windows Authentication I get the following error:
Test connection failed because of an error in initializing provider. Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.
Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server ."
I've checked an Names Pipes is enabled so not sure what the issue is.