SQL 2000 Linked Server at SQL 2012

16/12/2012

תגיות:
7 תגובות
The SQL Server Native Client (SQLNCLI11) that ships with SQL Server 2012 does not support connections to SQL Server 2000 an earlier. I found this out during testing of our upgrade to SQL 2012. We upgraded our 2008 R2 servers in-place and it appears to have left the SQLNCLI10 provider in place but if you did a fresh install of SQL Server 2012 on a new server you may not have this provider. Does your 2012 server have the SQLOLEDB provider listed under Linked Server Providers in SSMS? If so, you could try using that.
 
Issue

Causes
  • SQL 2012 (Native Client 11.0) does not support SQL 2000 any more by default.
Solutions
  1. Type linked server name in the [Linked server] text box.
  2. Select [Other data source] at [Server type] option.
  3. Select [SQL Server Native Client 10.0] at [Provider] drop-down list.
  4. Type [SQLSERVER] at [Product name] text box.
  5. Type <SQL 2000 server name or ip address> at [Data source] text box.
  6. Leave blank at [Provider string]
  7. Leave blank at [Catalog]

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

7 תגובות

  1. Boland24/12/2012 ב 23:06

    Hi there, constantly i used to check website posts here early in the morning, because i enjoy
    to learn more and more.

    הגב
  2. Guidry25/12/2012 ב 19:11

    What's up, I log on to your blog daily. Your humoristic style is awesome, keep doing what you're doing!

    הגב
  3. Chan26/12/2012 ב 20:55

    Do you have any video of that? I'd like to find out some additional information.

    הגב
  4. Harris27/12/2012 ב 17:21

    Link exchange is nothing else except it is simply
    placing the other person's blog link on your page at proper place and other person will also do same in favor of you.

    הגב
  5. Menard30/12/2012 ב 14:06

    Hi there, i read your blog from time to time and i own a similar one
    and i was just wondering if you get a lot of spam feedback?
    If so how do you prevent it, any plugin or anything you
    can suggest? I get so much lately it's driving me crazy so any assistance is very much appreciated.

    הגב
  6. Maymone D.19/03/2013 ב 08:04

    Your solution solves the connection problem. But when I tried to run a query with a refrence to the link server I got this error message.
    A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 – The pipe has been ended.)
    Can you help?

    הגב
  7. Arellano22/03/2013 ב 15:32

    A colleague linked me to your resource. Thank you for the resources.

    הגב