Unable to connect to ZCM embedded Sybase database

  • 7008766
  • 09-Jun-2011
  • 27-Apr-2012

Environment

Novell ZENworks 11 Configuration Management Database (ZCM)
Embedded Sybase Database

Situation

When attempting to connect to an embedded Sybase database using dbisql the following error is displayed:

Could not connect to the database.
Database server not found
Ensure that the name in the "Server name" field is spelled correctly and that the database server has been started.

[Sybase][ODBC Driver][SQL Anywhere]Database server not found
Error code=-100
SQL state=08001


Using Tools > Test Connection shows:

Connection failed.
[Sybase][ODBC Driver][SQL Anywhere]Database server not found
Attempting to connect to a running server...
Trying to start SharedMemory link ...
SharedMemory link started successfully
Attempting SharedMemory connection (no sasrv.ini cached address)
Failed to connect over SharedMemory
Trying to start TCPIP link ...
TCP using Winsock version 2.2
My IP address is ...
TCPIP link started successfully
Attempting TCPIP connection (no sasrv.ini cached address)
Looking for server with name ...
Server not found (no reply received)
Failed to connect over TCPIP
Not attempting to autostart server
Cannot connect to server

Resolution

Complete the dbisql 'Connect' screen as follows:

Identification > User ID & Password:
Find the Sybase database credentials by running: zman dgc

Database > Server name:
database_server_ip_or_dns

Advanced > Enter connection parameters:
links=tcpip{host=database_server_ip_or_dns;port=2638;verify=no}


An alternative method is featured in TID 7007891
https://www.novell.com/support/search.do?searchString=7007891

This method will allow a dbisql connection from the Primary server hosting the database, but not from a non-database Primary.

Additional Information

dbisql is found is the following locations:
Linux: /opt/novell/zenworks/share/sybase/bin32s/dbisql
Windows: %ZENWORKS_HOME%\share\ASA\win32\dbisql.exe


If the verify=no parameter is omitted this message is seen whilst running Tools > Test Connection:
Found server, verifying server name
Verification of server name failed


For a resolution to this for previous versions of ZCM please see TID 7000764
https://www.novell.com/support/search.do?searchString=7000764