Book a Demo

Author Topic: WAN Optimizer - Connection problem  (Read 2555 times)

Joolz

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
WAN Optimizer - Connection problem
« on: April 08, 2011, 11:31:28 pm »
I have WAN Optimizer running on the same Windows 2003 server as my Oracle 10.2.0.4 database hosting the Enterprise Architect 8 repository.
I have created an ODBC System data source on my server, which connects to the database OK, and created a database manager using Oracle OLEDB which points at the ODBC data source.
When I try to access the repository from my EA client on a workstation I( get the message WAN OPTIMIZER: Unable to connect to database.
In the WAN Optimizer service log the following warning is reported:
SESSION_AUTHENTICATE_DB_FAIL [oraoledb.oracle.1:xxxxxx@xxxxx]. Error (5): Unable to connect to database.
(Sorry I can't provide the username and data source part of the connect information).
Client connects to repository directly, bypassing WAN Optimizer.

Would appreciate some advice.

Joolz

Joolz

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: WAN Optimizer - Connection problem
« Reply #1 on: May 26, 2011, 11:26:01 pm »
The failure to connect to the database was as a result of the parameter PERSIST_SECURITY_INFO=FALSE (the default value).
When creating a WAN Optimizer Database Manager set the parameter PERSIST_SECURITY_INFO to TRUE. This can be executed at the review stage just prior to Database Manager creation when using the wizard. :)