Could not map ordinals

Server: Msg 7351, Level 16, State 2, Line 1
OLE DB provider 'SQLOLEDB' could not map ordinals for one
or more columns of object 'DBSCHEMA_COLUMNS'.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IColumnsInfo::MapColumnIDs returned 0x40eda:
[COLUMN_NAME=IS_COMPUTED ORDINAL=-1]].
I have 5 SQL 2000, Enterprise Edition, SP3 servers running
Windows 2000 Advanced Server w/SP3.
I have set up linking between each of these servers using
the sa username/password 'be made using this security
context.' They all work but one, SQL2. I can access any
other server from SQL2 but from any other server cannot
access tables on SQL2. I get the message above.
I had this before on this same server, but since then have
formatted the system, made sure all the hardware is
working correctly, installed SQL Server not using the same
system databases, and the error is back.
Anyone have ideas for me to try? I have searched
support.microsoft.com, groups.google.com, yahoo.com,
sqlservercentral.com, sqlmag.com to no avail.
Thanks,
Michelle
Please reply to the newsgroup or email me at
daxemail-microsoft'at'yahoo'dot'comI ended up calling Microsoft PSS. I received wonderful
assistance from Chandra who discovered the instcat.sql
script in the service pack did not run correctly on my
system. We backed up the master database, ran the script,
and I now have access to the linked servers.
Thanks! Hope this helps someone in the future,
Michelle
>--Original Message--
>Server: Msg 7351, Level 16, State 2, Line 1
>OLE DB provider 'SQLOLEDB' could not map ordinals for one
>or more columns of object 'DBSCHEMA_COLUMNS'.
>OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
>IColumnsInfo::MapColumnIDs returned 0x40eda:
>[COLUMN_NAME=IS_COMPUTED ORDINAL=-1]].
>I have 5 SQL 2000, Enterprise Edition, SP3 servers
running
>Windows 2000 Advanced Server w/SP3.
>I have set up linking between each of these servers using
>the sa username/password 'be made using this security
>context.' They all work but one, SQL2. I can access any
>other server from SQL2 but from any other server cannot
>access tables on SQL2. I get the message above.
>I had this before on this same server, but since then
have
>formatted the system, made sure all the hardware is
>working correctly, installed SQL Server not using the
same
>system databases, and the error is back.
>Anyone have ideas for me to try? I have searched
>support.microsoft.com, groups.google.com, yahoo.com,
>sqlservercentral.com, sqlmag.com to no avail.
>Thanks,
>Michelle
>Please reply to the newsgroup or email me at
>daxemail-microsoft'at'yahoo'dot'com
>.
>