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