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