Hi everyone,
I want to establish connection to a source database (SQL Server) running on another machine which is different from the one where I have the GoldenGate processes configured.
Currently I can connect to a SQL Server systems using ODBC drivers for replication purposes, and to a DB2 system using ODBC drivers for Extract purpouses.
However, when I configure a ODBC driver to use as extract a SQLServer system in another database, the following error occurs: "ERROR OGG-05209 Failed to open the SQL Server process {X}, with Windows system error 87".
I have followed all the GoldenGate installation steps for MS SQL Server in order to configure Extract process.
These is the current status:
- Privileges: user named "X" for source database is configured as "public" and "sysadmin".
- ODBC to other SQL Server systems works for the replication
- DSN is Native Client 11.0, and the test is successive
- The database is set to full recovery model
- Full database backup was already done, before starting Oracle GoldenGate processes for the first time
- Info trandata: Trandata enabled for the table
- The manager is running
- Authentication mode in Management Studio is SQL Server Authentication.
The Extract parameter file is configured like this:
EXTRACT EXTSQL
SOURCEDB SQLSERVER, USERID "X", PASSWORD ****
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL ./dirdat/ww
TABLE dbo.Persona;
Do someone have a clue of what is happening? Why can I user an external reference to extract data to a DB2 system, and can't do the same to a SQL Server system?
Thanks in advance,
best regards,
Andre