Have you tried to connect from the console or only remote? Try to open an remote session on the console (mstsc /console) an then to connect to the server.

Set output to grid and query options (context menu, result, grid) to include the header in copy or save.

Cut and Paste the result-grid to Excel.