1

The data pump was previously running on an server with IIS and SQL Server running on the same server. It was working fine. We've been provided a new SQL named instance and we're trying to re-setup the data pump to point to the new server. New SQL server is also new version, so we are using the new msmdpump from the new SQL installation. We've previously set this up on several client sites, so have followed the requirements with the data pump setup, but in this case I'm stuck with a "specified module could not be found" for the IsapiModule. I suspected that it might be an access issue to the msmdpump dll, but I've gone as far as to move the folder to a location with "full everyone access". I've set up tracing and the relevant details for the problem seems to be;

MODULE_SET_RESPONSE_ERROR_STATUS
ModuleName: IsapiModule
Notofocation: EXECUTE_REQUEST_HANNDLER
HttpStatus: 500
HttpReason: Internal Server Error
HttpSubStatus: 0
ErrorCode: The specified module could not be found. (0x8007007e)

I've tried everything I could find online, so any assistance or advice will be great.

Same error as the following IIS 8.0 Detailed 500.0 Internal Server Error - IsapiModule Not Found

riekertv
  • 143
  • 10
  • It seems like that the msmdpump.dll is not found. The ISAPI Dll is either not installed on the IIS server or the Dlls are located in a directory that IIS does not search. Try to copy all the DLLs on which your ISAPI DLL directly or transitively depends to the System32 directory of the IIS server. – Abraham Qian Jun 17 '20 at 07:06
  • Please following the below link for setting up the Datapump. https://learn.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions https://forums.iis.net/t/1222243.aspx – Abraham Qian Jun 17 '20 at 07:06
  • Thanks for the replies Abraham. To test the IIS configuration and access to the DLL folder we've replaced the DLL in the current folder with the previous version, changed the ini file connection back to the old server and it works fine without any IIS changes, so I'm assuming that access to the file is not the issue, but rather the DLL itself, or the actual connection to the new server. Debugging is ongoing... – riekertv Jun 23 '20 at 20:49

1 Answers1

0

Ok this was quite tough, had exactly the same issue but was able to resolve by installing this:

enter image description here

Which I found here:

https://www.microsoft.com/en-us/download/details.aspx?id=40784

David Rogers
  • 2,601
  • 4
  • 39
  • 84