How to define login-string for Oracle transparent gateway to MS SQL-Server in trusted security mode

How to define the login string for a trusted connection throught the gateway to MS-SQL-Server?

I've installed the gateway on Oracle 7.2... (NT 3.51) an connected it to a MS-SQL-Server 6.0 what works in mixed security mode and it worked well using an non-trusted loginID.
Now the problem:
I've to connect to a MS-SQL-Server 6.5 what works in trusted security mode.

• The gateway works under "administrator" account on NT 3.51, "system" for ORACLE
• "Administrator" is no loginID on the NT-Domain, but on the NT-server (locally)
• LoginID on NT has the syntax T04-MASTER\TZHDEMO -> UserID on SQL-Server has to be T04#MASTER_TZHDEMO
• T04-MASTER\TZHDEMO is member of the global NT-Domain group G-PROJ-C
• G-PROJ-C is member of the NT-local Group L-PROJ-C what is known by the SQL-Server security manager (i.e., the trusted connection works if tested using ODBC)

ORACLE syntax to connect is
CREATE PUBLIC DATABASE LINK dblink CONNECT TO <<user>> IDENTIFIED BY <<pwd>>
USING 'MSQL';

1. if I define <<user>> as T04-MASTER\TZHDEMO, I get ERROR at line 1: ORA-00954: missing IDENTIFIED keyword
   -> so the syntax is wrong
   
2. if I define <<user>> as T04#MASTER_TZHDEMO and <<pwd>> as domain-pwd for <<user>>, I get Database link created.
   -> so the syntax is ok, and I try
   select * from t_zens_at_dblink; and I get ERROR at line 1: ORA-01017: invalid username/password; logon denied [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed ORA-02063: preceding 2 lines from DBLINK

It seems to be a problem using the NT-Domain/local usergroups for SQL-Server connected to the ORACLE gateway. Docu says nothing about my problem (or I used the wrong docu..). Has anybody experienced that problem and solved it?

What is the right syntax? What has to be done on the SQL-Server?

Thanks for every hint,

Thomas Greuter
Swiss Telecom PTT Received on Fri Mar 14 1997 - 00:00:00 CET