Linked Server - can test connect on server... test connect fails using SSMS on remote server

  • I have set up a linked server on a new installation of SQL Server 2008 R2 SP2. The Test Connection works great. If i go to a remote workstation and bring up SSMS and connect to the instance. I try the Test Connect and I get the following:

    Cannot initialize the data source object of the OLE DB provider "OraOLEDB.Oracle" for linked server

    "ORA-12154: TNS: could not resolve the connect identifer specified". (Microsoft SQL Server, Error:7303)

    Has anyone else had this issue?

    Charlie

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply