6 Replies Latest reply: Jun 6, 2014 5:00 AM by user1949827 RSS

    Login Failed for User when connecting to SQL Server 2008 R2 via Gateway


      Hi - this is my first post!


      I'm having problems connecting to a 2008 R2 SQL Server database from Oracle 11g R2 database, using the gateway product.


      Previously, this has been working, but we've moved the SQL database from 2005 to 2008 (R2).


      We receive this error when trying to query across the link (Select * FROM DUAL@ADSRD)


      ORA-01017: invalid username/password; logon denied

      [Oracle][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLUSER'. {28000,NativeErr = 18456}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}

      ORA-02063: preceding 2 lines from ADSRD

      01017. 00000 -  "invalid username/password; logon denied"



      Error at Line: 1 Column: 35


      The DG4MSQL configuration is here:








      The database is hosted in its own instance on the bsys-sql2 server


      So...the event logs on the SQL server return this:


      Login failed for user 'SQLUSER'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT:]


      However the SQL Instance IS configured to allow mixed mode authentication.


      I cannot work out what I have missed, nor can I confirm whether I am actually just looking at a basic compatibility issue between the gateway software and the version of SQL server we are now trying to connect to.


      Help please!