I have a simple query to select data from an Excel spreadsheet that I know used to work correctly without error.
The only change we have done is to move the 2008 R2 SQL server into a VMWare VM and upgrade the OS from Windows 2018 R2 to Windows 2012 Datacenter.
The query is
SELECT Period,[ANameGBP] FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=S:\Excel\Salesperson_Targets.xlsx;', 'SELECT * FROM [Targets$]')
After some delay this error is returned and the SQL server crashes and restarts.
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.)
The SQL log shows only the restart info.
I resurrected my old server and tried on this and it works correctly
Any ideas what may be causing this?