Hi all. I have a SQL Server 2000 Enterprise + SP3a on mi server "dwh01". Today we installed on it Sybase client and created a linked server to the sybase server. The sybase client connects fine to that machine from dwh01, but using Enterprise Manager on it does not work. The strange thing is, from an Enterprise Manager from another machines the linked server DO WORK!
We have this configiration on "dwh02", with the same SP verison installed and it works. It seems to me that the problem is caused by a misregistered library, but I do not know which DLL can be causing this, and we cannot update SQL Service Pack. Any help would be appreciated, thanks in advance.