Microsoft SQL Server Management Objects Collection
What is Microsoft SQL Server Management Objects Collection?
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server Replication Management Objects (RMO) is a collection of objects that encapsulates SQL Server replication management.
Overview
The most used version is 9.00.1399.06, 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 software installer includes 145 files and is usually about 10.56 MB (11,068,361 bytes). Microsoft.SqlServer.PackageFormatUpdate.dll is the automatic update component of the software designed to download and apply new updates should new versions be released.
Program details
URL: www.microsoft.com/sqlserver
Help link: go.microsoft.com/fwlink/?LinkId=52608
Installation folder: C:\Program Files\Microsoft SQL Server\
Uninstaller: MsiExec.exe /I{752BC45F-A71E-4C1C-A571-9814CE456047}
(The Windows Installer is used for the installation, maintenance, and removal.)
Estimated size: 10.56 MB
Language: English (United States)
Files installed by Microsoft SQL Server Management Objects Collection
-
SAC.exe - Microsoft SQL Server Surface Area Configuration command line utility
-
SQLdiag.exe - Microsoft SQL Server support and diagnostic tool
-
msasxpress.dll - Microsoft SQL Server Analysis Services (Microsoft Compression Library)
-
SQLCMD.EXE - T-SQL execution command line utility
-
atl80.dll - Microsoft® Visual Studio® 2005 (ATL Module for Windows (Unicode))
-
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
-
msvcp80.dll - Microsoft® C++ Runtime Library
-
msvcr80.dll - Microsoft® C Runtime Library
-
msxmlsql.dll - Microsoft(R) MSXMLSQL 1.0 RTM (MSXMLSQL RTM)
-
ARPWrapper.exe - Microsoft SQL Server (SQL Server ARPWrapper)
-
AXSCPHST.DLL - AxScriptHost - Active Scripting Host for SQL
-
AXSCPHST90.DLL - AxScriptHost90 - Active Scripting Host for SQL
-
batchparser90.dll - Batch Parser
-
bcp.exe - BCP - SQL bulk copy tool
-
bpacmd.exe - SQL BPA command line
-
DISTRIB.exe - SQL Server Replication Distribution Agent
-
DTAttach.exe - SQL Server Integration Services Script Task
-
DTEParse.dll - Data Transformation Services Execution Utility Parser
-
DTEParseMgd.dll - Data Transformation Services Execution Utility Managed Parser
-
DTEPkg.dll - Data Transformation Services Execution Utility Package Processing
-
DTExec.exe - Data Transformation Services Execution Utility
-
DTS.dll - DTS - Data Transformation Runtime DLL
-
DTSComExprEval.dll - Data Transformation Services Expression Evaluator
-
DtsConn.dll - DTSCONN - Data Transformation Runtime Connections DLL
-
dtshost.exe - DTS - Runtime Surrogate
-
DTSLog.dll - DTSLOG - Data Transformation Runtime Log Providers DLL
-
dtsmsg.dll - DTS - Messages
-
DTSPipeline.dll - DTSPipeline - Data Transformation Pipeline DLL
-
DTSPipelinePerf.dll - DTSPipelinePerf - Data Transformation Pipeline Performance Counters
-
dtuparse.dll - Data Transformation Services Utility Parser
-
dtutil.exe - Data Transformation Services Package Utility
-
ExecPackageTask.dll - DTS - Execute Package Task
-
ForEachFileEnumerator.dll - DTS - For Each File Enumerator
-
iftsph.dll - SQLServer Full Text Protocol Handler
-
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.DLL - Analysis Management Objects
-
Microsoft.AnalysisServices.XMLA.dll - Microsoft.AnalysisServices.Xmla
-
Microsoft.DataWarehouse.Interfaces.DLL - Microsoft.DataWarehouse.Interfaces
-
Microsoft.ExceptionMessageBox.dll - ExceptionMessageBox
-
Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
-
Microsoft.SqlSac.Public.dll - Microsoft_SqlSac_Public
-
Microsoft.SqlServer.ConnectionInfo.dll
-
Microsoft.SqlServer.DTEnum.dll
-
Microsoft.SqlServer.DtsMsg.dll - Managed DTS Msg Poster
-
Microsoft.SqlServer.DtsTransferProvider.dll - SQL Server Integration Services Table Transfer Provider
Behaviors exhibited
2 Scheduled Tasks
- SqlWtsn.exe is scheduled as a task with the class '{FBFEF622-33BC-46CD-BE7E-FD75573E261C}' (runs on registration).
- setup.exe is scheduled as a task with the class '{C1469630-6EF0-46DC-BB1F-44A9BCEA0FA6}' (runs on registration).
5 Services
- 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.".
- sqladhlp.exe runs as a service named 'Servizio SQL Server Active Directory Helper' (MSSQLServerADHelper100) "Abilita l'integrazione con Active Directory".
- sqlservr.exe runs as a service named 'SQL Server (QLOCALINSTANCE)' (MSSQL$QLOCALINSTANCE) "Provides storage, processing and controlled access of data and rapid transaction processing.".
- sqlbrowser.exe runs as a service named 'SQL Server-Browser' (SQLBrowser) "Stellt Clientcomputern SQL Server-Verbindungsinformationen bereit.".
3 Windows Firewall Allowed Programs
- sqlbrowser.exe is added as a firewall exception for 'C:\Programfiler\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 Objects Collection?
You can uninstall Microsoft SQL Server Management Objects Collection 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 Objects Collection, 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 Objects Collection.
OS VERSIONS
Win 7 (SP1) 66%
Win XP 0%
|
|
HOW IT RUNS
Windows Service? Yes
(Installs a service)
|
|
USER ACTIONS
 |
Uninstall it 8%
Keep it 92%
|
|
Windows
Which Windows OS versions does it run on?
| Windows 7 |
69.35% |
|
| Windows 10 |
18.17% |
|
| Windows XP |
6.66% |
|
| Windows Vista |
5.55% |
|
| Windows Server 2003 |
0.28% |
|
Which OS releases does it run on? |
| Windows 7 Home Premium |
35.24% |
|
| Windows 7 Professional |
16.99% |
|
| Windows 7 Ultimate |
12.67% |
|
| Microsoft Windows XP |
6.69% |
|
| Windows 8.1 |
5.01% |
|
| Windows Vista Home Premiu... |
3.34% |
|
Geography
59.03% of installs come from the United States
Which countries install it?
| United States |
59.03% |
| Germany |
11.97% |
| United Kingdom |
4.41% |
| Canada |
3.47% |
| India |
1.47% |
| Australia |
1.37% |
| France |
0.95% |
| Spain |
0.95% |
| Belgium |
0.74% |
| Indonesia |
0.74% |
| Philippines |
0.74% |
| Italy |
0.74% |
| Netherlands |
0.63% |
| Russia |
0.53% |
PC manufacturers
What PC manufacturers (OEMs) have it installed?
| Dell |
31.40% |
|
| Hewlett-Packard |
23.26% |
|
| Acer |
16.05% |
|
| Toshiba |
8.84% |
|
| ASUS |
5.12% |
|
| Intel |
3.95% |
|
| GIGABYTE |
3.72% |
|
| Lenovo |
3.26% |
|
| Medion |
2.56% |
|
| Sony |
0.93% |
|
| Sahara |
0.93% |
|
Common models |
| HP Pavilion dv7 Notebook ... |
4.27% |
|
| Dell Inspiron 620 |
3.32% |
|
| Dell Inspiron 1545 |
2.37% |
|
| HP Pavilion dv6 Notebook ... |
2.37% |
|
| HP G62 Notebook PC |
1.90% |
|
| Dell Latitude D630 |
1.90% |
|
About Microsoft
Microsoft Corporation develops, manufactures, licenses and supports a variety of products and services related to computing.
Publisher URL: www.microsoft.com