Connecting to SQL server - Heterogeneous Connectivity

I'm trying to connect ORacle 9i to MS SQL Server 7.0.
I did everything by the book, but when I try to select something from the table on SQL Server, i get message:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (SQL State: 28000;
SQL Code: 18456)
ORA-02063: preceding 2 lines from MSQL
My database link has username and password specified. It seams that Oracle doesn't send password to SQL Server. How can I solve this? 

Andrija,
SQL Server is not getting a valid username and password.
Please verify that the username/password that was used in the DB link creation is valid in a valid username/password in SQL Server.
Vira

Thanks for replaying. It's obviou that SQL Server is note receiving correct user and pass. And I checked like 10 times username and password and it's OK. 

There is not enough information here to figure out what the problem could be. Please contact Oracle support for this issue.
Vira 

There is not enough information here to figure out what the problem could be. Please contact Oracle support for this issue.
Vira

Related

problem connecting from Oracle to SQL DB

Hi experts,
I am getting the following error when i am trying to connect to SQL DB from oracle DB uing DB link.
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user 'PTCTAS'. Reason: Not associated with a trusted SQL Server connection. (SQL State: 00000; SQL
Code: 18452)
ORA-02063: preceding 2 lines from AC
Actually that link is working fine till yesterday,but today we are getting this problem.I really need all experts help to solve this problem which is giving me really a hard time.
Thank you..

Error conection dblink windows2000 to sql-serever 2008 with windows2008 R2

Hi,
I receive the error below after a select is issued
ORA-28500:connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LIBRA'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from a ICARO
I have 2 dblink working correctly to others servers with Windows 2003 ;
and all file adjustments ( tnsnames.ora, listener.ora, initICARO.ora ) are fine.
The odbc works if i use it from microsoft access database.
and if i change the odbc with other sqlserver the dblinlk works too.
Any idea?
Best Regards. 
Have a look at the error message:
Login failed for user 'LIBRA'. (SQL State: 28000; SQL Code: 18456)
=> Is the userid on the SQL Server really in capital letters? Commonly a SQL Server userid and password is case sensitive and thus you need to surround the username and password in the create database link statement to preserver the case.
Example when the SQL Server userid is in lower letters = libra:
create database link icaro connect to "libra" identified by "<pasword for userid libra>" using '<your tns alias>'; 
The create database link is correct is quoted and lower case. 
Do you still get the same error message?
If yes, please post the message (just to cross check) and the create database link statement. 
Yes,
create database link dbicaro
connect to "LIBRA" identified by "pass" using 'icaro'; 
The SQl Server claims the user LIBRA is not allowed to connect to the SQL Server database.
In your create database link statement you have "LIBRA" which means the user is in capital letters. Is this really correct? Please have a look at the SQL Server directly by querying: select name from sysusers
Or you can also post the details from a working database link by querying the dba_db_links or user_db_links views. 
Well,i missed one step, in this server I didn't add the user like my others sql-servers XD
Thanks.

OWB Connectivity to SQL Server

Hello,
I'm having trouble connecting OWB (10.2.0.1.31) to our SQL Server. After creating the DB Link (setting the access to a fixed user), we can connect over and execute queries against the linked server.
That being said, however, I'm having issues connecting to this server under OWB -- the error message that the system is coming back with is:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ONYX_SA'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from OWB_346
the editor screen requires an input of both user name and password, but even if I put in the credentials used for the fixed user, I'm getting the message.
Any advise would be greatly appreciated.
thanks
Lawrence 
Does 'ONYX_SA' user has connection privileges into the sql server box and as well into the sql server database? I hope it does'nt exist. Check! 
Hi Zetabouy,
The onyx_sa user definitely has access to all the tables and views I would like to use since from SQL+ I can actually query all those tables.
At any rate, here's one for the books --- the password has to be encapsulated in double-quotes! I was reading another forum article and the recommended wrapping username and password around in double quotes (Re: SQL State: 28000; SQL Code: 18456 -error while connecting to SQL Server I tried that when recreating the database link, but it still didn't work.
finally, out of curiosity, I encapsulated the placed double quotes around the password in OWB's edit location, and that worked! I'd been banging my head over this for 2 weeks now and this eureka really made my day.
thanks for your suggestion.

ODBC error

hi i got a error!
i have to take data from sql server to oracle .
sqlserver is not in the local pc & the installation of sql server is mixed mode.
so what can i do now?
plz help !
the following errors are given below:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (SQL State: 28000; SQL Code: 18452)
ORA-02063: preceding 2 lines from SQL_SERVER_RAJ
:here sql_server_raj is a system dsn. 
This is not an Oracle Generic Connectivity issue, it's a common SQL Server configuration issue.
Please see the Microsoft Knowledge Base:
http://support.microsoft.com/kb/889615

10g link to SQL Server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

I have gone through the usual process to setup the HS link:
0. Setup DSN on oracle server machine (10g, winXP)
1. Modify the listener.ora, initMEDWORXX.ora, and tnsnames.ora files
2. Start Listener (successful)
3. confirm with tnsping (successful)
4. Create DBLINK --- creates successful ... but when I try to use it I get this error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from MEDWORXX.WORLD
.Looks like a user/psswd issue.
1. How do I specify the domain and username correctly in the DBLINK? If I leave out the double quotes, I get an error. Also the password is case sensitive.
CREATE DATABASE LINK "MEDWORXX.WORLD" CONNECT TO "DOMAIN\USERNAME" IDENTIFIED BY psswd USING 'MEDWORXX';2. I read somewhere about changing the oracle service to run as myself instead of the machine ... does that have anything to do with it?
Thanks
Jason 
Solved ... go into windows server and change the listener service to run as a specific user (myself) ... stop and restart service. !!

Categories

Resources