0

I've never seen such issue.

when i'm using SSMS from my own machine, normally conected to the server I want to run the query, I can run openrowset to select from an excel file with no problems:

SELECT top 10 *  FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\path\ecelFile.xlsx', [Planilha1$])

it retrieves me the result.

BUT if I connect with for example remote desktop or mRemote to the server, and run this query inside it, the server just shuts down:

Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

I've never seen this. even testing with an excel with 10 rows and 3 columns, the SQL server service just shut down. and running from my machine to the server via SSMS, it never fails.

What could this be? theres nothing useful in the server log.

2
  • "the server just shuts down" - you mean the SQL Server service stops? The whole Windows box shuts down? – Josh Darnell Nov 9 '20 at 13:32
  • Yes! thats really strange. First I lose the connection, and the entire SQL Server service ( that one we see on services.msc) shuts down and restart. thats crazy ! ( sorry I read your comment again...it's not the entire server, its the SQL Server service). – Racer SQL Nov 9 '20 at 13:40
0

Go check your provider (Microsoft.ACE.OLEDB.12.0) settings in SSMS.

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

If "Allow inprocess" is ticked off, the provider code is running inside the SQL Server process. This can cause the entire process to shut down. More info in this article

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.