Kbase P25409: SQL connection returns message "Database not started" with a typical install
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/05/2009 |
|
Status: Verified
SYMPTOM(s):
SQL connection returns message "Database not started"
Unable to make SQL-92 connection to Progress database
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20055
[JDBC Progress Driver]:Database not started
BROKER 0: Broker could not execute %DLC%/bin/_sqlsrv2
Failure to connect any SQL client (ODBC,JDBC or ESQL/C) requests
Database has not been started to receive SQL client (ODBC,JDBC or ESQL/C) requests
There is no instance of _sqlsrv2 in the installation bin directory
FACT(s) (Environment):
Progress 9.x
Progress 8.x
All Supported Operating Systems
CAUSE:
When performing a typical installation of any Progress Product, SQL products will not get installed because they are an OPTIONAL component. This means that when the "Typical" installation option is chosen, all mandatory components and subcomponents are installed automatically, however optional components and subcomponents are not included in the installation.
FIX:
Uninstall and re-install Progress by selecting the COMPLETE install option so that the SQL components are installed on the server. This will then allow a SQL-server (_sqlsrv2 process) to be spawned by the login broker to allow SQL clients to connect to the database.