.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error: "HTTP Error 500.0 - Internal Server Error" - Windows Server 2008, IIS7, SSAS 2008, msmdpump.d

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server


We are migrating from Windows Server 2003 / IIS6 to Windows Server 2008 (32-bit) / IIS7 and I am having trouble getting our OLAP HTTP access re-established.  I had this working fine under IIS6 but am now getting the error "HTTP Error 500.0 - Internal Server Error" when attempting to access msmdpump.dll via a browser.

Our existing Win2003 server emits a blob of useful XML when you access the dll via a browser, the new Win2008 server just issues a HTTP 500 error.  Obviously when I get around this error we'll be using standard OLAP clients like Excel and Report Builder etc.

I have followed these instructions:

The Windows Event Logs contain no errors relating to the failed attempts.  I temporarily configured Failed Request Tracing and got a couple of traces of the error occurring.  The most pertinent thing I could find in the FRT was:


ModuleName IsapiModule

View Complete Post

More Related Resource Links

Error installing SQL Server 2008 R2 on a Windows 7 Ultimate 32 machine

HI all, I'm installing the Developer edition of MS SQL Server 2008 R2 (downloaded today) on a Windows 7 Ultimate 32bit virtual machine (using VMWare Workstation 6.5).  Yesterday I had tried MS SQL Server 2008 R0 with the same results.  Both give an error about 30% into the installation process: "An error occurred during the installation of assembly 'VSLangProj80,Version="",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.1826"' When I click the OK button, the install rolls that last bit back and then continues.  Unfortunatly I didn't take a screenshot of the main install window, just the error window. Any ideas what this error means?  The install yesterday seemed to work, but I'm not through the R2 install yet.  The R0 install also failed to install the documentation for some reason (I left it running during the night) Note that I have VS2010 (original release plus downloaded updates) installed and then just some small stuff like Snagit and Skype on this VM.  I updated Windows 7 completely before I started installing R2 so it is completely up to date as of midnight! Best regards, Arnor BaldvinssonArnor Baldvinsson

Error while trying to register DLLs for Microsoft Jet on Windows Server 2008 R2 64bit

Hello! I'm having issues with importing Excel spreadsheets into Microsoft SQL Server 2005 on a Windows Server 2008 R2 64bit server.  After browsing the web, it appears that the problem is with the DLL's used by Microsoft Jet.  I've thus attempted to re-register these DLL's.  However, I am receiving the following results. c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjetoledb40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjet40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjint40.dllThe module "msjint40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjter40.dllThe module "msjter40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjtes40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\mswstr10.dllThe module "mswstr10.dll" was loaded but the entry-point DLLRegisterServer was not found I've set the application pool for this site to use 32bit.  Please note that due to my role on the team, other options such as using ACE are not available to me, unless I can prove that I've exhausted all other options. Thoughts? Thanks,Mike

A MOF syntax error occurred - SQL Server ENT 2008 R2 on Windows Server 2008 R2

Having trouble getting SQL Server 2008 R2 installed on a Windows Server 2008 R2. Getting an MOF syntax error at this point durring the installation "SqlEngineConfigAction_install_confignonrc_Cpu64". Below is the section of the Details.txt file that includes the error. Any help on this would be greatly appreciated.   2010-07-28 10:51:35 Slp: Running: C:\Windows\system32\WBEM\mofcomp.exe "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof" 2010-07-28 10:51:35 Slp: Microsoft (R) MOF Compiler Version 6.1.7600.16385 2010-07-28 10:51:35 Slp: Copyright (c) Microsoft Corp. 1997-2006. All rights reserved. 2010-07-28 10:51:35 Slp: Parsing MOF file: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof 2010-07-28 10:51:35 Slp: MOF file has been successfully parsed 2010-07-28 10:51:35 Slp: Storing data in the repository... 2010-07-28 10:51:36 Slp: An error occurred while processing item 17 defined on lines 201 - 222 in file C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof: 2010-07-28 10:51:36 Slp: Compiler returned error 0x800706beError Number: 0x800706be, Facility: Win32 2010-07-28 10:51:36 Slp: Description: The remote procedure call failed. 2010-07-28 10:51:36 Slp: 2010-07-28 10:51:36 Slp: Sco: Compile operation for mof file C:\Program Files\Microsoft SQL S

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

error when installing sharepoint server 2007 on Windows server 2008 r2

I ve tried to install sharepoint server 2007 on server 64 bit with windows server 2008 r2,but it gave me compatibilty error

Sql error+sharepoint server 2007 installation on windows server 2008 r2


I am trying to install sharepoint server 2007 on windows server 2008 r2,I downloaded the version of sharepoint that contains service pack2,after the installation finished,message displayed that mssql\officeservers cant be found?

Must I install sql server 208 before installing sharepoint,is sql express that is already installed with sharepoint 2007 not compatible with windows server 2008 r2

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Error during SQL Server 2008 setup on windows 7 home premium



I have Windows 7 home Premium on 64 bit machine. I have installed Visual Studio 2008 sucessfully and SQL Server 2008 installer also shows "successful" installation. However when I try to login thru Sql mgmt Studio, I get error " No process is on the other end of the pipe". I checked SQL Server configuration and Named Pipes configuration, that seems all right. When I checked event log, it had following msg:

The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

on googling, some of posts suggest to download .Net f/w 2.0 SP1. I downloaded the same from MS site, but on instllation, I get msg "this version is not supported on windows vista".

Please suggest any solution/workaround, i have been struggling with this for sometime now.

thanks in advance


Error Code: 17058 - Sql Server 2008 on Windows 7




I have installed the Visual Studio 2010 Proffesional (from MSDNAA) on my Windows 7. And I have big problem with the SQL Server as I can not start the SQLEXPRESS! I have read many Forums and tried to do what the people saied (e.g. change the sql folder not to be only to read, tried to change Properties SQL Server (SQLEXPRESS) to Local system. Run it like an adminnistrator but its not working! I have an error: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs details" so I chacked it and there was the 17058 error.

Can anybody help me? Any advises? Maybe I havent done somethink after intalling it?

Thanks and sorry for my english

Windows Update Error - Win XP, Win 7 and Server 2008


We have a mix of Windows XP and 7 PC and Windows 2008 servers that are configured to use our WSUS update server.  However, we have begun to notice that most of the PCs aren't consistantly communicating with the WSUS server. Also, if we try to run the Windows update process on the PC or other Server, we get the following error message:

Code 80244021 - Windows Update encountered an unknown error.

Review of the WEB only shows problems for Vista PCs and the suggestions to resolve the error doesn't work any way.

Chris Premo

Error while installing SQL Server 2008 on Windows 7 64 bit with command line



I am getting error when installing the Sql Server 2008 on Windows 7 64 bit as when i install the Sql Server with command line in the middle of installation it needs a Restart and after restart i get an error it looks like it has a bad parameter since the Windows Installer command line argument help is prompted as per my understanding windows installer should take care of this restart and continue the installation.

Please some one advice what is wrong with this...... 

Regards Anil Devata

Error 1935 When Installing SQL Server 2008 Express on Windows 7 64 bit

I need to install SQL Server 2008 Express on Windows 7 x64 but keep failing. I've searched and tried so many method listed on many forums to no avail. Please kindly help.

These are the error message that I was getting:

Error 1935. An error occurred during the installation of assembly
'Microsoft.VC90.ATL,version="9.0.21022.8",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="x86", type="win32". Please refer to Help and Suppoer for more information. HRESULT: 0x8007054F.


An error occurred during the installation of assembly
'Microsoft.VC80.CRT,version="8.0.50727.1801",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="amd64", type="win32". Please refer to Help and Suppoer for more information.

Additional information:
- OS: Microsoft Windows 7 Professional Edition 64bit
- I have no other SQL instances present on every install (I always uninstall it first and clean up the residue files on C:\Program files (and the x86 one)\Microsoft SQL Server\)
- I have Visual Studio Express 2010 installed
- I fundamentally require only SQL Server service and SQL Server Management Studio, but I've tried all installer on the Microsoft website just in case one is working.

This are the files that I'

Error occurred while SQL Server 2008 R2 Setup at Windows 7



I try setup

RTM-version Microsoft SQL Server2008 R2 Express with Advanced Services X64 

on  Windows 7.

In setup check common components placed on disk C:

and named instance of data baseTEST on disk D:

During installation process occurred error:

SQL Server Setup failed to modify security permissions on file D:\MS SQL Server 2008 R2\Base TEST\MSSQL10_50.TEST1\MSSQL\ for user PAVEL. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that  exists on the destination drive.

User PAVEL has admin's priveleges.

Setup lanche "as from admin name"

Disks C and D at home computer.


Windows Update error message 84B30001 - SQL Server 2008 SP2 update fails


I am running Windows 7 Professional on a 64 bit platform and have Windows update on and selected to notify me when updates are available.  The other day, I received an error message that an update failed to install properly.  The update that failed is to update SQL Server 2008 SP2 - KB 2285068.  I have made several attempts to retry this update with the same result.  When I Googled the error message, all of the responses deal with the SQL Server 2008 SP1 update not SP2.  Couldn't find a solution to this problem - nor could I find one in the KB article - which basically explains details of SP2 and DOES give me the option to instal SP2 from here.  Don't want to take the chance and download it from here - maybe I should though.  Can usually find a solution to a Windows update error in Google - can't find one this time.

Any suggestions?

Jim Cutrara

Jim Cutrara

About SSAS security on Windows server 2008


Hi Experts:

I set up a role on SSAS cube, and only users in this role can see/process the cube.

And I tried to test it by removing my NT account from not only membership of role on this cube but also administrator group of Win Server 2008R2. The problem is, when I use Excel 2007 to connect the cube on my local PC, I can still see/process this cube...

My NT account is not longer in role's memebership list or Server's administrator group, but why I can still access it...

Any thoughts?  Your help would be greatly appreciated, thanks!

[SQL-DMO] This server object is not connected - error on Windows Server 2008 x64


My MSI is running a custom action which uses SQL-DMO through an interop assembly (Interop.SQLDMO.dll). I am creating the MSI with Visual Studio 2010, and getting "[SQL-DMO] This server object is not connected" on some Windows Server 2008 x64 machines.

The previous version of my MSI was created with Visual Studio 2005 and is successfully installed on the servers which fail to run with the new MSI. Both MSI's use the exact same interop assembly.

I have tried to install SQL Server 2008 Feature Pack April 2007 - with no luck. It seems to me that the problem is related somehow to Visual Studio 2010, because the custom action does run with the older MSI.

Error with SQL Server 2008 R2 Express Install on Windows 7


Does anyone have any ideas on how to proceed? Installing will not complete.  I receive the following error when I try to install SQL Server 2008 R2 Express-

Any help is greatly appreciated!

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\rhaas\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'
at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend