Home Forums SQL Server 2008 SQL Server 2008 - General How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager RE: How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager

  • May 12, 2013 at 6:36 pm

    #1614482

    There is more than one person watching this...I'm trying to work out what the "SID" is.

    Running the script gives me this:

    OLE DB provider "MSDAORA" for linked server "MyServerName" returned message "ORA-12154: TNS:could not resolve the connect identifier specified

    ".

    Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

    Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "MyServerName".