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 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)
Files 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
Behaviors 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?
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.
- 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/10: Click Uninstall a Program.
- Windows XP: Click Add or Remove Programs.
- When you find the program Microsoft SQL Server Management Studio Express, click it, and then do one of the following:
- Windows Vista/7/8/10: Click Uninstall.
- Windows XP: Click the Remove or Change/Remove tab (to the right of the program).
- 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
Which Windows OS versions does it run on?
| Windows 7 |
64.64% |
|
| Windows XP |
15.50% |
|
| Windows 10 |
13.05% |
|
| Windows Vista |
5.82% |
|
| Windows Server 2003 |
1.00% |
|
Which OS releases does it run on? |
| Windows 7 Professional |
24.52% |
|
| Windows 7 Ultimate |
19.63% |
|
| Windows 7 Home Premium |
15.62% |
|
| Microsoft Windows XP |
15.48% |
|
| Windows 10 Pro |
2.88% |
|
| Windows Vista Home Premiu... |
2.79% |
|
Geography
30.63% of installs come from the United States
Which countries install it?
| United States |
30.63% |
| India |
6.44% |
| Italy |
3.73% |
| United Kingdom |
3.44% |
| Germany |
3.16% |
| Iran |
3.08% |
| Brazil |
2.39% |
| France |
2.39% |
| Turkey |
2.19% |
| Mexico |
1.90% |
| Canada |
1.82% |
| Saudi Arabia |
1.82% |
| Spain |
1.74% |
| MA |
1.38% |
PC manufacturers
What PC manufacturers (OEMs) have it installed?
| Dell |
29.12% |
|
| Hewlett-Packard |
25.13% |
|
| Acer |
12.64% |
|
| ASUS |
8.28% |
|
| Intel |
6.92% |
|
| GIGABYTE |
6.47% |
|
| Lenovo |
3.76% |
|
| 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