Article ID: 948907 - View products that this article applies to.
After you uninstall SQL Native Client from a server that is running Microsoft SQL Server 2005, the following behavior occurs:
This behavior occurs because the SQL Server Agent service and the bcp command prompt utility use the Open Database Connectivity (ODBC) Bulk Copy Program (BCP) API. The ODBC BCP API must link with SQL Native Client. If SQL Native Client does not exist, the SQL Server Agent service cannot be loaded. Additionally, the bcp command prompt utility cannot start.
To work around this behavior, install SQL Native Client. To do this, use one of the following methods, depending on the version of SQL Server 2005 that the server is running.
Method 1: The release version of SQL Server 2005If the server is running the release version of SQL Server 2005, follow these steps:
Method 2: SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2If the server is running SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2, follow these steps:
For more information about how to obtain SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/913089/ )How to obtain the latest service pack for SQL Server 2005
Article ID: 948907 - Last Review: February 28, 2008 - Revision: 1.2
Contact us for more help
Connect with Answer Desk for expert help.