Error from SQL Server 2005 to SQL Server 2000 Linked Server

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:

http://msdn2.microsoft.com/en-US/library/aa215459(SQL.80).aspx

and this:

http://support.microsoft.com/default.aspx?scid=kb;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.


****************
PeterErhardAsked:
Who is Participating?
 
patriktConnect With a Mentor Commented:
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?
0
 
PeterErhardAuthor Commented:
This machine has SP3a and has to stay with SP3a as the application doesn't support SP4.
0
 
patriktCommented:
No problem SP3 is enough. Could you locate Instcat.sql on it?
0
 
PeterErhardAuthor Commented:
No I can't actually.

Do you know where I can get instcat.sql for SP3?
0
 
patriktCommented:
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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.