84,488,480 programs installed

Should I remove Microsoft SQL Server Management Studio Express?

What percent of users and experts removed it?
7% remove it93% keep it
Overall Sentiment
Excellent
What do people think about it?
(click star to rate)
How common is it?
Global Rank #4,684
United States Rank #6,332
Reach 0.1136%
Lifespan of installation (until removal)
< 11.26 days
332.29 days >
Average installed length: 174.60 days

Versions

VersionDistribution
9.00.5000.00 22.68%
9.00.4035.00 14.62%
9.00.3042.00 22.31%
9.00.2047.00 40.39%

Typically installed together

Other programs by Microsoft

Microsoft SQL Server Management Studio Express

What is Microsoft SQL Server Management Studio Express?

Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server Express Edition and SQL Server Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server.

Overview

The most used version is 9.00.2047.00, with over 98% of all installations currently using this version. It adds a background controller service that is set to automatically run. Delaying the start of this service is possible through the service manager. A scheduled task is added to Windows Task Scheduler in order to launch the program at various scheduled times (the schedule varies depending on the version). The software is designed to connect to the Internet and adds a Windows Firewall exception in order to do so without being interfered with. The main program executable is SQLEXPR.EXE. The software installer includes 218 files and is usually about 15.35 MB (16,091,907 bytes).

Program detailsProgram details

URL: www.microsoft.com/sqlserver
Help link: go.microsoft.com/fwlink/?LinkId=55742
Installation folder: C:\Program Files\Microsoft SQL Server\
Uninstaller: MsiExec.exe /I{C40D6727-57FE-4671-B51A-69B0F21F44B5}
(The Windows Installer is used for the installation, maintenance, and removal.)
Estimated size: 15.35 MB
Language: English (United States)

Program filesFiles installed by Microsoft SQL Server Management Studio Express

Program executable:SQLEXPR.EXE
Path:C:\Program Files\Microsoft SQL Server\SQLEXPR.EXE
MD5:1fb1afc37dc6e74e6565bed0e1c0636d
Additional files:
  • SAC.exe - Microsoft SQL Server Surface Area Configuration command line utility
  • SQLdiag.exe - Microsoft SQL Server support and diagnostic tool
  • ssmsee.exe - Microsoft SQL Server Management Studio Express
  • msasxpress.dll - Microsoft SQL Server Analysis Services (Microsoft Compression Library)
  • connwiz30-express.exe - Microsoft SQL Server Compact Edition (Web Synchronization Configuration Wizard)
  • microsoft.sqlserverce.client.dll - Microsoft.SqlServerCe.Client
  • microsoft.sqlserverce.express.enumerator.dll - Microsoft.SqlServerCe.Enumerator
  • microsoft.sqlserverce.express.managementui.dll - Management Studio Dialogs
  • microsoft.sqlserverce.express.replwiz.dll - Merge Replication Subscription Wizard
  • sqlceca30.dll - Client Agent
  • sqlcecompact30.dll - Database Repair Tool
  • sqlceer30en.dll - Native Error Strings and resources
  • sqlceme30.dll - Managed Extensions
  • sqlceoledb30.dll - OLEDB Provider
  • sqlceqp30.dll - Query Processor
  • sqlcese30.dll - Storage Engine
  • SQLCMD.EXE - T-SQL execution command line utility
  • system.data.sqlserverce.dll - System.Data.SqlServerCe
  • atl80.dll - Microsoft® Visual Studio® 2005 (ATL Module for Windows (Unicode))
  • cmddef.dll - Visual Studio Environment Command definition DLL
  • dbghelp.dll - Debugging Tools for Windows(R) (Windows Image Helper)
  • mfc80.dll - MFCDLL Shared Library - Retail Version
  • MFC80CHS.DLL - MFC Language Specific Resources
  • MFC80CHT.DLL
  • MFC80DEU.DLL
  • MFC80ENU.DLL
  • MFC80ESP.DLL
  • MFC80FRA.DLL
  • MFC80ITA.DLL
  • MFC80JPN.DLL
  • MFC80KOR.DLL
  • mfc80u.dll
  • Microsoft.Data.ConnectionUI.Dialog.dll - Microsoft Data Connection UI Dialog
  • Microsoft.Data.ConnectionUI.dll - Microsoft Data Connection UI
  • msvcp80.dll - Microsoft® C++ Runtime Library
  • msvcr80.dll - Microsoft® C Runtime Library
  • msvcr71.dll - Microsoft® Visual Studio .NET
  • msxmlsql.dll - Microsoft(R) MSXMLSQL 1.0 RTM (MSXMLSQL RTM)
  • xmlrw.dll - Microsoft XML Core Services (Microsoft XML Slim Library)
  • UserControlTestContainer.exe - Microsoft® .NET Framework (.NET Framework UserControl Test Container)
  • AXSCPHST.DLL - Microsoft SQL Server (AxScriptHost - Active Scripting Host for SQL)
  • AXSCPHST90.DLL - AxScriptHost90 - Active Scripting Host for SQL
  • batchparser.dll - Batch Parser
  • batchparser90.dll
  • bcp.exe - BCP - SQL bulk copy tool
  • DISTRIB.exe - SQL Server Replication Distribution Agent
  • instapi.dll - SQL Server Instance API DLL
  • instapi10.dll
  • instapi110.dll
  • isacctchange.dll - IS Account change notification
  • logread.exe - SQL Server Replication Logreader Agent
  • mergetxt.dll - SQL Server Text Merge Resolver
  • microsoft.analysisservices.graphing.dll
  • microsoft.datawarehouse.dll - Microsoft.DataWarehouse
  • microsoft.datawarehouse.sqm.dll - Microsoft.DataWarehouse.SQM
  • Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll - ExceptionMessageBox
  • microsoft.netenterpriseservers.express.exceptionmessagebox.dll
  • Microsoft.SqlSac.Public.dll - Microsoft_SqlSac_Public
  • microsoft.sqlserver.express.activitymonitor.dll
  • microsoft.sqlserver.express.appidpackage.dll

Program behaviorsBehaviors exhibited

Scheduled Task
  • sqlwtsn.exe is scheduled as a task with the class '{FBFEF622-33BC-46CD-BE7E-FD75573E261C}' (runs on registration).
3 Services
  • sqlbrowser.exe runs as a service named 'SQLBrowser' (SQLBrowser) "Rende disponibili le informazioni di connessione a SQL Server per i computer client.".
  • sqladhlp90.exe runs as a service named 'MSSQLServerADHelper' (MSSQLServerADHelper) "Enables integration with Active Directories.".
  • sqlwriter.exe runs as a service named 'SQLWriter' (SQLWriter) "Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.".
3 Windows Firewall Allowed Programs
  • sqlbrowser.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe'.
  • sqlwtsn.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\SqlWtsn.exe'.
  • SqlSAC.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe'.

How do I remove Microsoft SQL Server Management Studio Express?

Quickly and completely remove Microsoft SQL Server Management Studio Express from your computer by downloading Reason's ‘Should I Remove It?’ (click the button below).
Or, you can uninstall Microsoft SQL Server Management Studio Express from your computer by using the Add/Remove Program feature in the Window's Control Panel.
  1. On the Start menu (for Windows 8, right-click the screen's bottom-left corner), click Control Panel, and then, under Programs, do one of the following:
    • Windows Vista/7/8: Click Uninstall a Program.
    • Windows XP: Click Add or Remove Programs.
  2. When you find the program Microsoft SQL Server Management Studio Express, click it, and then do one of the following:
    • Windows Vista/7/8: Click Uninstall.
    • Windows XP: Click the Remove or Change/Remove tab (to the right of the program).
  3. Follow the prompts. A progress bar shows you how long it will take to remove Microsoft SQL Server Management Studio Express.

HOW IT RUNS
Windows Service? Yes
(Installs a service)
 
USER ACTIONS
Uninstall it 7%
Keep it 93%
 
GLOBAL RANK
#4,684

Windows OS versionsWindows

Which Windows OS versions does it run on?
Windows 7 64.72%
Windows XP 15.52%
Windows 10 12.93%
Windows Vista 5.83%
Windows Server 2003 1.00%
Which OS releases does it run on?
Windows 7 Professional 24.55%
Windows 7 Ultimate 19.66%
Windows 7 Home Premium 15.64%
Microsoft Windows XP 15.50%
Windows Vista Home Premiu... 2.79%
Windows 10 Pro 2.79%

Distribution by countryGeography

30.60% of installs come from the United States
Which countries install it?
  United States 30.60%
  India 6.45%
  Italy 3.73%
  United Kingdom 3.37%
  Germany 3.17%
  Iran 3.08%
  Brazil 2.39%
  France 2.39%
  Turkey 2.19%
  Mexico 1.91%
  Canada 1.83%
  Saudi Arabia 1.83%
  Spain 1.75%
  MA 1.38%

OEM distributionPC manufacturers

What PC manufacturers (OEMs) have it installed?
Dell 29.07%
Hewlett-Packard 25.15%
Acer 12.65%
ASUS 8.28%
Intel 6.93%
GIGABYTE 6.48%
Lenovo 3.77%
Toshiba 3.39%
Samsung 1.81%
American Megatrends 1.28%
Sahara 1.20%
Common models
HP Pavilion dv6 Notebook ... 5.77%
Dell Inspiron N5110 2.99%
Dell Inspiron N5010 2.78%
ASUS All Series 2.56%
Dell OptiPlex 380 2.56%
HP Pavilion g6 Notebook P... 2.56%

About Microsoft

Microsoft Corporation develops, manufactures, licenses and supports a variety of products and services related to computing.
Publisher URL: www.microsoft.com

commentsComments

user comment
No one has commented yet. Help others learn more about this software, share your comments.