What is msmdsrv.exe?

The genuine msmdsrv.exe file is a software component of Microsoft SQL Server by Microsoft.
Developed by Microsoft, Microsoft SQL Server is a relational database management system. Msmdsrv.exe is the file that executes the Microsoft SQL Server Analysis Services component of Microsoft SQL Server, and does not pose any threat to your PC.

Initially released 29 years ago, Microsoft SQL Server is a relational database management system developed by Microsoft. Its primary function is to store and retrieve data as requested by other software applications that may either be running on the same computer or another computer on the internet. There are several editions of Microsoft SQL Server available, each geared towards for different audiences and workloads ranging from small single-machine applications to large Internet-facing applications.

Founded in 1975 by Bill Gates and Paul Allen, the Microsoft Corporation is a leading American technology company that develops, sells and supports computer software, consumer electronics and personal computers. The company is known for several innovative products including the Microsoft Office Suite, Windows series of operating systems and Xbox video game consoles.

MsMDSrv stands for Microsoft Main Database Server

The .exe extension on a filename indicates an executable file. Executable files may, in some cases, harm your computer. Therefore, please read below to decide for yourself whether the msmdsrv.exe on your computer is a Trojan that you should remove, or whether it is a file belonging to the Windows operating system or to a trusted application.

Click to Run a Free Scan for msmdsrv.exe related errors

Msmdsrv.exe file information

Windows Task Manager with msmdsrv
Msmdsrv.exe process in Windows Task Manager

The process known as Microsoft SQL Server Analysis Services belongs to software Microsoft SQL Server (version 2005 Books Online, 2005 Tools, 2005, 2005 Backward) or SQL Server (version 2017 Analysis Services) by Microsoft (

Description: Msmdsrv.exe is not essential for the Windows OS and causes relatively few problems. Msmdsrv.exe is located in a subfolder of "C:\Program Files (x86)" (typically C:\Program Files (x86)\MS SQL Server 2005\MSSQL.2\OLAP\bin\ or C:\Program Files\Microsoft Analysis Services\Bin\). Known file sizes on Windows 10/8/7/XP are 13,179,660 bytes (66% of all occurrences), 1,966,080 bytes or 1,732,667 bytes. 
The program is not visible. The msmdsrv.exe file is not a Windows core file. The program uses ports to connect to or from a LAN or the Internet. The file has a digital signature. Msmdsrv.exe is able to monitor applications and connect to the Internet. Therefore the technical security rating is 38% dangerous, but you should also take into account the user reviews.

Uninstalling this variant: You can uninstall Microsoft SQL Server 2000 Analysis or SQL Server 2017 Analysis Services, or try to get help from the software vendor. Click on Microsoft SQL Server 2000 Analysis or SQL Server 2017 Analysis Services in the Windows Control Panel (Software or Programs section) to uninstall it, or click on to visit the vendor's website.

Recommended: Identify msmdsrv.exe related errors

Important: Some malware camouflages itself as msmdsrv.exe, particularly when located in the C:\Windows or C:\Windows\System32 folder. Therefore, you should check the msmdsrv.exe process on your PC to see if it is a threat. We recommend Security Task Manager for verifying your computer's security. This was one of the Top Download Picks of The Washington Post and PC World.


User Comments

Part of MS SQL Server Online Analytical Processing Engine
  Wilco Oosterom   (further information)
When invoked it can consume 100% of the cpu and you can not stop the service after it is started
MS SQL OLAP Services
  Who cares  
MSSQLServerOLAPService for Microsoft SQL Server 2000 or 2005
Microsoft SQL Server OLAP
  Damien Jorgensen  
SQL Server Analysis Services (MSSQLSERVER)
Also seems to be connected to MicroSoft Power BI Desktop

Rating chart

Summary: Average user rating of msmdsrv.exe: based on 20 votes with 7 user comments. 18 users think msmdsrv.exe is essential for Windows or an installed application. 2 users suspect danger. One user is not sure about it.

Do you have additional information?

Best practices for resolving msmdsrv issues

A clean and tidy computer is the key requirement for avoiding problems with msmdsrv. This means running a scan for malware, cleaning your hard drive using 1cleanmgr and 2sfc /scannow, 3uninstalling programs that you no longer need, checking for Autostart programs (using 4msconfig) and enabling Windows' 5Automatic Update. Always remember to perform periodic backups, or at least to set restore points.

Should you experience an actual problem, try to recall the last thing you did, or the last thing you installed before the problem appeared for the first time. Use the 6resmon command to identify the processes that are causing your problem. Even for serious problems, rather than reinstalling Windows, you are better off repairing of your installation or, for Windows 8 and later versions, executing the 7DISM.exe /Online /Cleanup-image /Restorehealth command. This allows you to repair the operating system without losing data.

To help you analyze the msmdsrv.exe process on your computer, the following programs have proven to be helpful: ASecurity Task Manager displays all running Windows tasks, including embedded hidden processes, such as keyboard and browser monitoring or Autostart entries. A unique security risk rating indicates the likelihood of the process being potential spyware, malware or a Trojan. BMalwarebytes Anti-Malware detects and removes sleeping spyware, adware, Trojans, keyloggers, malware and trackers from your hard drive.

Other processes

msmdsrv.exe [all]