Kbase P149917: Getting error 1432 when trying to connect to the MS SQL Server through the MS SQL Server DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/07/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting error 1432 when trying to connect to the MS SQL Server through the MS SQL Server DataServer due to wrong password with SQL Server authentication
the ** Could not connect to server for database <DATABASE>, errno <ERRNO>. (1432)
FACT(s) (Environment):
The DataServer is remote to the MS SQL Server
The IP address of the MS SQL server changed
Reconfigured the same ODBC system DSN to reflect the correct IP address of the MS SQL Server
The ODBC DSN connects fine from the DataServer machine to the SQL Server machine using MS SQL Server authentication
UNIX client is connecting to the remote schema holder and the remote DataServer on windows machine
Windows
Progress 9.1x
OpenEdge 10.x
MS SQL DataServer
CAUSE:
The password for the MS SQL Server user is wrong on the ABL client startup parameter
FIX:
Make sure the password matches for the same user which is used on the ODBC DSN to successfully test connect to the SQL Server database from the DataServer machine