Kbase P134251: Getting errors 6179 2800 6142 trying to connect a remote MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/08/2008 |
|
Status: Unverified
SYMPTOM(s):
Getting errors 6179 2800 6142 trying to connect a remote MS SQL Server
Login was denied because of an authorization error. (6179)
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx\xxx'.
Failed to connect to the <db-type> database. (6142)
Failed to connect to the MSS database. (6142)
FACT(s) (Environment):
Using SQL Server Authentication
Using a 64-bits SQLServer ODBC driver
Have a local installation of a MS SQL 2005
MS SQL 2000
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
ODBC Data source DSN configurated using a 64-bits SQLServer ODBC driver
FIX:
Remove the 64-bits SQLServer ODBC driver and install a 32-bits SQLServer ODBC driver.