Jump to content
mmaurer

DB-Link to SQL-Server with Windows authentication.

Recommended Posts

Hi all,

 

we are trying to connect from Oracle 11g to an MS-SQLServer using ODBC.

 

The SQL-Server is configured with Windows NT authentication only (can not be changed).

 

The ODBC-Connection works,

 

All Oracle Parameters are set (listener, tnsname, hs-ini-file).

 

The database link brings the error message:

 

 

 

ORA-01017 – invalid username/password; logon denied

 

[Microsoft][ODBC SQL Server Driver]

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. {28000,NativeErr = 18452}

 

 

 

I can not find any Information about DB-Link with Windows authentication.

 

Is it possible in principle?

 

If yes, what do we have to do?

 

Is there a description for this?

 

 

Thanks in advance.

 

Manfred

 

Share this post


Link to post
Share on other sites

Hi Manfred, and welcome to the forum!

 

Linking from Oracle to MSSQL can be done, see my notes here:

 

http://www.dba-oracle.com/t_database_link_...rver_oracle.htm

 

First, verify that the link is okay via sqlplus:

 

Select * from mytab@mylink;

 

The Ora-01017, this is a common error, see solution here:

 

https://social.msdn.microsoft.com/Forums/sq...m=sqldataaccess

 

 

Good luck!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×