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"
*Cause:
*Action:
Error at Line: 1 Column: 35
The DG4MSQL configuration is here:
HS_FDS_CONNECT_INFO=[bsys-sql2]//SSU_PRD_APP/IntegrationStagingDb
HS_FDS_TRACE_LEVEL=OFF
HD_TRANSACTION_MODEL=READ_ONLY
#HS_FDS_DELAYED_OPEN=FALSE
HS_FDS_FETCH_ROWS=100
HS_OPEN_CURSORS=50
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: 192.168.10.179]
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!