Microsoft SQL Server Native Client
What is Microsoft SQL Server Native Client?
The SQL Server Native Client contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server.
Overview
The most used version is 9.00.5000.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 z1sql2008.exe. The software installer includes 200 files and is usually about 1.02 GB (1,097,823,678 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=52153
Installation folder: C:\Program Files\Microsoft SQL Server\
Uninstaller: MsiExec.exe /I{6E740973-8E71-42F9-A910-C18452E60450}
(The Windows Installer is used for the installation, maintenance, and removal.)
Estimated size: 1.02 GB
Language: English (United States)
Files installed by Microsoft SQL Server Native Client
| Program executable: | z1sql2008.exe |
| Path: | C:\Program Files\Microsoft SQL Server\z1sql2008.exe |
| MD5: | 36b4fb89d529525588c1aa9a29a5ded4 |
Additional files:
-
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
-
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)
-
ARPWrapper.exe - Microsoft SQL Server (SQL Server ARPWrapper)
-
AXSCPHST.DLL - 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
-
bpa.ASPNETUSERENCRYPTED.dll
-
bpa.DBUNWRITABLE_UPGBLKR.dll
-
bpa.DUPLICATEINDEX_UPGBLKR.dll
-
bpa.DUPLICATESID.dll
-
bpa.LOGINNAMEASSERVERROLE.dll
-
bpa.RESERVEDATABASEID.dll
-
bpa.RSCUSTOMASSEMBLIES.dll
-
bpa.RSCUSTOMSECURITY.dll
-
bpa.RSDEFAULTIIS.dll
-
bpa.RSDEFAULTIISYUKON.dll
-
bpa.YUK1_UPGBLKR.dll
-
BPAClient.dll
-
bpacmd.exe - SQL BPA command line
-
BpaCmdX.dll
-
bpacommon.dll
-
BPAServer.dll
-
BPLib.dll
-
DataCollectorTasks.dll - Data Collector Tasks
-
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
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
- sqlwriter.exe runs as a service named 'SQLWriter' (SQLWriter) "Fornisce l'interfaccia per il backup/ripristino di Microsoft SQL Server tramite l'infrastruttura VSS di Windows.".
- 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.".
- 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.".
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 Native Client?
You can uninstall Microsoft SQL Server Native Client 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 Native Client, 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 Native Client.
OS VERSIONS
Win 7 (SP1) 56%
Win 10 0%
|
|
HOW IT RUNS
Windows Service? Yes
(Installs a service)
|
|
USER ACTIONS
 |
Uninstall it 4%
Keep it 96%
|
|
Windows
Which Windows OS versions does it run on?
| Windows 7 |
61.39% |
|
| Windows Vista |
17.91% |
|
| Windows 10 |
11.73% |
|
| Windows XP |
8.66% |
|
| Windows Server 2003 |
0.31% |
|
Which OS releases does it run on? |
| Windows 7 Home Premium |
26.66% |
|
| Windows 7 Professional |
19.36% |
|
| Windows Vista Home Premiu... |
11.69% |
|
| Windows 7 Ultimate |
11.40% |
|
| Microsoft Windows XP |
8.52% |
|
| Windows 10 Home |
3.09% |
|
Geography
45.39% of installs come from the United States
Which countries install it?
| United States |
45.39% |
| Germany |
6.49% |
| Australia |
3.99% |
| United Kingdom |
3.99% |
| Italy |
3.12% |
| France |
2.59% |
| India |
2.52% |
| Canada |
2.43% |
| Iran |
1.70% |
| Spain |
1.46% |
| Japan |
1.38% |
| Netherlands |
1.37% |
| Brazil |
1.20% |
| Poland |
1.03% |
PC manufacturers
What PC manufacturers (OEMs) have it installed?
| Dell |
25.88% |
|
| Hewlett-Packard |
22.51% |
|
| Acer |
14.57% |
|
| Toshiba |
10.14% |
|
| Lenovo |
6.45% |
|
| Samsung |
5.91% |
|
| GIGABYTE |
4.74% |
|
| ASUS |
4.64% |
|
| Intel |
2.38% |
|
| NEC |
1.18% |
|
| American Megatrends |
0.95% |
|
| Sahara |
0.66% |
|
Common models |
| HP Pavilion dv6 Notebook ... |
5.26% |
|
| Samsung R519/R719 |
4.46% |
|
| HP Pavilion dv7 Notebook ... |
3.53% |
|
| LENOVO 2958 |
3.53% |
|
| TOSHIBA Satellite L500 |
2.81% |
|
| Samsung R520/R522/R620 ... |
2.28% |
|
About Microsoft
Microsoft Corporation develops, manufactures, licenses and supports a variety of products and services related to computing.
Publisher URL: www.microsoft.com