That's a good lead. I am curious about these details. Do you have an article that references these issues, or maybe how to mitigate them?

I am able to force the use of TCP/IP on my local server by providing the IP address or the specific Port number when connecting.

IP_ADDRESS\INSTANCE_NAME = TCP

IP_ADDRESS,PORT_NUMBER = TCP

.\INSTANCE_NAME = Shared Memory

.,PORT_NUMBER = TCP

SERVER_NAME\INSTANCE_NAME = Shared Memory

SERVER_NAME,PORT_NUMBER = TCP

(local)\INSTANCE = Shared Memory

(local),PORT_NUMBER = TCP

Note: my client protocol priority was not changed from the default order -> Shared Memory first, TCP/IP second, Named Pipes third

You can check your transport with this query after connecting:

SELECT net_transport,

endpoint_id,

connect_time,

client_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@spid ;