HI at one of our client side a link server had been created 5 month back from sql server 2005 to sql server 2000.It was working fine.Even now when it right click on it and test connection it succeeds .But when i try to execute a quest which fetches data from sql server 2000 (using link server)
i get following error
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "<Linked Server Name>" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked server "<Linked Server Name>". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema..
Please tell me whats the issue.IS it related to rights and previliges or its anything else.Or any thing related to pwd.PLz reply fast
Thanks and Regards