0

We have been using SQL Server's linked server capabilities successfully for over a year to connect to Oracle. We've been doing this under Windows Server 2008. Today, we moved the same setup to an SQL server that was installed on a Windows 2012 machine.

When we connect with Windows authentication everything goes well. When we use SQL Server authentication we receive this error:

ORA-12154: TNS:could not resolve the connect identifier specified

I suspect that the account under which the SQL Server login is operating has no permissions to read the TNSnames.ora. However, how can I verify that?

TylerH
  • 20,799
  • 66
  • 75
  • 101
Midas
  • 564
  • 6
  • 21

1 Answers1

0

Migrating solution from comments to an answer:

Part of the functionality of the tnsnames.ora file enables you to use simpler connection strings, but it needs to exist for every OS user (if it's being used there). I'd guess that you have "one" (a tnsnames.ora file) on the OS for your old OS user but not the new one.

You should have a tnsnames.ora file for the new user, too.
– Ben   Sep 22, 2014 at 12:28

TylerH
  • 20,799
  • 66
  • 75
  • 101