84,488,480 programs installed

Should I remove Microsoft SQL Server Native Client?

What percent of users and experts removed it?
4% remove it96% keep it
Overall Sentiment
What do people think about it?
(click star to rate)
How common is it?
Global Rank #385
United States Rank #443
Reach 1.6114%
Lifespan of installation (until removal)
< 19.27 days
568.57 days >
Average installed length: 298.74 days


9.00.5266.00 0.00%
9.00.5254.00 0.00%
9.00.5000.00 63.90%
9.00.4912.00 0.01%
9.00.4311.00 0.01%
9.00.4309.00 0.01%
9.00.4305.00 0.00%
9.00.4294.00 0.00%
9.00.4285.00 0.01%
9.00.4226.00 0.01%
9.00.4211.00 0.05%
9.00.4035.00 12.76%
9.00.3257.00 0.01%
9.00.3200.00 0.00%
9.00.3042.00 11.91%
9.00.3027.00 0.01%
9.00.2047.00 6.14%
9.00.1399.06 5.16%

Typically installed together

Other programs by Microsoft

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.


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 detailsProgram 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)

Program filesFiles installed by Microsoft SQL Server Native Client

Program executable:z1sql2008.exe
Path:C:\Program Files\Microsoft SQL Server\z1sql2008.exe
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
  • 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.DUPLICATESID.dll
  • bpa.RSDEFAULTIIS.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

Program behaviorsBehaviors 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.
  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/10: Click Uninstall a Program.
    • Windows XP: Click Add or Remove Programs.
  2. 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).
  3. Follow the prompts. A progress bar shows you how long it will take to remove Microsoft SQL Server Native Client.

Win 7 (SP1) 56%
Win 10 0%
Windows Service? Yes
(Installs a service)
Uninstall it 4%
Keep it 96%

Windows OS versionsWindows

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%

Distribution by countryGeography

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%

OEM distributionPC 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%
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


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