Consider the following scenario:
- You install Microsoft SQL Server on a computer that is running Windows Server 2012.
- You create a linked server for another database.
- You clear the Allow inprocess option in the options dialog box for the linked server provider.
Note By default, the option is not selected. - You run a linked server query.
Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)