Kbase P127072: ODBC error "Server rejects connection on attach" when connecting to the database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/03/2010 |
|
Status: Verified
SYMPTOM(s):
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach.
Using sqlexplorer connecting logging in as root is successful.
ODBC Datasource defined to use sysprogress account.
No entries exist in _user table so sysprogress is inactive.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Attempted login with invalid login credentials.
FIX:
The SQL92 login authentication will use one of two possible methods to verify user authenticity.
1)
If no entries have been defined in the database user table (_user) then the database is queried to see what user created the database. The credentials of the user attempting connection are checked to see if the user is supplying the correct user and password of the user that created the database.
To perform this check, operating system libraries are used to interrogate the OS security system.
If the username and password are not correct based on the operating system, the user credentials supplied are considered invalid.
2)
If any entries have been defined, i.e. if even one user has been added to the user table (_user) in the database, then from that point forward only the _user table will be used to authenticate logins.