Ora-28500 with Ms Sqlserver - Not associated with a trusted SQL Server connec...

刘泽宇

现象：
When using TG4MSQL, this error occurs:
SELECT * FROM all_catalog@tg4msql
I get this error:
[1]: (Error): ORA-28500: connection from ORACLE to a non-Oracle system returned
this message: [Transparent gateway for MSSQL][Microsoft][ODBC SQL Server
Driver][SQL Server]Fehler bei der Anmeldung f�r den Benutzer 'USERNAME'.
Ursache: Keiner vertrauten SQL Server-Verbindung zugeordnet. (SQL State: 00000;
SQL Code: 18452) ORA-02063: preceding 2 lines from TG4MSQL

In English:
Unable to connect to server SERVER_NAME:

Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server]
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

原因：
A connection with a SQL SERVER user is not possible

If we test with ODBC Administrator, it's impossible to connect with 'sa' user.
Only Windows logon authentication runs.

处理方法：
To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use
the following steps:
1. Open the Enterprise Manager.
2. Expand a Server group.
3. Right-click a server name, and then click Properties.
4. Click the Security tab.
5. Under Authentication, click the SQL Server and Windows option button.
6. Restart SQL Server in order for the change to take effect.


MS SQL SERVER is configured to be used only with Windows logon authentication.
Oracle Transparent Gateway for MS SQL Server only supports SQL SERVER authentication with a login
ID and password.