• I think you are getting closer now that you can connect via sqlplus.

    Search the entire computer to see if there is more then one copy of tnsnames on it.

    In SMSS, right click on the linked server

    Click script linked server as

    Click create to

    Click new query editor window

    You might get a hint from the sql to create the linked server

    You might also want to post the sql without any confidential information hidden