Error from SQL Server 2005 to SQL Server 2000 Linked Server

Posted on 2007-08-08
Last Modified: 2013-11-05
I'm getting the below error message on a Linked Server between a SQL Server 2005 64-bit installation and a SQL Server 2000 installation.

What do I did to do to fix this? I've come across this:

and this:;en-us;906954

Does that mean I just need to run:

ISQL -Usa -Ppassword -S -iD:\Instcat.sql

and that will fix the issue up? I've noticed that I can't seem to run INstcat.sql becuase it fails to parse correctly.


OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved". The provider supports the interface, but returns a failure code when it is used.

Question by:PeterErhard
    LVL 12

    Accepted Solution

    First ensure that you have SP4 on your 2000 machine. Then locate instcat.sql script in SP4 installation (should be C:\Program Files\Microsoft SQL Server\MSSQL\Install by default).
    Than run this script: ISQL -Usa -Ppassword -S<server2000SP4name> -i<location>\Instcat.sql

    Some errors when running this?

    Author Comment

    This machine has SP3a and has to stay with SP3a as the application doesn't support SP4.
    LVL 12

    Expert Comment

    No problem SP3 is enough. Could you locate Instcat.sql on it?

    Author Comment

    No I can't actually.

    Do you know where I can get instcat.sql for SP3?
    LVL 12

    Expert Comment

    Sorry, I don't understand. Have you solved the problem? If not why you accept my answer?
    You could  not find instcat.sql in C:\Program Files\Microsoft SQL Server\MSSQL\Install?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now