As an ode to Stephen Colbert this is Part 1 of my open-ended series…“Backlog”. ZIP instead of XLSX! These will admittedly be old topics but I’m clearing out a “backlog” of draft blog posts.
I got a report from a user that was trying to download an Excel file from our company’s Intranet that it was prompting him to save it instead of just opening it as it always has. Taking a look at it I see that it is prompting to open it however the file type is being identified as a zip file.
If I click Open I get the prompt the user was talking about where Save or Cancel are the only options.
Luckily since this is an internal web server it can be fixed. The issue is that the web server does not know how to handle the XLSX file type (i.e. MIME type). To fix this use the following steps to add the MIME type for the XLSX MIME type as well as a few others listed at the end.
- Open IIS Manager.
- Right click Servername & select Properties.
- Click the MIME Types button.
- Click New.
- In the Extension field type xlsx
- In the MIME type field type
When opening the Exchange Management Console (EMC) in Exchange 2010 you may receive a nice long error that says, “The following error occurred while attempting to connect to the specified Exchange server: The attempt to connect to SERVERNAME/PowerShell using ‘Kerberos’ authentication failed: Connecting remote server failed with the following error message : The WS-Management service cannot process the request. The system load quota of 1000 requests per 2 seconds has been exceeded. Send future requests at a slower rate or raise the system quota. The next request from this user will not be approved for a least 1928339328 milliseconds.”
You get a similar error in the Exchange Management Shell (EMS).
Run the following command from an elevated command prompt:
Now the EMC will open.