SQL Server 2012 link to SQL Server 2000 problem resolution case

A few days before the SQL Server in the Birch walk up public accounts see an article MS SQL SERVER2014 link MS SQL Server 2000, then on the phone swallowed looked at a probably, know is due to the Native client version of SQL, Did not expect only a few days, his foot on the hole inside, really feel a myriad, the following is mainly about the SQL SERVER Native Client 10 installation process.

Search the Web for SQL SERVER Native Client 10, searching for a bunch of messy addresses. Did not see the official website. A little afraid to download the things of these sites, afraid of being hung horse, before the download of a tool, the results of the recruit, with a good number of anti-virus software to go back and forth to sweep a few times just rest assured. The so-called once bitten ten years afraid of twice shy, database security has to be cautious. So I hung up the installation image for SQL SERVER 2008. You can find the installation file Sqlncli.msi for SQL SERVER Native Client 10 under the following path. I copied sqlncli.msi from the Z:\1033_ENU_LP\x64\Setup\x64 directory to the Windows Server 2012 server installation.

The installation process is very simple, but it is still a record. Be a conscientious person. Accumulate a bit of drip.

Default is not filled, skip directly.

The SQL Server Native Client SDK is not installed by default, and it is best to check this component as well.

After installation, you can successfully create a connection server. Access interfaces must be selected for SQL SERVER Native Client 10.