How to fix A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

Question

Hi,

I am trying to execute OPENROWSET operator but I am getting the following error on the given syntax.

getting error as :- Msg 109, Level 20, State 0, Line 22 A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

also after execution getting disconnected from SQL server .

SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
                'Excel 12.0;Database=C:\Users\aniket\Desktop\Tr.xlsx;HDR=YES;Network=DBMSSOCN;', 
                'SELECT * FROM [Sheet1$]')

Answer 1

Hi @Aniket kori

You can check the provider (Microsoft.ACE.OLEDB.12.0) settings in SSMS.

Server Objects -> Linked Servers -> Providers -> Microsoft.ACE.OLEDB.12.0 -> Properties

If "Allow inprocess" is checked, the provider code will run within the SQL Server process. This may cause the entire process to shut down.

For more details, you can refer to this link: https://stackoverflow.com/questions/62423494/getting-a-transport-level-error-when-executing-openrowset.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya