Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

- Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server.

I am trying to connect the above databases through heterogeneous services. I have updated the following files: TNSNames.ora, Listener.ora and hs.ora. When performing a test connection from SQL developer, I get the following error - ORA 28500 - indicating that the login for SA user is incorrect.

I also tried using another authenticated user that has rights to the database.

I can successfully connect with SQL 2000.

Has anyone experienced such a problem before?

share|improve this question

We have an Oracle 10g database that is connected to a SQL Server 2005 instance (similar set up - 32bit on Windows 2003). We are using the Oracle 10g Transparent Gateway for SQL Server without issue.

Unfortunately I can't speak to Heterogeneous services. But if you can make the change in your environment, you may want to look into Gateways, I believe it's a free download on OTN.


share|improve this answer
Just because you can download it for free doesn't mean you can use it for free. The MS SQL Server Transparent Gateway from Oracle is quite expensive.… – REW Oct 28 '10 at 4:35
Thanks for clarifying. – SQL3D Oct 28 '10 at 15:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.